Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
BEGIN SELECT count (DISTINCT (dbo.Member.ID)) AS mcount FROM dbo.Member WHERE ((SELECT count(billingid) FROM billingdata WHERE ((billingmonth>=@MONTH AND billingyr=@YEAR-1) OR (billingmonth<@MONTH AND billingyr=@YEAR)) AND (billingid=dbo.member.id)) >= 1 ) AND member.memberstatus=101 AND CASE WHEN @mtype='M' THEN '(companyid=0 AND departmentid=0 AND householdid=0)' WHEN @mtype='J' THEN '(companyid=0 AND departmentid=0 AND householdid>0)' WHEN @mtype='C' THEN '(companyid>0 AND departmentid=0 AND householdid=0)' WHEN @mtype='D' THEN '(companyid>0 AND departmentid>0 AND householdid=0)' END END
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.