Posts by Thais • 93 points
5 posts
-
2
votes1
answer2559
viewsQ: Limit characters and character type
I need some help. I have a spreadsheet this way: And I want to limit the amount of characters and the type In the segment column I want to limit it to 6 characters if it is less than 6 or more than…
-
0
votes1
answer80
viewsQ: Select data from last database file and select file data from time before last. Compare Data
After fetching two uploaded files, I go to the table to compare the data within them Amid 8: 50 e 23: 50 (with an interval of one every hour) it performs a check in a file of that bank that I call…
-
3
votes3
answers5999
viewsQ: several values for a column in Where
Is there any way to put several values for a column in WHERE? For example product A was replaced by product B, product 2933 for the 4044, product 2599 for 7845, and product 5987 by 9432. Example:…
-
1
votes1
answer1197
viewsQ: Delete Duplicate Records by Group BY
Good morning, Does anyone know if there is a possibility to delete duplicate records as follows: I have a query that brings the result All fields repeat themselves except the NDO field, and…
-
0
votes1
answer1537
viewsQ: Media calculation between SQL Selects
Good Afternoon Please help me out Error in the Syntax Msg 102, Level 15, State 1, Line 2087 Incorrect syntax near 'TAB'. --TARIFAS --Calcular Média Tarifada BEGIN TRY DROP TABLE #TARIFASINDMETRO END…