asimkumar.munshi (4/9/2009)
The first method does not work for me...so...what if i have multiple selects in the inner query...I am selecting like 20 columns in the select...The second method is not what i want...my inner query is far more complex....I want to count the rows of a result set.
You'd get much better answers if you provided the actual requirements instead trying to simplifying and then trying to take that to a more complex environment.