SELECT NoMonth,ACC_P,StartDate FROM dbo.tbl_Accural_Basic UPDATE WEB_tbl_Accural_Audit SET NoMonth=nomonth,ACC_P=ACC_P, StartDate=Startdate
update updtab set updtab.NoMonth = selecttab.nomonth , updtab.ACC_P = selecttab.ACC_P , updtab.StartDate = selecttab.Startdate from WEB_tbl_Accural_Audit updtab , dbo.tbl_Accural_Basic selecttab (nolock)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)