I am not sure if this always works, but could you try removing the print and select statements in the following code (for second SP)

WHILE ( @fetch_status2= 0)

BEGIN

select @cmplt_code

WHILE (@Month <> 14)

BEGIN

print @month

Do Let me know if it worked for you

Edited by - mandard on 06/24/2003 12:24:39 AM