How To Use Loop IN Sp or UDF Sql Server

Question

i am trying to pass id to Sp then it will first get id's against it and then get data against those id using SP or by using UDF as i trying it by

select RequestFrom from UserReqest where RequestTo=10 and IsApprove=0

select * from user where user_ID= (i have to use all five id's here ?)

Hopes for your suggestions

Thanks in Advance

SWeko · Accepted Answer · 2013-01-04 12:13:43Z

3

There is an IN operator in SQL that does what you want:

select * 
from user 
where user_ID in (select RequestFrom 
                    from UserReqest 
                    where RequestTo=10 
                      and IsApprove=0)

answered Jan 4, 2013 at 12:13

SWeko

30.9k11 gold badges74 silver badges107 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How To Use Loop IN Sp or UDF Sql Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related