I guess this is expected behaviour. You can't use @TEMP to pass more than a single value. It will not be correctly interpreted as a list of values.
This might be interesting http://www.algonet.se/~sommar/arrays-in-sql.html for you.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]