Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements. The statements use a SQL string varchar data type, then you execute the ...

(SQL Server 2000)<BR><BR>I have a query that basically selects a lot of "complicated" stuff and then dumps it into a #temp table.<BR><BR>I then have a correlated subquery that runs against the temp ...

Let's say the table only has 8 rows. etc... so each and every possible combination. I THINK this will end up with 16,777,216 possible combinations when I'm done. Now I could just write 8 queries that ...