How can I insert the results of a query into another table?

TIA
RC-

See Books Online for the topic

SELECT INTO

Chris

"RC-" <r_candee (AT) hotmail (DOT) com> wrote

This is a DTS group, but it would be a watse of effort doing this in DTS.


Try using pure T-SQL-

INSERT Results (C1, C2)
SELECT C1, C2
FROM Table
WHERE C1 = 'X'



"RC-" <r_candee (AT) hotmail (DOT) com> wrote