I need some help with TSQL. I want to run the following on a remote SQL. It currently works and correctly returns the data. However, I want it to write the recordset to a new table 'Temp_MailMerge_Table' . AS the name implies, its so as I can use it for a mail merge in WORD 2007.
FROM Tbl_Users us
Left JOIN Tbl_Parents pa ON
us.User_ID = pa.Parents_UserID
WHERE us.User_Type = 3
'NOT sure how this bit is written in TSQ
1 - Empty Temp_MailMerge_Table
2 - PUT this data into Temp_MailMerge_Table