asked
help to Display the table in html format using sql server
i have a table like below: create table testjob (jobid int, jobname varchar(100), time float, name varchar(50) ) insert into testjob values ( 1001,'java work',4.5,'arjun') insert into testjob values ( 1005,'sql work',10,'arjun') insert into testjob values ( 1010,'.net work',7.5,'arjun') insert into testjob values ( 1040,'java work',5.5,'ravi') insert into testjob values ( 1023,'php work',2.5,'arjun') insert into testjob values ( 1027,'.net work',3.5,'ravi') i want a procedure so that my output is as below in the html format like below that is in sql we will write `select * from testjob` but i want the output to be displayed in html using stored procedure or so Name Jobname Time arjun Javawork 4.5 arjun sql work 10 arjun .net work 7.5 ravi java work 5.5 arjun php work 2.5 ravi .net work 3.5
Hi, This [blog][1] should help you get the desired result. Personally I prefer the devs to handle the output. The only time I use this in when I create a email notification from a SQL agent jobs and I need to to look "pretty" with tables and rich text. [1]:
http://jahaines.blogspot.co.uk/2010/04/t-sql-tuesday-005-creating-emailing.html
9 People are following this question.
