Viewing 3 posts - 1 through 3 (of 3 total)
Thom A, I used to trust you.
July 25, 2018 at 4:40 pm
#1999014
A brief interlude to answer the OP. Remove the aggregate function (AVG) on line 4 of your code. Remove the GROUP BY clause on line 6 of your code and...
July 25, 2018 at 4:37 pm
#1999013
I was able to recreate this issue when one or both of the join criteria were NULL.
Quick Solution: Using the original code posted, add ISNULL(FieldName, 1) to all...
July 22, 2018 at 4:25 pm
#1998540