Just a note... if you take to long writing a post, this site looses it's mind  and destroys your post... ALWAYS remember to COPY...

Not sure you'd have to worry about the locks to create a simple sum... and, everytime someone made a new entry in the food table, you'd have to do an...

True... but sometimes there is no application.  Besides, formatting a date is a simple form of data manipulation... why not do "data manipulation" in a database? 

It looks like a denormalized reporting or summary table that they will add a column to for every quarter...

>>BTW. Why do you need SQL Server? What's wrong with file system?

>>There is no way. It must be proper database solution.

You just confused the heck out of me

What's the best way to use the file system to do such a quick search?

Sure... although I have to eat a bit of crow on this one

A frequent poster by the name of Serqiy and I...

Outstanding... thank you for the feedback.  I always wondered how the performance of a CLR would compare.

Yep, you are correct... the CLR is easier to write AND has the utility...

Remi... remember my response when you asked about DTS??? This is a perfect example.

Ok... now for the rest of us humans   If...

Nice function, Serqei... how many rows per second are you able to process with it?

First, look at the IP address they gave you... it's not valid.

Second, SecurePipe.com sells network security software... the email you got is spam that is supposed to peak your curiosity...

Brian,

Here's a slightly different way that's usually faster than all of the character conversions... pretty easy on the eyes, too...

September 22, 2006 at 6:07 pm