Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
8
Impact
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 3 votes cast
Apr
12
comment SQL Calculation based on 'similar' rows within table
Ah, understood. Agreed the EXISTS should be faster. Thanks again.
Apr
12
comment SQL Calculation based on 'similar' rows within table
? I thought that was a self join inside the EXISTS... what else did you have in mind otherwise?
Apr
12
comment SQL Calculation based on 'similar' rows within table
Missing a closing bracket round the subquery in that code snippet, (also I think you mean c2.date instead of cd.date but that self-join seems to be the way forward I think... Cheers!
Apr
12
comment SSAS Modelling - many to many with one dimension
In absence of better answers, I'll mark this as correct, as its the closest to what we got to a working solution.