Containers are an incredibly powerful technology that can provide you and/or your engineering team with huge productivity gains. Using containers, you can deploy, back up, replicate, and move apps and their dependencies quickly and easily.
insert into #prtemp select r.claimantId, FY_process = ltrim(str((@lossfy -1)) + '/' + ltrim(str(@lossfy))), total_paid = CAST(NULL AS DECIMAL(12, 2)) , total_incurred = SUM(CASE WHEN rt.ReserveTypeID in(SELECT Item FROM dbo.Split (@ReserveType, ',')) THEN r.ReserveAmount ELSE 0 END) FROM dbo.Reserve r ( NOLOCK ) LEFT JOIN dbo.ReserveType rt ON r.ReserveTypeID = rt.ReserveTypeID where r.ClaimantID = @clmnt AND r.ProcessedDate <= ('6/30/'+ltrim(str(@lossfy))) GROUP BY r.ClaimantID
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.