****EDIT******************************

skip this post, I was incorrect, as Lynn points out

*************************************

And try changing

WHERE tableA.date BETWEEN @start AND @stop

to:

WHERE tableA.date =< @stop AND tableA.date >= @start

looks more cumbersome, but performs better.

hlam-1032421 (11/11/2009)

---

With comments like this I run for the exit:

… good clustering. One school says to put the clustered index on the column or set of columns that would be...

yeah, well that's a given, isn't it? 😉

Excellent article Gail, as always, thank you for that! 🙂

drudgery

Now there's a dangerous assumption... :-P:-D

Geek of the Week is too uppity...

So then we've finally found a definitive benefit of RBAR - environment control

Ha! So how many lines of code per calorie?

Different strokes for different folks...:-D

Hang on, searching for an avatar whose eyes are bleeding...

I got it too, funny! :hehe:

Thank you! I really appreciate your help on this, the process is more important than the example for me here.

Now I need to go read Jeff's articles again.

Thanks again!

Jon:-D

Dupes aren't probably dupes due to the full value in that column, so for this purpose you can ignore de-duping. Resultset I'm looking for would look something like the attached,...

Ok, I don't think this will work for me, because I want to pivot data without knowing what the values are.

For example, if I'm working with provider languages, I...