concatenate group of numbers into a string

Question

0.00/5 (No votes)

See more:

Hi frens

I ve a query which returns a set of IDs ex: str abc= select id from employee where salary>1000

I have to pass these values(ie, abc) into the other query ( ex: select * from [Table] where id IN (1.2,3,4 ) ....

How to get those ids as a comma separated ids

Please suggest me guys

thanks
darshan

Posted 29-Jan-13 4:53am

darshan559

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

fjdiewornncalwe · Answer 1 · 2013-01-29T05:00:00

Solution 1

I found this answer to a similar question: sql-how-to-concatenate-results[^]

SQL

declare @result varchar(500)
set @result = ''
select @result = @result + ModuleValue + ', ' 
from TableX where ModuleId = @ModuleId

Posted 29-Jan-13 5:00am

fjdiewornncalwe

vivek511 · Answer 2 · 2013-01-29T16:58:00

Solution 2

According to me kindly try below Sql string:

Select * from [Table] where id IN (1.2,3,4 ) and salary>1000

Posted 29-Jan-13 16:58pm

vivek511

Updated 29-Jan-13 16:59pm

v2

Aarti Meswania · Answer 3 · 2013-01-29T18:30:00

Solution 3

easy... do not need to do more code...
just write directly your query as subquery inside "in" clause :)

SQL

select * from [Table] 
where id IN (select id from employee where salary>1000)

Happy Coding!
:)

Posted 29-Jan-13 18:30pm

Aarti Meswania

concatenate group of numbers into a string

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

concatenate group of numbers into a string

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us