Lynn Pettis (5/14/2013) Eugene Elutin (5/14/2013)
William Gary Wright (5/14/2013)
I left the office last night being half way done writing a script to create a database with some data in it for you all to look at. I came in this morning and read the new replies to my post. I had never considered a join. All of the examples of joins I have seen there was always an = involved and I had not seen >= used in a join. This worked great and it makes sense to me.
How does this points thing work?
This article is worth to read (about hidden "RBAR" in triangular joins):http://www.sqlservercentral.com/articles/T-SQL/61539/
Yes, it is a good article on triangular joins, I just hope you don't think that the code I provided is a triangular join. It is actually a bound join with a lower an upper bound.
No, it has nothing to do with your code. Just OP has stated that he has never seen JOINs with "<=" used before. So, I thought, before OP will became to excited about it, he better to be aware of triangular join problem which may occur when "non-equal" compare is used in joins.
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)How to post your question to get the best and quick help