Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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.
|SQl Query to find x consecutive Nbrs in a Table||30||104|
|SQL group by query to return records with highest value||6||36|
|T-SQL Query - Group By Year||3||54|
|compare date to getdate()||8||31|
Join the community of 500,000 technology professionals and ask your questions.