Hi there, what I'm interested in is the final row of the table. Instead of having a few empty cells to the left of "total" I was hoping that I could use colspan to make it look a lot nicer.
SET @html = @html +
CAST((
SELECT
td = ' ', ' ',
td = ' ', ' ',
td = ' ', ' ',
td = ' ', ' ',
td = 'Total', ' ',
td = COUNT(*), ' '
FROM ##temp
FOR XML PATH('tr'), TYPE
) AS NVARCHAR(MAX) );
Regards, Alex