Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Select r.intRecruitID, r.strLastName + ', ' + r.strFirstName + ', ' + r.strMiddlename as Fullname, r.strSSN, r.dtProcessing, r.strMOS, m.strMeps, r.strAFQT from tblRecruit as r Inner Join tblMeps as m on m.intMepsId = r.intMepsId Where r.dtProcessing >= dateadd(d, datediff(d, 0, '10/7/2002 12:00:00 AM'),4) and r.dtProcessing < dateadd(d, datediff(d, 0, '10/7/2002 12:00:00 AM'),5) and intRecruitId in (Select intRecruitId from tblACNRequest where dtExpire <= getdate()) or intRecruitid in (Select intRecruitId from tblACNRequest where dtCancelAcn is not null) Order by strLastName
|SQL Server 2012 r2 - Calulations within stored procedure involving temp tables||6||40|
|What is the proper way to use for criteria in left join?||7||30|
|date diff with Fiscal Calendar||4||53|
|How to structure query with count aggregate||4||9|