amit_adarsh (6/27/2013)
why Doug is not in the list.
If I pick the names and sort them in ascending order in excel sheet, I will get below
B.
Bob
Carl
D
D.
Doug
Now as the WHERE clause is "between 'B' and 'D'", it is clear I will only have top 4 values from the above list 🙂
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter