Ok I know I can do this in Access if I setup the first query, then have the second query use the results of the first, and so on.<BR><BR>However, I need to do this entirely with SQL so that the ...

Ok, I'm trying to write a query in a stored procedure in SQL Server 2000. Because some of the parts of the query vary based on certain situations I construct a string that contains the query and then ...