Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
UPDATE dbo.tblBNKRecon SET dbo.tblBNKRecon.GroupedPmtID = GRPPMTID From (SELECT tblBNKRecon.GroupedPmtID, tblBNKRecon.BAITypeCode, tblBNKRecon.Status, tblBNKRecon.NewDesc, tblBNKRecon.ID, tblBNKRecon.BankAccount, tblBNKRecon.BankDate FROM tblBNKRecon INNER JOIN tblBNK_GRP_ENT ON tblBNKRecon.BankAccount = tblBNK_GRP_ENT.ACCT WHERE (((tblBNKRecon.BAITypeCode)='169') AND ((tblBNKRecon.Status)='LD') AND ((tblBNKRecon.NewDesc) Is Not Null) AND ((tblBNK_GRP_ENT.GroupedPmts)=1)))as a inner join ( select MIN(ID) as minimalID, NewDesc, BankAccount, BankDate, COALESCE(CONVERT(VARCHAR, MONTH(GETDATE())), '') + COALESCE(CONVERT(VARCHAR, DAY(GETDATE())), '')+ COALESCE(CONVERT(VARCHAR, MIN(ID)), '') as GRPPMTID from dbo.tblBNKRecon group by NewDesc, BankAccount, BankDate) as b on a.NewDesc = b.NewDesc and a.BankAccount = b.BankAccount and a.BankDate = b.BankDate
|Supress rows in SSRS table based on Like or Soundex||2||39|
|Help with SQL - TOP 10 by date and by group||13||31|
|AWE-based memory on 32-bit servers||1||23|
|Delphi Ado Query To Converts Joined Columns Into Rows Based on Primary Key||4||36|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!