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.
DECLARE @GetMonth VARCHAR(2)
DECLARE @GetYear VARCHAR(4)
SET @GetMonth = MONTH(GETDATE())
SET @GetYear = YEAR(GETDATE())
SELECT DISTINCT
Claim
,Claimant
,Insured
,Risk
,[Loss Date]
,CSC.NoticeDate
,[Company Position]
,[Disposition Date]
,CSC.DispositionCode
,[Category] = CASE WHEN CSC.DispositionCode = '5' THEN 'Trail'
WHEN CSC.DispositionCode = '6' THEN 'Trail'
WHEN CSC.DispositionCode = ' '
AND AppealFlag = 'Y' THEN 'Trial'
WHEN CSC.DispositionCode = '11' THEN 'Trial'
WHEN CSC.DispositionCode = '12' THEN 'Trial'
WHEN CSC.DispositionCode = '13' THEN 'Arbitration'
WHEN CSC.DispositionCode = '14' THEN 'Arbitration'
WHEN CSC.DispositionCode = '15' THEN 'Mediation'
WHEN CSC.DispositionCode = '18'
THEN 'Early Offer Claims'
WHEN CSC.DispositionCode = '4'
THEN 'Involuntary Dismissal'
WHEN CSC.DispositionCode = '3'
AND [Indem Paid] = '0.00'
THEN 'Voluntary Dismissal'
WHEN CSC.DispositionCode = '3'
AND [Indem Paid] > '0.00' THEN 'Settlements'
WHEN CSC.DispositionCode = 'E'
AND [Indem Paid] > '0.00'
THEN 'Incident Only Payment'
END
,[Type] = CASE WHEN CSC.DispositionCode = '5'
THEN 'Judgment for Plaintiff'
WHEN CSC.DispositionCode = '6'
THEN 'Judgment for Defendant'
WHEN CSC.DispositionCode = ' '
AND AppealFlag = 'Y' THEN 'Pending Appeal'
WHEN CSC.DispositionCode = '11'
THEN 'For Plaintiff After Appeal'
WHEN CSC.DispositionCode = '12'
THEN 'For Defendant After Appeal'
WHEN CSC.DispositionCode = '13'
THEN 'Award for Plaintiff'
WHEN CSC.DispositionCode = '14' THEN 'Award for Defense'
WHEN CSC.DispositionCode = '15' THEN 'Mediation'
WHEN CSC.DispositionCode = '18'
THEN 'Early Offer Claims'
WHEN CSC.DispositionCode = '4'
THEN 'Involuntary Dismissal'
WHEN CSC.DispositionCode = '3'
AND [Indem Paid] = '0.00'
THEN 'Voluntary Dismissal'
WHEN CSC.DispositionCode = '3'
AND [Indem Paid] > '0.00' THEN 'Settlements'
WHEN CSC.DispositionCode = 'E'
AND [Indem Paid] > '0.00'
THEN 'Incident Only Payment'
END
,[Plaintiff Counsel]
,[Defense Counsel]
,CSC.Venue
,[Indem Paid]
,[Exp Paid]
,Examiner
FROM EXPORTpahpixPROD.dbo.PXQ7000_UDF(@GetMonth, @GetYear, NULL, 0, 0, 0, 1,
0, '99-')
INNER JOIN wellandp.ClaimSubclaim CSC ON dbo.PXQ7000_UDF.Claim = CSC.ClaimNo
WHERE [Disposition Date] BETWEEN '08/01/2010' AND '08/30/2011'
AND CSC.DispositionCode IN ( '4', '5', '6', '11', '12', '13', '14',
'15', '18' )
OR CSC.DispositionCode = '3'
AND [Indem Paid] = '0.00'
OR CSC.DispositionCode = '3'
AND [Indem Paid] > '0.00'
OR CSC.DispositionCode = 'E'
AND [Indem Paid] > '0.00'
OR CSC.DispositionCode = ' '
AND AppealFlag = 'Y'
ORDER BY CSC.DispositionCode
DECLARE @GetMonth VARCHAR(2)
DECLARE @GetYear VARCHAR(4)
SET @GetMonth = MONTH(GETDATE())
SET @GetYear = YEAR(GETDATE())
SELECT DISTINCT
Claim
,Claimant
,Insured
,Risk
,[Loss Date]
,CSC.NoticeDate
,[Company Position]
,[Disposition Date]
,CSC.DispositionCode
,[Category] = CASE WHEN CSC.DispositionCode = '5' THEN 'Trail'
WHEN CSC.DispositionCode = '6' THEN 'Trail'
WHEN CSC.DispositionCode = ' '
AND AppealFlag = 'Y' THEN 'Trial'
WHEN CSC.DispositionCode = '11' THEN 'Trial'
WHEN CSC.DispositionCode = '12' THEN 'Trial'
WHEN CSC.DispositionCode = '13' THEN 'Arbitration'
WHEN CSC.DispositionCode = '14' THEN 'Arbitration'
WHEN CSC.DispositionCode = '15' THEN 'Mediation'
WHEN CSC.DispositionCode = '18'
THEN 'Early Offer Claims'
WHEN CSC.DispositionCode = '4'
THEN 'Involuntary Dismissal'
WHEN CSC.DispositionCode = '3'
AND [Indem Paid] = '0.00'
THEN 'Voluntary Dismissal'
WHEN CSC.DispositionCode = '3'
AND [Indem Paid] > '0.00' THEN 'Settlements'
WHEN CSC.DispositionCode = 'E'
AND [Indem Paid] > '0.00'
THEN 'Incident Only Payment'
END
,[Type] = CASE WHEN CSC.DispositionCode = '5'
THEN 'Judgment for Plaintiff'
WHEN CSC.DispositionCode = '6'
THEN 'Judgment for Defendant'
WHEN CSC.DispositionCode = ' '
AND AppealFlag = 'Y' THEN 'Pending Appeal'
WHEN CSC.DispositionCode = '11'
THEN 'For Plaintiff After Appeal'
WHEN CSC.DispositionCode = '12'
THEN 'For Defendant After Appeal'
WHEN CSC.DispositionCode = '13'
THEN 'Award for Plaintiff'
WHEN CSC.DispositionCode = '14' THEN 'Award for Defense'
WHEN CSC.DispositionCode = '15' THEN 'Mediation'
WHEN CSC.DispositionCode = '18'
THEN 'Early Offer Claims'
WHEN CSC.DispositionCode = '4'
THEN 'Involuntary Dismissal'
WHEN CSC.DispositionCode = '3'
AND [Indem Paid] = '0.00'
THEN 'Voluntary Dismissal'
WHEN CSC.DispositionCode = '3'
AND [Indem Paid] > '0.00' THEN 'Settlements'
WHEN CSC.DispositionCode = 'E'
AND [Indem Paid] > '0.00'
THEN 'Incident Only Payment'
END
,[Plaintiff Counsel]
,[Defense Counsel]
,CSC.Venue
,[Indem Paid]
,[Exp Paid]
,Examiner
FROM EXPORTpahpixPROD.dbo.PXQ7000_UDF(@GetMonth, @GetYear, NULL, 0, 0, 0, 1,
0, '99-')
INNER JOIN wellandp.ClaimSubclaim CSC ON dbo.PXQ7000_UDF.Claim = CSC.ClaimNo
WHERE [Disposition Date] BETWEEN '08/01/2010' AND '08/30/2011'
AND (CSC.DispositionCode IN ( '4', '5', '6', '11', '12', '13', '14',
'15', '18' )
OR CSC.DispositionCode = '3'
AND [Indem Paid] = '0.00'
OR CSC.DispositionCode = '3'
AND [Indem Paid] > '0.00'
OR CSC.DispositionCode = 'E'
AND [Indem Paid] > '0.00'
OR CSC.DispositionCode = ' '
AND AppealFlag = 'Y')
ORDER BY CSC.DispositionCode
DECLARE @GetMonth VARCHAR(2)
DECLARE @GetYear VARCHAR(4)
SET @GetMonth = MONTH(GETDATE())
SET @GetYear = YEAR(GETDATE())
SELECT DISTINCT
Claim
,Claimant
,Insured
,Risk
,[Loss Date]
,CSC.NoticeDate
,[Company Position]
,[Disposition Date]
,CSC.DispositionCode
,[Category] = CASE WHEN CSC.DispositionCode = '5' THEN 'Trail'
WHEN CSC.DispositionCode = '6' THEN 'Trail'
WHEN CSC.DispositionCode = ' '
AND AppealFlag = 'Y' THEN 'Trial'
WHEN CSC.DispositionCode = '11' THEN 'Trial'
WHEN CSC.DispositionCode = '12' THEN 'Trial'
WHEN CSC.DispositionCode = '13' THEN 'Arbitration'
WHEN CSC.DispositionCode = '14' THEN 'Arbitration'
WHEN CSC.DispositionCode = '15' THEN 'Mediation'
WHEN CSC.DispositionCode = '18'
THEN 'Early Offer Claims'
WHEN CSC.DispositionCode = '4'
THEN 'Involuntary Dismissal'
WHEN CSC.DispositionCode = '3'
AND [Indem Paid] = '0.00'
THEN 'Voluntary Dismissal'
WHEN CSC.DispositionCode = '3'
AND [Indem Paid] > '0.00' THEN 'Settlements'
WHEN CSC.DispositionCode = 'E'
AND [Indem Paid] > '0.00'
THEN 'Incident Only Payment'
END
,[Type] = CASE WHEN CSC.DispositionCode = '5'
THEN 'Judgment for Plaintiff'
WHEN CSC.DispositionCode = '6'
THEN 'Judgment for Defendant'
WHEN CSC.DispositionCode = ' '
AND AppealFlag = 'Y' THEN 'Pending Appeal'
WHEN CSC.DispositionCode = '11'
THEN 'For Plaintiff After Appeal'
WHEN CSC.DispositionCode = '12'
THEN 'For Defendant After Appeal'
WHEN CSC.DispositionCode = '13'
THEN 'Award for Plaintiff'
WHEN CSC.DispositionCode = '14' THEN 'Award for Defense'
WHEN CSC.DispositionCode = '15' THEN 'Mediation'
WHEN CSC.DispositionCode = '18'
THEN 'Early Offer Claims'
WHEN CSC.DispositionCode = '4'
THEN 'Involuntary Dismissal'
WHEN CSC.DispositionCode = '3'
AND [Indem Paid] = '0.00'
THEN 'Voluntary Dismissal'
WHEN CSC.DispositionCode = '3'
AND [Indem Paid] > '0.00' THEN 'Settlements'
WHEN CSC.DispositionCode = 'E'
AND [Indem Paid] > '0.00'
THEN 'Incident Only Payment'
END
,[Plaintiff Counsel]
,[Defense Counsel]
,CSC.Venue
,[Indem Paid]
,[Exp Paid]
,Examiner
FROM EXPORTpahpixPROD.dbo.PXQ7000_UDF(@GetMonth, @GetYear, NULL, 0, 0, 0, 1,
0, '99-')
INNER JOIN wellandp.ClaimSubclaim CSC ON dbo.PXQ7000_UDF.Claim = CSC.ClaimNo
WHERE [Disposition Date] BETWEEN '08/01/2010' AND '08/30/2011'
AND (CSC.DispositionCode IN ( '4', '5', '6', '11', '12', '13', '14',
'15', '18' )
OR (CSC.DispositionCode = '3'
AND [Indem Paid] = '0.00')
OR (CSC.DispositionCode = '3'
AND [Indem Paid] > '0.00')
OR (CSC.DispositionCode = 'E'
AND [Indem Paid] > '0.00')
OR (CSC.DispositionCode = ' '
AND AppealFlag = 'Y'))
ORDER BY CSC.DispositionCode
If you are experiencing a similar issue, please ask a related question
Title | # Comments | Views | Activity |
---|---|---|---|
Issues with character length when naming a Windows folder | 8 | 51 | |
Anyway to make these 2 SQL statements into one? | 13 | 38 | |
iCloud Verification failed: "an unknown error occurred" | 2 | 40 | |
Different resolutions on extended monitors | 17 | 18 |
Join the community of 500,000 technology professionals and ask your questions.