rodeomount
Programmer
I have a variable called @FilterCmd wher I am creating a query based on many different factors. The query is a select query. I tried running the query like so:
exec @FilterCmd
But I get an error. How can execute this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Executing a query held in varchar variable
- Thread starter rodeomount
- Start date
- Status
I have a variable called @FilterCmd wher I am creating a query based on many different factors. The query is a select query. I tried running the query like so:
exec @FilterCmd
But I get an error. How can execute this?
- Status
Similar threads
- Locked
- Question