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

http://www.insidesql.de

http://www.familienzirkus.de