We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
SELECT Account, count(*) as ct FROM Table1 where version like 'x.0.0' and Account != '' and DATEDIFF(day, ReceivedDate,GETDATE()) < 30 group by Account having count(*) >= 5 order by ct desc; select Account, count(*) as ct_dev from Table1 t1 left outer join Table2 t2 on t1.tr = t2.DevTr where DevTr is not null and account is not null and account <> '' and DATEDIFF(day, ReceivedDate,GETDATE()) < 30 group by Account order by ct_dev desc;
Join the community of 500,000 technology professionals and ask your questions.