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 PID.POLICY_ID, PID.ITEM_NUMBER, PID.INTERVAL_NUMBER, PID.EFFECTIVE_DATE, PID.EXPIRATION_DATE, PD.STAT_LIMIT_OF_LIABILITY, PD.EST_REPLACEMENT_COST, PD.CLASS_OF_BUSINESS FROM dbo.PR_POLICY_DESCRIPTION PD INNER JOIN PR_ITEM_DESCRIPTION PID ON PD.POLICY_ID=PID.POLICY_ID WHERE ((PID.EFFECTIVE_DATE BETWEEN '2014-01-01' AND '2014-03-31') OR ((PID.EFFECTIVE_DATE < '2014-01-01') AND (PID.EXPIRATION_DATE BETWEEN '2014-01-01' AND '2014-03-31')) OR ((PID.EFFECTIVE_DATE < '2014-01-01') AND (PID.EXPIRATION_DATE >= '2014-03-31'))) AND ITEM_NUMBER='1' ORDER BY PID.POLICY_ID, PID.ITEM_NUMBER, PID.INTERVAL_NUMBER
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Setting the order of SPROC returned recordset based on a passed paramter||34||40|
|SQL - Load records to temp table through CTE||6||38|
|SQL: Transformation or Pivot||3||36|
|Access Query To Find The Average Date Between Two Dates||3||24|
Join the community of 500,000 technology professionals and ask your questions.