XSL-трансформация на MS SQL без CLR

declare @date datetime
	,@tableHTML  NVARCHAR(MAX)
	,@emails NVARCHAR(MAX)
	
set @emails='nov@m'

SET @tableHTML =
    N'<H1></H1>' +
    N'<table bordercolor="green" border="2">' +
    N'<tr bgcolor="#F7FF47"><th>Îòäåë</th><th>ÔÈÎ</th>
    <th>Ïåðâûé ïðîõîä</th>
    <th>Ïîñëåäíèé ïðîõîä</th>
    <th>Âðåìÿ ðàáîòû</th>
    </tr>'


select @tableHTML =@tableHTML +CAST(
(---------------
select
td=t.[dep]
,'' ,td=t.[name]
,'' ,td=t.[starttime]
,'' ,td=t.[endtime]
,'' ,td=t.[work]
,''
from (
----------------- 
SELECT 
dep
,name
,convert(varchar(20),starttime,120) as starttime
,convert(varchar(20),endtime,120) as endtime
,convert(varchar(20),(endtime -starttime),108) as work
FROM table
---------------
) as t
order by t.dep
for XML PATH('tr'), TYPE
)
as nvarchar(max))


select @tableHTML=@tableHTML+
    N'</table>' +
    N'<HR>'+
    N'<b>Regards</b>';

--select @tableHTML

 
EXEC msdb.dbo.sp_send_dbmail
	@profile_name = 'm',
	@recipients=@emails,
    @subject = 'Report',
    @body = @tableHTML,
    @body_format = 'HTML' ;