Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
Declare @DealID int Set @DealID = 1988 Select IsNull(Substring(afsSource,4,4),0) dealID, Sum(Case When afsTransaction = 0 Then 1 Else 0 End) AS Zeroes, Sum(Case When afsTransaction <> 0 Then 1 Else 0 End) AS NonZeroes From proc_cfa.dbo.P_AvailableForSale Where substring(afsSource,4,4) = @DealID Group By substring(afsSource,4,4) order by Cast(substring(afsSource,4,4) as Int)
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.