Are you interested in becoming an AWS Certified Solutions Architect?
Discover a new interactive way of training for the exam.
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.