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.
Select distinct wrap.L0, wrap.L1, wrap.L2, wrap.L3, wrap.L4, wrap.ZIPCODE from ( SELECT dbo.PeopleMailingNameCalc(LTC.People2ID) as L0, dbo.AddressCollapseReturnL1L2L3L4(1, null, LTC.PeopleAddress2ID) as L1, dbo.AddressCollapseReturnL1L2L3L4(2, null, LTC.PeopleAddress2ID) as L2, dbo.AddressCollapseReturnL1L2L3L4(3, null, LTC.PeopleAddress2ID) as L3, dbo.AddressCollapseReturnL1L2L3L4(4, null, LTC.PeopleAddress2ID) as L4, (Select (isnull(Zip,'') + ' ' + isnull(Zip4,'')) FROM dbo.PeopleAddresses2 where PeopleAddress2ID=LTC.PeopleAddress2ID) as ZIPCODE FROM Membership2 INNER JOIN Body2 ON Membership2.BodyId = Body2.BodyId INNER JOIN MembershipStatus2 ON Membership2.MembershipStatusId = MembershipStatus2.MembershipStatusId INNER JOIN People2 ON Membership2.People2Id = People2.People2ID INNER JOIN @LocTableC LTC ON LTC.People2ID = People2.People2ID WHERE (People2.DateOfDeath IS NULL) AND (Membership2.People2ID in (select People2ID from @LocTableC)) ) as wrap ORDER BY CASE WHEN @OrderBy = 'ZIP' THEN wrap.ZIPCODE ELSE wrap.L0 END
|Can I convert a numeric string into referenced values with an SQL query?||10||46|
|SSRS 2012 r2 - Parm Drop Down has Date/Time||12||42|
|Problem when I run a simple storeproc - help||4||23|
|Clone table from one server.database to another server.database||24||39|