We would say that this ID has been active every day from 6/1/16 up to and including 9/30/16. I need to be able to count how many distinct IDs were active on any given day, and also be able to average ...
What the best way to work around this? I have the same SELECT statement but there are different criteria depending on the IF check. Well, if you happen to be using Sql Server you can do that sort of ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results