views:

8

answers:

0

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

related questions