Thanks much.

I have never used updadate statement in this format. Should have looked up BOL. Thanks.

No thanks. This should do.

Like in a seperate select statement. Like

SELECT * FROM products WHERE categoryid = 1

SELECT * FROM products WHERE categoryid = 2

To use it in ASP.Net like this, DataReader.NextResult().

You mean like this

EXEC ('SELECT * FROM users WHERE...some conditions...INTO @usertable')

This is the error I get Incorrect syntax near the keyword 'into'. The select statement is built dynamically with some...

Thanks.

The table is always the same, I know which table to query. Only the where clause changes based on some parameters.

Works great. Thanks.

No, its not just a row count. The dynamic sql has some where conditions 'SELECT COUNT(*) FROM table1 WHERE...'

May be I can execute the sql and pass the count as...

This is what I initially thought of. Its part of a big stored procedure. I am just curious if I can do it in one statement, to reduce the clutter....

No but I still want to update the detail even if the price is null. I think the above statement either updates both detail and price or updates neither.

Thanks.

I am sorry I had 'self join' in the title. It doesn't matter whether it is a self join, I just want the correct results.

Well, the result cannot be more than 40,000, no matter how many users has how many records. I am not sure I explained myself clearly. The total records in the...

It is not returning correct results. There is 40,000+ records in the table, the query returns 180,000+ records.