| Author |
 Topic  |
|
|
tsaliki
Starting Member
India
11 Posts |
 Posted - 10/09/2012 : 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:
Jobname
Javawork
sql work
Instead i want the output beside like this : i.e i want it side by side.
Jobname
Javawork,sqlwork |
|
|
sql-programmers
Posting Yak Master
USA
189 Posts |
Posted - 10/09/2012 : 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',','))
FOR
XML PATH('') ) AS jobname
SQL Server Programmers and Consultants
http://www.sql-programmers.com/ |
 |
|
|
bandi
Flowing Fount of Yak Knowledge
India
1396 Posts |
Posted - 10/09/2012 : 08:42:12
|
;With cte as (SELECT jobname from testjob where jobid in (select items from dbo.split('1001,1005',',')))
SELECT STUFF(
(SELECT ',' + c.jobname
FROM cte c
FOR XML PATH('')),1,1,'') AS CSV
--
Chandu |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47036 Posts |
|
| |
Topic |
|
|
|
Split function help
