Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
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.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
Select ClaimantID, '6/30/'+Substring(dbo.GetF<wbr ></wbr>iscalYear(<wbr ></wbr>r.Processe<wbr ></wbr>dDate),6,4<wbr ></wbr>) as ProcessedFY, SUM(r.ReserveAmount) as TotalIncurred FROM dbo.Reserve r ( NOLOCK ) LEFT JOIN dbo.ReserveType rt ON r.ReserveTypeID = rt.ReserveTypeID WHERE r.ProcessedDate BETWEEN @FYStart AND @FYEnd GROUP BY ClaimantID, '6/30/'+Substring(dbo.GetF<wbr ></wbr>iscalYear(<wbr ></wbr>r.Processe<wbr ></wbr>dDate),6,4<wbr ></wbr>) HAVING SUM(r.ReserveAmount) >0.00
|SQL Server Count where two id types exist in column||8||29|
|Currency in SQL?||2||30|
|Query for timesheet application||3||17|
|Update one table with results from another table in SQL||6||25|