[dba-SQLServer] Ho To: Create a Stored Procedure using a parameter for IN

Robert L. Stewart rl_stewart at highstream.net
Sat Feb 14 16:29:52 CST 2004

Sometime I think I go brain dead.  ;-)

I am trying to do a stored procedure with a simple SQL statement

SELECT ClientID, LastName, FirstName, ResidenceType
FROM tblClient
WHERE ResidenceType IN(@ResType)

I need to be able to pass something like:

house, hotel, homeless

and get a list of people with that residency type.  Nothing I have
tried has worked.  Can anyone give me some direction on doing this?


Robert L. Stewart
The Dyson Group
Expanding your sphere of Knowledge

More information about the dba-SQLServer mailing list