Posts by Julio Cesar Andrade • 77 points
6 posts
-
0
votes1
answer65
viewsQ: Cursor search: the number of variables declared in the INTO list must match the number of columns selected
Hello! I made a T-SQL and at the moment execute is giving the message: Message 16924, Level 16, State 1, Line 58 Cursor search: the number of variables declared in the INTO list must match the…
-
1
votes2
answers74
viewsQ: Data Conversion in SQL server 2008
Hello! I need to do a data conversion in SQL Server 2008 from the "data field". Could someone tell me how this can be done? I tried so: select distinct c.Empresa, p.Nome,…
-
1
votes1
answer54
viewsQ: SQL - Group information and Do not repeat
I’m doing an SQL where I need to show the purchase orders. However a purchase order, can have several quotations and do not want to keep repeating the quotations, I want to bring me the quotation…
-
0
votes1
answer32
viewsQ: Select Same Field
Hello! I need to make an SQL that gives me the result and I wish in the same line. Today SQL is skipping a line. I need you to stay on the same line. select c.empresa, p.nome, (select…
-
1
votes1
answer55
viewsQ: Number conversion
How do I convert a number float to keep the characteristics of numbers for the end user read? I am putting together a report and I wish to deal with the figures. I have a field where the value is…
-
-1
votes2
answers1108
viewsQ: Command to set a default value for a column in SQL Server
Hello, I want to know the command to set a value like default in SQL server. The table name is "Table" and the column name you want to change is "COLUNA2".