>>This is the only thing other than a declare statement in this particular script, but each time I run it I get the error listed at the bottom.
>>
>>
>> Declare ChartID cursor
>> Forward_Only
>> For
>> Select Distinct
>> (P.ChartID),
>> '0' AS Processed
>> From NTSERVER.IMPACTMD.dbo.Patients P
>> Inner Join NTSERVER.IMPACTMD.dbo.Doc_Header H
>> On H.PatientID = P.PatientID
>>
>>
>>
>>Msg 16915, Level 16, State 1, Line 43
>>A cursor with the name 'ChartID' already exists.
>>
>
>Please do not star with CURSORS.
>They sounds great for VFP developers but they are performance killers.
>SQL Server is a SET based language , so you better use rowsets instead of rows.
Sounds good, but this is a one-time thing to convert some data. Looks like they aren't useful to me anyway as you can't seem to select from them after they are created.