How to loop a temp table?

On Jun 15, 5:34 am, Daniel Badger
wrote:
> I have a statement in my stored procedure that has the following as an
> example -
>
> INSERT #TempTableOutput
> EXEC (@select + @from + @where + @order)
>
> How could I then loop through the records of #TempTableOutput to update some
> blank fields that were created in the intial select statement?


Create an identity column in #TempTableOutput and loop through
Provide column names in INSERT #TempTableOutput (col1,ol2 ..) .
Don't put the identity column in the column list
 >> Stay informed about: How to loop a temp table? 

>> INSERT INTO #TempTableOutput
EXEC (@select + @from + @where + @order);

How could I then loop through the records [sic] of #TempTableOutput to
update some blank fields [sic] that were created in the intial select
statement? <<

Columns are not anything like fields; rows are not anything like
records. Materializing a temp table is a bad programming practice to
be avoided. Dynamic SQL is a bad programming practice to be avoided.
You have no idea what the result will be until run time! You cannot
even give this thing a valid data element name (is it Briteny Spears,
automobiles or squid this execution?)

Wha you have is an attempt to mimic a scrath tape the way we did with
1950's-60'S programming languages when storage was limited. This is
not RDBMS at all!

What are you actually trying to do? You probably need more help than
you will find in a newsgroup, but we can try.
 >> Stay informed about: How to loop a temp table? 

On 15 Jun, 01:34, Daniel Badger
wrote:
> I have a statement in my stored procedure that has the following as an
> example -
>
> INSERT #TempTableOutput
> EXEC (@select + @from + @where + @order)
>
> How could I then loop through the records of #TempTableOutput to update some
> blank fields that were created in the intial select statement?

This is a bad idea. Either change the INSERT ... SELECT statement so
that the table is populated with the right data to start with, OR use
a single UPDATE statement to update the temp table.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
 >> Stay informed about: How to loop a temp table?