Never mind. We'll do it both ways.

Since you're a tester and don't know much about SQL Server or SSMS, we'll do this as simply as possible.

Paste the following code into SSMS on same window that create the #Temp table, highlight the code, and then press the f5 key. Copy the output from the results and paste into notepad. Save the notepad file.

--===== Comment out from here through UNION ALL

-- if you don't want column headers.

SELECT 'Offer_ID' + '|'

+ 'Reserveration_Num' + '|'

+ 'Personal_ID' + '|'

+ 'Acct_Nbr_HE' + '|'

UNION ALL

SELECT CAST(Offer_ID) AS VARCHAR(8000)) + '|'

+ CAST(Reserveration_Num) AS VARCHAR(8000)) + '|'

+ CAST(Personal_ID) AS VARCHAR(8000)) + '|'

+ CAST(Acct_Nbr_HE) AS VARCHAR(8000)) + '|'

FROM temp

;