Begin

      Declare 
      @appointmentIds varchar(4000),

      @cnt int,

      @SQL nvarchar (4000),

      @TSQL nvarchar (4000);

      DECLARE appmt_Cursor CURSOR FAST_FORWARD FOR

            select appointment_ids from EMRTPBilledItems where tp_item_id='KA02-D0096' and appointment_ids is not null;

      OPEN appmt_Cursor

      FETCH NEXT FROM appmt_Cursor INTO @appointmentIds;

      WHILE @@FETCH_Status = 0 

      BEGIN 

            EXEC ('Declare task_Cursor CURSOR  FOR select ID_VALUE from EMRSupplementaryTransactions where task_id=2 AND ID_VALUE IN (select appointment_id from EMRAppointmentDetails where appointment_id IN ('+ @appointmentIds + ')) ')

            Open task_Cursor

        FETCH NEXT FROM task_Cursor INTO @TSQL;

            WHILE @@FETCH_Status = 0 

            BEGIN 

                  PRINT @TSQL;
---------------------required statements
                  FETCH NEXT FROM task_Cursor INTO @TSQL;

            End

            CLOSE task_Cursor

            DEALLOCATE task_Cursor   

            FETCH NEXT FROM appmt_Cursor INTO @appointmentIds;

        END

      CLOSE appmt_Cursor

      DEALLOCATE appmt_Cursor       

END