Getting a Variable that has a SELECT statement to Return Results

Hot Topic

HTTP Endpoint
Recovering SQL 2000 Database without the Log File not in clean disconnected state
Package Migration Wizard error -- Index was out of range
Generation of a report in background or asynchronously.?
Query on Custom source Component
Overflow error that doesn't make sense....
File storage with SQL server
Error:User does not have permission to perfor this action.
Trying to SET a variable from a SELECT
SQL 2005 how to change @conflict_retention for articles already published

SQL Server

Variables Not Seen In Custom DataFlow Destination
SQLEVN70.rll error
GetValue on a DTSProperty Object
Copying DB from one instance to another
How to add 'ALL' as report parameter in drop down with other parameters
Public role and explicit rights
Difficult Query
Notification Services and Full text search
snap shot agent refuses to snap new articles.
International Characters

Getting a Variable that has a SELECT statement to Return Results

I have concatenated a long Select Statement and assigned it to a variable. (i.e.)

@a = Select * from foo ---Obviously mine is much more robust

How do I execute @a to actually Select * from foo

Answer this question

Getting a Variable that has a SELECT statement to Return Results

Latif1
Perfect. Thank you.
cicorias

You can use

exec (@a)

If @a is nvarchar rather than varchar you can also do this

exec sp_executesql @a
Getting a Variable that has a SELECT statement to Return Results

Answer this question