FETCH NEXT FROM cur_row INTO @P_NEW_ID, @P_NAME

    WHILE @@Fetch_status = 0

    BEGIN
    SET @P_NEW_ID = NEXT VALUE FOR dbo.SEQ_MASTER

            SELECT @P_EVENT = 'I'
                ,@P_TNAME = '[dbo].TABLE A'
                FROM inserted
            SELECT @P_NAME FROM inserted
            select @P_N_CRTDATE = GETDATE();
            select @P_N_CRTUSER= CURRENT_USER;


            EXEC [dbo].[P_TRG_ACTION]
                @P_EVENT
                ,@P_NEW_ID
                ,@P_N_CRTDATE
                ,@P_N_CRTUSER
                ,@P_TNAME
                ,@P_NAME



    FETCH NEXT FROM cur_row INTO @P_NEW_ID, @P_NAME

end

close cur_row
deallocate cur_row

USE [MEV2]
GO
/****** Object:  StoredProcedure [dbo].[P_TRG_ACTION]    Script Date: 7/2/2015 9:51:06 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[P_TRG_ACTION]


  @P_EVENT varchar(max),
   @P_NEW_ID int,
  @P_N_CRTDATE datetime2(0),
  @P_N_CRTUSER varchar(max),
  @P_TNAME varchar(max),
  @P_NAME varchar(max)



AS

   BEGIN

         IF @P_EVENT = 'I'
            BEGIN


               INSERT INTO dbo.TABLE B(TABLENAME, ID, NAME)
                  VALUES (@P_TNAME, @P_NEW_ID, @P_NAME)

            END

END