All Tags »
dynamic sql
Sorry, but there are no more tags available to filter with.
-
Arthur Jr:
you can create a temp table and dump the resultset return by that dynamic sql to that temp table
CREATE TABLE #temp(FieldValue varchar(250))
INERT INTO #temp EXECUTE('SELECT UserNameFROM UserTable')
SELECT * FROM #temp
but this make your life complicated. refrain from using dynamic sql as much as possible.
I will ...