Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
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
|SQL Query Producing decimal places when it shouldn;t be||8||43|
|In SQL Server 2016, can we configure MASKing rules that applies for application level users ?||12||56|
|How to join on ID, with prefix?||15||58|
|Deferent recordset when running a query 1,2,3 or more times eachtime its different||4||31|