SQL Server 2000 DTS package, filter rows using stored procedure returned date
In SQL Server 2000, you cannot use the results of a stored proc directly in another query. However, you can insert them into a #temp table and then join to that. But you must create the temp table structure first, you can't use select into.