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