So youjust need to order by those two bit fields? Are they bit fields or varchar's

(are then 'y' or 1)

I created a table matching your but for simplicity I...

Ahh. I am guessing that the application in question does not have direct access to the file system in question. So SQL is sort of serving as a proxy for...

I hope I understand the question.

Is there a reason not to simply store the path in SQL then use your script for access?

In my webapps that manage file up/dl's I...

Would substring be allot slower then datdiff?

e.g.

substring(date1,12,2) = substring(date2,12,2)

I am assuming that we are trying to find rows in one table that are within the same hour as the other...

Great, thanks for that, I think I will continue using UDF's for code readability and consistancy. In the current app I am working on I need to copnvert varchar...

Thanks Jeff, I'll probably replace mine with yours, thanks for that.

Tell me, is there a performance hit for wrapping a formula like this in a function? In some large...

OK to answer my own question more fully, here are two UDF's I created to return the start and end of a week given a week number and a year....

Doh! Nevermind, if I have dayOfYear its a simply dateadd() from Jan 1 to get the date I am after.

Well sometime it helps to write down my question so that...

I have persits aspEmail component installed on my server for use with ASP pages so I am now just using it from stored proc's as well and it works great...

Doh! Yes thank you that did the trick.

It's not read only. Just read mostly. Each day a a hundred thousand+ rows are added. Putting the trans logs on a drive by themselves allows the file to be...

Sorry, sloppy on my part when describing the fields. The clustered index is [start],[end],[country] already I just wrote it wrong in the post.

However, I just took a look at the...

OK I will. I have the execution plan on my monitor right now but it's the graphical one. I'll choose the text version and run it again later tonight when...

Follow up:

I have the new server up and running and it has made a big difference in performance.

The server is a hosted dedicated server and I had very little...

I am working a number of angles on this. I just realized that although I have 11 indexes on the main table in question I don't have one suitable for...