case when b.ClaimStatusCode <> 3 then cc.BenefitEndDate
else convert(datetime,'01/01/1900',102)
end as MaxBenefitDate

select case when not @Mydate1 is null then convert(char(10),@MyDate1,110)		else '00-00-0000' end as mydate
select case when not @Mydate2 is null then convert(char(10),@MyDate2,110)		else '00-00-0000' end as mydate

Select		b.BaseClaimID,
		p.BaseClaimID,
		p.ClaimPolicyID,
		c.CedingCompanyCode,
		c.ClientLongName,
		stc.ClaimStatusDesc,
		dbo.FormatTaxID(pt.TaxID, pt.TaxIDTypeCode, @SSNMask), 
		pt.LastName,
		pt.FirstName,
		0,
		g.OffsetAmt,
		0,
		g.StartDate,
		g.EndDate,
		otc.OverpaymentDesc,
		o.OverPaymentAmt,
		p.OverPaymentBalance,
		p.OverPaymentTotalOwedAmt,
		0,
		cd.offsetmethodcode,
		o.calculationdate,
		b.claimstatuscode,
		cc.benefitenddate,
		case
			when b.ClaimStatusCode <> 3 then CONVERT(VARCHAR(10), cc.BenefitEndDate, 110)
			else '00-00-0000' end as MaxBenefitDate
from		ClaimOverPayment o (nolock)
Left Join	ClaimPolicy p (nolock) on p.ClaimPolicyID = o.ClaimPolicyID
			AND p.OverPaymentBalance > 0
Left Join	ClaimOffset f (nolock) on f.OwnerID = p.ClaimPolicyID
			and f.OwnerTypeCode = 72
			And f.OffsetTypeCode = 1
			And f.OffsetMethodCode = 0
Left Join	ClaimOffset g (nolock) on g.OwnerID = p.ClaimPolicyID
			and g.OwnerTypeCode = 72
			and g.OffsetTypeCode = 4
			and g.offsetmethodcode = 0
Left Join	BaseClaim b (nolock) on b.BaseClaimID = p.BaseClaimID
			AND (b.BaseClaimID = @ClaimNo or @ClaimNo = '')
			And (b.ClaimStatusCode = @StatusID or @StatusID = 0)
Left Join	Party pt on pt.PartyID = b.InsuredPartyID
			And pt.AsOfDate = '5/9/2999'
Left Join	cdClaimStatusCodes stc (nolock) on stc.ClaimStatusCode = b.ClaimStatusCode
Left Join	cdClaimOverpaymentTypeCodes otc (nolock) on otc.OverpaymentTypeCode = o.OverpaymentTypeCode
Left Join	dbo.AceCedingCompanies c on c.CedingCompanyCode = b.CedingCompanyCode
			And (c.CedingCompanyCode = @CedingCompanyCode or @CedingCompanyCode = '')
Left Join	cdClaimOffsetMethodCodes cd (nolock) on cd.offsetmethodcode = g.offsetmethodcode
Left Join	ClaimCoverage cc on cc.ClaimPolicyID = p.ClaimPolicyID
Order By	p.BaseClaimID