SQL-Talkers: I have a stored procedure that I'm trying to pass a list to. I tried to set:
@idlist varchar and @idlist int I need to use the list in an IN statement, like: where periodID IN ( @idlist ) When I have it set to varchar, I get a conversion error. When I set it to int, the query runs, but never returns anything. Any help would be appreciated. Thanks. Joel ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
