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.