Make Your Microsoft Dynamics Investment Count & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
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 |
---|---|---|---|
,Cab files - .log files | 10 | 51 | |
Subquery in the where statement always shows up null in the result | 5 | 44 | |
Windows 7 - BSOD associated with video driver | 34 | 59 | |
Windows 10 ISO build version | 3 | 50 |
Join the community of 500,000 technology professionals and ask your questions.