please write stored procedure in update table

Hi, if it help you please accept the answer so other can get help.

Thanks Khan Abrar Ahmed

Hi Try this

DECLARE @ShiftType VARCHAR(64)='Evening' --Change this or pass the parameter as per shift

DECLARE @table AS TABLE (ID INT,NAME VARCHAR(64),task VARCHAR(64),[Shift] VARCHAR(64),[Status] VARCHAR(64) NULL)
DECLARE @tablePending AS TABLE (ID INT,NAME VARCHAR(64),task VARCHAR(64),[Shift] VARCHAR(64),[Status] VARCHAR(64) NULL)
INSERT INTO @table
        ( ID, NAME, task, Shift, Status )
VALUES
(1 ,      'Selastin' ,          'DragAndDrop'        ,                       'Morning'  ,      'Pending'  ) ,              
(2 ,      'Rasim'  ,           'CopyPaste'   ,                                 'Morning',      'Pending'   ) ,             
(3 ,      'Robin' ,             'updateAntivirus' ,                            'Evening',NULL),
(4  ,     'Dileep'  ,           'insertTask' ,                                   'Evening',NULL),
(5  ,     'Binu',                'Automaticupdation' ,                       'Evening',null)
SELECT * FROM @table
IF(@ShiftType ='Evening')
BEGIN
DELETE from  @tablePending
INSERT INTO  @tablePending
   SELECT * FROM  @table WHERE Shift='Evening'


UPDATE @table SET NAME=tp.NAME,Shift=tp.Shift
From @tablePending AS tp
LEFT JOIN @table AS t ON t.Status='Pending'
END
Else IF(@ShiftType ='Morning')
BEGIN

UPDATE @table SET Shift='Morning' WHERE Status='Pending'
DELETE from  @tablePending
INSERT INTO  @tablePending
   SELECT * FROM  @table WHERE Shift='Morning'


UPDATE @table SET NAME=tp.NAME,Shift=tp.Shift
From @tablePending AS tp
LEFT JOIN @table AS t ON t.Status='Pending'
END

SELECT * FROM  @table