Posts by Alexandre Gonçalves • 31 points
7 posts
-
0
votes3
answers1155
viewsQ: Bring more than one line into a Subquery Sql Server
I am working with 2 consultations and would like a way to unite the 2 in one, however I am having difficulties. I have the following example: Table T1: CD PF Data Total 1 JSL001 15/03/2018 100 Table…
-
0
votes2
answers2827
viewsQ: SQL Server Create a filter in a Datetime field, bringing the previous 24 hours (not counting the current time)
Good evening, I’m having trouble putting in a date filter, I have a query where I bring the information of CD, Crane and Dtregistro (datetime) In this query I am already filtering the 24 hours…
-
0
votes2
answers9649
viewsA: Automatically fill cells in excel using VBA
If it is something simple and fixed, just create 4 "Ifs" of these: If Range("b5") = 1 Then Range("g5,H5, I5,J5, G6, H6, I6, g7, h7, g8") = 1 End If
-
0
votes1
answer95
viewsQ: SQL SERVER Counting Items from a Calculated Field
Good afternoon, I’m having a hard time doing an item count on SQL SERVER, I need to count a column that MYSELF CREATED, where there is a rule, and there are several errors in my tests, errors in…
-
0
votes2
answers311
viewsA: Bring the count of the word "DATA" from a column calculated in SQL Server
Good afternoon, I tried to use this example, but I’m still in some trouble, I can’t bring the data, give this error: "Windowed functions cannot be used in the context of Another Windowed Function or…
-
1
votes2
answers311
viewsQ: Bring the count of the word "DATA" from a column calculated in SQL Server
Good morning, I have a query that brings in a column calculated the information of "Data" and "Historicos", in this column I have the item Prefix (vehicle plate) and the column with the respective…
-
0
votes1
answer147
viewsQ: Bring the word HISTORICAL when the line date is less than the previous dates,
I have a query where I should register the lines with error with the word Historical, the lines that bring the date LESS than any of the dates of the previous lines should present the word…