In SQL 2000 you can use XML. See
Re: Selecting records based on cursor values Message #
690890 for sample code..
>I need to create a variable in a stored procedure that will be used in a temporary table within that procedure (see example below). Does anyone know how I can select several variables within the query?
>
>
>CREATE PROCEDURE sols_details @supp varchar(255),@tdEndDate DATETIME
>
>SELECT * INTO #supp
>FROM suppliers
>WHERE supp_code IN ('??','??')
>
>SELECT * FROM #SUPP etc
--sb--