Author |
Topic |
tsaliki
Starting Member
19 Posts |
Posted - 2012-10-09 : 08:17:55
|
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 have a query as below:select jobname from testjob where jobid in (select items from dbo.split('1001,1005',','))the output is as below:JobnameJavaworksql workInstead i want the output beside like this : i.e i want it side by side.JobnameJavawork,sqlwork |
|
sql-programmers
Posting Yak Master
190 Posts |
Posted - 2012-10-09 : 08:40:20
|
Hi Try This,SELECT (SELECT CAST(a.jobname AS VARCHAR) + ',' FROM testjob a WHERE a.jobid in (select items from dbo.split('1001,1005',','))FORXML PATH('') ) AS jobnameSQL Server Programmers and Consultantshttp://www.sql-programmers.com/ |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2012-10-09 : 08:42:12
|
;With cte as (SELECT jobname from testjob where jobid in (select items from dbo.split('1001,1005',',')))SELECT STUFF((SELECT ',' + c.jobnameFROM cte cFOR XML PATH('')),1,1,'') AS CSV--Chandu |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|