Hi, I ran into an issue and am stuck. I am trying to insert a select statement into a table variable. --select statement is the following
--I declared the table variable below
How Can I make this work??
(comments are locked)
|
You just need to reorder your statements. Declare the temporary table first and then do an INSERT using the SELECT as the operator that will provide the values for the INSERT. For example:
Hope this helps!! Thanks that fixed it
May 02, 2012 at 09:29 PM
tombiernacki
Thanks that fixed it
May 02, 2012 at 09:30 PM
tombiernacki
Awesome!! Glad it worked for you!
May 03, 2012 at 01:45 AM
JohnM
(comments are locked)
|