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

For cursors you need DEALLOCATE and CLOSE commands. Check the syntax in BOL.

Also there are almost always better ways than using cursors. If you use SQL Server 2005 look at CTE option.