Revised Solution for NSC and KVP Key Date related issues in DPT

DPT v7.1 Discrepancies and Solution

In Latest Version of DPT, New Discrepancies are added and found NSC and KVP Key date related issues

USE POST
update dcl.kvp_gardfile
set transdate=(select transdate from post.dcl.kvp_binder where dcl.kvp_binder.slno=dcl.kvp_gardfile.slno)
go
update dcl.kvp_gardfile
set keydate=transdate
go
update dcl.nsc_gardfile
set transdate=(select transdate from post.dcl.nsc_binder where dcl.nsc_binder.slno=dcl.nsc_gardfile.slno)
go
update dcl.nsc_gardfile
set keydate=transdate
go

Instruction to Execute the above query

1. The above query should be used by System Administrator.
2. Before executing the query take Post database backup. 

Note : Author of Blog / Query developer is not responsible for any data losses / corruption . It should be executed by SA after taking the backup of concerned database(s).