Unanswered: Perform Calculation Based Off case Statement?
Would it be possible for me to do what I am attempting below? Obviously it isn't working for me, haha
create table #Try
insert into #Try
count(distinct case when soldOut is null then ID else null end),
--I want to do this, but it errors each time
COUNT(Distinct id) - count(distinct case when soldOut is null then ID else null end)
Last edited by jo15765; 11-12-13 at 16:26.
Reason: wrng code tags