I'm sorry, thanks Jeff.  Sorry Phil.  I thank you for your inputs.  I'll try your solution Phil...now that I see what you're doing there.  Thanks!!!

I have a few questions on your solution

set nocount on

Create table #tmp (
 AcctID int
 , Zip varchar(10)
 , Phone varchar(20)
)

>>>  what if I have 650,000 records in my...

You have to understand, this is not a database, it is just some temp tables I'll create to create my final table wich will then be used to create a...

I'm just not getting through here.  I don't want to have to hand code each insert.

I have to select more than 650,000 records from one table.  Then I have to...

extending on above.  So again lets' say I have these records in my result set

AcctID     Zip     Phone

11212      23332   333-444-5555

23223      34434   444-333-5545

12123      64554    554-344-3334

I need to create a flatfile in the end. ...

What I have to do for this  project is take a bunch of records.  For each record, I have to insert a new record for each field of that record...

for example:

WHILE @@FETCH_STATUS = 0

BEGIN

...

     For each column in current cursor row    <---- not sure how to code this part is what I'm referring to

       ...

I don't necessarily need an alternative solution here.  Just as a cursor can move through each row, what about each column in a row! ??

forget everything else.  all I am asking here is how to loop through each field in the row in my cursor for that row...move to the next row in my...