Microsoft SQL Server forum - The select statement is in a field

Author

The select statement is in a field

George o

2005-08-31, 1:24 pm

Ok, I inherited this database and there is a field that stopres a select
statement. Is there anyway possible to execute the value of the field
within a select statement?

For example:

the table:
Name "george"
lookupForName "Select orders from Ordertable"

So maybe something like select name, execute(lookupfornam
e) as orders

Sorry, I didn't design this, just inherited :)

george

Erland Sommarskog

2005-08-31, 8:23 pm

George o (george.nospamogrady@hp.com) writes:
> Ok, I inherited this database and there is a field that stopres a select
> statement. Is there anyway possible to execute the value of the field
> within a select statement?
>
> For example:
>
> the table:
> Name "george"
> lookupForName "Select orders from Ordertable"
>
> So maybe something like select name, execute(lookupfornam
e) as orders

You would have to do something like:

SELECT @sql = lookupforname FROM tbl WHERE name = 'george'
EXEC(@sql)

If you really want to add another column to that result set, it may get
ugly. If the SELECT statements does not have a WHERE clause you could
add "CROSS JOIN (SELECT name = ''george'')". Else you have to splice
it in into the query.

For more information on dynamic SQL, see this article on my web site:
http://www.sommarskog.se/dynamic_sql.html.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Sponsored Links