How to use EXEC Query with Select Statement in sql server 2008
===

How can i use an  EXEC(@query)  with another select statement in sql 2008

eg: @query = 'Select col1, col2, etc from Table'


I need this EXEC(@query)  with another select statement.

plz help me...