I have the following query:
SELECT UPPER(admatribuido) AS [admAtribuido],
Count(admatribuido) AS [quantidade_admAtribuido]
FROM ##tmp
WHERE Month(dataabertura) = Month(Getdate())
AND Year(dataabertura) = Year(Getdate())
AND admAtribuido <> 'null'
GROUP BY admatribuido
Which brings me the following return:
Iwouldliketoconcatenateadash"-" and the assigned_qualum in the assignedAutomation, for example:
admAtribuido | quantidade_admAtribuido
ANA PAULA SOARES - 100 | 100