>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.