My experience: try not to use non-equal joins :) If you are using so do not be suprised the performance may be poor ... I had such case and then I decided to design a query in a different maner. It worked..
I'm curious where the scripts that go along with this video series are located. I'm studying t-sql and this series has been more helpful explaining the terminology than any of my college professors
![MV วิถีชีวิตใต้ - ผา อัยย๊ะ [Official MV HD]](http://i.ytimg.com/vi/nODlkOUu9B0/mqdefault.jpg)
My experience: try not to use non-equal joins :) If you are using so do not be suprised the performance may be poor ... I had such case and then I decided to design a query in a different maner. It worked..
I'm curious where the scripts that go along with this video series are located.
I'm studying t-sql and this series has been more helpful explaining the terminology than any of my college professors
Thanks, glad you like it! We didn't publish the scripts, though. Enjoy the free videos!
The CASE-expression inside the COUNT is unnecessary.