Posts by Wallace Carlos • 93 points
7 posts
-
1
votes1
answer1719
viewsQ: How to sort varchar field with letters and numbers in sql server
I have the following query below and would like to sort according to the image, however the numbers. WITH cteNiveis(IdConta, NivelRec, NomeTab, Caminho, Nivel, Tipo, Status, Nome) AS ( SELECT CO.Id,…
-
1
votes0
answers106
viewsQ: Jquery Autocomplete with Sequence Selection
I have a text field in the sql server database varchar (MAX). I am using Jquery and C# to make an autocomplete. This is populated through a "autocomplete.ashx" file called by jqyery. My field in the…
-
0
votes1
answer271
viewsQ: Query sorting - sql server
I need to sort my query so that the column "Centername" is in accordance with the logic applied in the column "All levels" someone could help me please? WITH CentroNiveis AS ( SELECT cen.Id,…
-
0
votes2
answers437
viewsA: Sorting in recursive query
I got a solution that met my needs. Thank you Gypsy, your help was of great value. Follow the code below if anyone has the same question. USE TESTE GO WITH Niveis AS ( -- Membro âncora SELECT Id,…
-
1
votes2
answers437
viewsQ: Sorting in recursive query
In another question I asked i had found a solution but ordering only works if the ID’s are growing: USE TESTE GO WITH Niveis AS ( -- Membro âncora SELECT Id, IdPai, convert(varchar(1000), Nome) as…
-
4
votes1
answer5879
viewsQ: Recursive query
I need to mount a recursive query to solve a simple problem, but I’m having a little trouble. I have a table called TABELA1 with the following fields (ID, IDPAI, NOME) I will put here some examples…
-
2
votes2
answers803
viewsQ: Error 4 The type 'System.Data.Entity.Dbcontext' is defined in an Assembly that is not referenced
I have looked for several solutions to this error on the internet and unfortunately nothing helped me. Can anyone help me on how to fix this mistake?? Error 4 The type 'System.Data.Entity.Dbcontext'…
entity-framework-6asked Wallace Carlos 93