stored procedure parameter in the IN clause

[MatthewS]

This is in SQL2000 ex.

create procedure ... @Name varchar(254), @Date smalldatetime

Select.......
Where (db.Name IN (@Name)) AND
(db.Date = @Date)

@Name = ('George', 'Mike')
SQL does not return any data to my query
if I remove @name and hard code ('George',.... then it works just fine. I have been trying for a while to figure this out. If anyone has any suggestions I would appreciate it.

Thanks in advance
MatthewS

 

[TomSark]

Either use a sub-query as in:

Where (db.Name IN (SELECT Name from table where Name = @Name)) AND (db.Date = @Date)


or set it = to a single value as in:
Where (db.Name = @Name) AND
(db.Date = @Date) Tom Davis
tdavis@sark.com

http://www.sarkdallas.com

 

[TomSark]

Either use a sub-query as in:

Where (db.Name IN (SELECT Name from table where Name = @Name)) AND (db.Date = @Date)

set it = to a single value as in:

Where (db.Name = @Name) Tom Davis
tdavis@sark.com

http://www.sarkdallas.com

 

[TomSark]

Wow... somehow the server freaked and posted both of these messages... sorry for the redundancy... ;-)

Tom Davis
tdavis@sark.com

http://www.sarkdallas.com