Delete Duplicate Query

For Speednet
use pospcc
UPDATE  DeliveryReturns
SET     RemarkCode='1'

For Postman
USE POSTMAN
UPDATE      RegDeliveryMaster
SET             DeliveryOrDespatchDate =TransDate
UPDATE       RegDeliveryReturns
SET              Action ='0',ReasonCode='1'

USE POSTMAN
UPDATE      ParDeliveryMaster
SET             DeliveryOrDespatchDate =TransDate
UPDATE       ParDeliveryReturns
SET              Action ='0',ReasonCode='1'

USE POSTMAN
UPDATE      MoDeliveryMaster
SET             DeliveryOrDespatchDate =TransDate
UPDATE       MoDeliveryReturns
SET              Action ='0',ReasonCode='1'
-------------------------------------------------------------------
For Speednet
use pospcc
UPDATE  DeliveryMaster
SET          DeliveryOrDespatchDate=Transdate
WHERE   (DeliveryOrDespatchDate IS NULL)
 
For Postman
USE POSTMAN
UPDATE      RegDeliveryMaster
SET             DeliveryOrDespatchDate =TransDate
UPDATE       RegDeliveryReturns
SET              [Action] ='0',REASONSCODE='1'