Concatenate SQL Server

Question

I have the following appointment:

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

That brings me the following return:

I would like to concatenate a dash " - " and the quantity_admAtributed in the admtributed, for example:

admAtribuido              |   quantidade_admAtribuido               
ANA PAULA SOARES - 100    |   100 

Answer 1

SELECT concat( UPPER(admatribuido), ' - ',cast([quantidade_admAtribuido] as varchar(100)))        AS [admAtribuido], 
   Count(admatribuido) AS [quantidade_admAtribuido]

Use the Concat function as in the above example

Answer 2

Uses the default concatenation operator of MSSQL, the "+":

1 - With the 2 fields:

SELECT (UPPER(admatribuido) + ' - ' + Count(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

2 - With 1 field:

SELECT (UPPER(admatribuido) + ' - ' + Count(admatribuido)) AS [admAtribuido]
FROM   ##tmp 
WHERE  Month(dataabertura) = Month(Getdate()) 
       AND Year(dataabertura) = Year(Getdate())
AND admAtribuido <> 'null'
GROUP  BY admatribuido

This solution applies to these applications below:

SQL Server (as of 2008) Microsoft Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse