>>>>It looks like I can't select from a cursor in SQL Server - If I can, tell me how - so, I need to write the results of a SQL to a table in the existing database. Then I can run SQL against that. How do I do that?
>>>
>>>Look at INSERT ... SELECT syntax (the same as in VFP, if I recall correctly).
>>>
>>>If you need to create a new table, then you also can use INTO TABLE syntax of SELECT-SQL. The catch is to put INTO TABLE right after the FROM keyword, not after WHERE as in VFP.
>>
>>This returns an error (see below the SQL):
>>
>>

>>	Select Distinct
>>		(P.ChartID),
>>		'0' AS Processed
>>		From NTSERVER.IMPACTMD.dbo.Patients P
>>		Into Table NTSERVER.IMPACTMD.dbo.ChartID
>>			Inner Join NTSERVER.IMPACTMD.dbo.Doc_Header H
>>				On H.PatientID = P.PatientID
>>

>>
>>

>>Msg 156, Level 15, State 1, Line 44
>>Incorrect syntax near the keyword 'Into'.
>>

>
>

>Select Distinct  (P.ChartID),
>		'0' AS Processed
>Into NTSERVER.IMPACTMD.dbo.ChartID
>   From NTSERVER.IMPACTMD.dbo.Patients P
>			Inner Join NTSERVER.IMPACTMD.dbo.Doc_Header H
>				On H.PatientID = P.PatientID
>

Cetin

The INTO had to come before the FROM?