FDiri
11/2/2016 - 3:08 PM

sql query to html table

sql query to html table

queryToHtmlTable.sql
content_copyfile_download
    SET @xml = CAST(( SELECT  TOP 10  '%'+CAST([BenzerlikOrani] AS NVARCHAR(20)) AS 'td' ,
                                '' ,
                                [FirmaAdi] AS 'td' ,
                                '' ,
                                [FirmaTamAdi] AS 'td' ,
                                '' ,
                                [FirmaEklenmeTarihi] AS 'td' ,
                                '' ,
                                [EkleyenKullanici] AS 'td' ,
                                ''
                      FROM      #SimilarRecords
                      ORDER BY  BenzerlikOrani DESC
                    FOR
                      XML PATH('tr') ,
                          ELEMENTS
                    ) AS NVARCHAR(MAX))
    SET @body = '<html><body><H3>Benzer Kayıtlar</H3>
<table border = 1> 
<tr>
<th> Benzerlik Oranı(%) </th> <th> Firma Ad </th> <th> Firma Tam Ad </th><th> Eklenme Tarihi </th><th> Ekleyen Kullanıcı </th> </tr>'    

 
    SET @body = @body + @xml + '</table></body></html>'