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.
sql = "SELECT r.intRecruitID, r.strLastName + ' ' + r.strFirstName + ' ' + r.strMiddlename as Fullname, r.strSSN, r.dtProcessing, r.strMOS, m.strMeps, r.strAFQT, r.strZip " _ & "FROM tblRecruit as r LEFT OUTER Join tblMeps as m on m.intMepsId = r.intMepsId Left Outer Join OPENQUERY(SIDPERS, 'Select SSN_SM from ACN.ACN_CNTL_NBR_TBL') as S " _ & "on r.strSSN = s.SSN_SM WHERE Convert(varchar(10), r.dtProcessing, 121) >= Convert(varchar(10), DATEADD(d, 4, '2002-09-27'), 121) AND Convert(varchar(10), r.dtProcessing, 121) " _ & "<= Convert(varchar(10), DATEADD(d, 5, '2002-09-27'), 121) AND s.SSN_SM IS NULL" So if DT_EXPIRe is greater than or equall to today they should not show but if its expired and within the 8 day window above they should show up. ACN Table ACN# NAme SSN DT_EXPIRE DT_ASSIGN
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|unable to reinstall SCVMM 2012 R2 - SQL errors.||5||43|
|Need help separating values from a column and creating a new record||6||47|
|SQL Select Query help||1||38|