>>>>>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, it is SQL server syntax.
Cetin