You didn't try to say it; you did say it.

Yes, that worked.

>As I tried to say to you, move the last
>
>FETCH NEXT
> FROM PAGE
> INTO
> @PATH ,
> @Filename,
> @PAGE
>
>right before the last END.
>
>>>This particular code is a bit too complcated. What exactly you're trying to do and is it possible to avoid cursors (performers killers) at all for your task?
>>>
>>>>Ok, that helped with another issue I was having, but it still doesn't keep the query from hanging up.
>>>>
>>
>>The code works great, other than the current problem.
>>
>>Below is a block of code. It looks like the last PRINT ('Page Cursor (bottom fetch): ') is repeating over and over again after it gets to a certain
>> point. Does this have to do with the @@Fetch_Status variable? Makes me wonder if the 2nd FETCH is screwing up the loop for the first one.
>>
>>

>>				FETCH NEXT
>>					FROM PAGE
>>					INTO
>>						@PATH ,
>>						@Filename,
>>						@PAGE
>>
>>PRINT 'Page Cursor (top fetch): ' + @Path + ' ' + @Filename + ' ' + @Page
>>
>>				WHILE @@FETCH_STATUS = 0
>>
>>					BEGIN
>>
>>						IF @Filename COLLATE Latin1_General_CI_AI LIKE '%.TIF%' COLLATE Latin1_General_CI_AI
>>
>>							BEGIN
>>
>>								IF @PAGE = 1
>>
>>									BEGIN
>>
>>										SET @Export_FileName = @Filename
>>										-- Currently G:\TCimages and F:\Images1 on client box
>>										SET @Merge_Script = 'c:\ImpactMD\Images\' + @PATH + @Filename + ','
>>
>>									END
>>
>>								IF @PAGE <> 1
>>
>>									BEGIN
>>
>>										SET @Merge_Script = @Merge_Script + 'c:\ImpactMD\Images\' + @PATH + @Filename + ','
>>
>>									END
>>
>>										FETCH NEXT
>>											FROM PAGE
>>											INTO
>>												@PATH ,
>>												@Filename,
>>												@PAGE
>>
>>							END
>>
>>PRINT 'Page Cursor (bottom fetch): ' + @Path + ' ' + @Filename + ' ' + @Page
>>
>>					END
>>