Thanks to both of you for those references. They were both extremely helpful.

Noel, that article is AMAZING. Here's the part that makes the biggest difference:

Not all search routines are as...

I can post sample DDL and DATA if people think that would be useful.

However, I'm really looking to see if someone has a different approach to the problem.

You're welcome, and thanks for the feedback.

You did not see any results for the end dates because you specified exactly midnight of that day.

You did not have any records at exactly midnight on 10/4. However, if...

And of course, Jeff's newest article on Dynamic Cross Tabs: http://www.sqlservercentral.com/articles/cross+tab/65048/

There's been many discussions about this on the forums.

The consensus was that the method Lynn mentioned is the fastest.

SELECT DATEADD(dd,0, DATEDIFF(dd,0,GetUTCDate()))

Great article Jeff!

Do you think this will perform better than a dynamic pivot?

Have you read Jeff's article, Hugo?

It actually answers some of the points you brought up.

Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5[/url]

Thanks for the info, folks!

You can't paste XML in the forums.

Try attaching it as a txt file.

Using SELECT INTO will get...

Please attach your XML as a text file, so people can play around with it.

venki (11/12/2008)

---

Hi,

I want to get auto numbers for a one of the column in the table. How can I get this.

Previously, the database in MS Access. So in MS...

Jeff Moden (11/13/2008)

---

Oh dear... I blew it... :blush: I normally try to write in a gender-agnostic fashion especially when I don't really know someone. My appologies. Perhaps...

:hehe: Not HE -- SHE :hehe: