Store procedure help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Store procedure help

Author

Topic

tsaliki
Starting Member

19 Posts

Posted - 2012-10-05 : 00:39:56

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

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-10-05 : 01:34:15

CREATE PROCEDURE AS
select [name],jobname,time FROM testjob

This will create the store procedure. Pass the results into a recordset object at the application layer and format as required

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources