>>>>>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?

Yes, I was wrong in my original statement (didn't re-check). See http://weblogs.asp.net/jgalloway/archive/2005/01/30/363317.aspx