or Change DATEPART to DATEADD(MM, DATEDIFF(MM, 0, AdmissionDate ), 0) to get the First of the month in datetime format (if you need to show the year) and group by...

Maybe use a CHECKSUM / BINARY_CHECKSUM on the GUID? Not exact though but could be used with something else maybe??

Hi Michael,

You are better off with using an OR to choose the criteria as you suggested. The code below will identify any Tag fields with the exact 'AB', 'AB' with...

I would personally use the Partition By Null as follows if you want just an overall total.

SELECT DISTINCT(A.Name), Count(A.Name), A.Total

FROM

(

SELECT Name, Count(*) OVER (PARTITION BY Null) AS Total FROM Temp

)...

Thanks for your help Brandie, I have adapted the coalesce code, which works a treat!!

Now I have one small problem, my intention was to use a CTE for the base...