Posts by Luis Gomes • 11 points
4 posts
-
0
votes1
answer56
viewsA: Substring to format date within MAX and MIN
Artur, regarding the display of the data field... just put a FORMAT output, example in sql server SELECT GETDATE() AS 'SEM_FORMAT', FORMAT(GETDATE(),'dd/MM/yyyy','pt-br') AS 'COM_FORMAT'; Now, if…
-
0
votes1
answer22
viewsA: Adding Amount of Input per month and customer
Late, the error is in Group BY, change to GROUP BY MONTH(TMOV.DATAOUTPUT) SELECT MONTH(TMOV.DATASAIDA) AS MES, SUM(TITMMOV.QUANTIDADE) AS QUANTIDADE FROM DBO.TMOV INNER JOIN DBO.TITMMOV ON…
-
0
votes1
answer26
viewsA: How to make an SQL Server table read UTF8 text correctly
Good afternoon! Your problem is the COLLATION in the table... Testing with COLLATION Latin1_general_ci_as Upshot I changed the collation in create table, because once I do not explain the collation…
sql-serveranswered Luis Gomes 11 -
1
votes1
answer58
viewsQ: Lowest value (DAX variables)
I need to create a measure (MAX) that calculates the smallest among several variables, also what we have in Excel called "SMALLER"... My attempt is as follows ("Unsuccessful") M_Teste = var v1 = 10…