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

Djabarov, Robert Robert.Djabarov at usaa.com
Mon Feb 16 09:39:11 CST 2004

Of course, you can do:

Exec ('select ... from tblClient where ResidencyType in (' + @ResType +

But we all know what THIS means, right?

I'd parse @ResType into a temptable, and then replace your WHERE clause
with INNER JOIN on that table.  Works like a charm every time :)

Robert Djabarov
SQL Server & UDB
Sr. SQL Server Administrator
Phone: (210)  913-3148
Pager: (210) 753-3148
9800 Fredericksburg Rd. San Antonio, TX  78288

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Robert
L. Stewart
Sent: Saturday, February 14, 2004 4:30 PM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Ho To: Create a Stored Procedure using a
parameterfor IN

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

dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com

More information about the dba-SQLServer mailing list