>>Use first and last variations as they seem to be the best.
>
>The last Variation didn't use the index and when I dropped the primary key just to see what would happen to the other select statements that where using it. The execution plan went from index scan to table scan. So to me this seems indexes are only good if the fields you are pulling out are in the list of the fields you want to filter down on.
Can you please post a table script along with some data? I'm not sure what you're saying is correct.
If it's not broken, fix it until it is.
My Blog