sql query to Display the table in html format using sql server

kavuri

New Member
I have a table like this:\[code\]create table testjob( jobid int, jobname varchar(100), time float, name varchar(50) )\[/code\]and sample data in that table:\[code\]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')\[/code\]I want to create 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\[code\]Name Jobname Timearjun 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 \[/code\]
 
Back
Top