That table sounds fairly difficult to build. I'd have to have date ranges for each timezone to take daylight savings into account. Is it easier than I'm thinking?

No, it could be any timezone.

Basically I need a function to convert datetime to UTC like so:

datetime convertToUTC(datetime, string) where the string is a timezone like "(GMT-06:00) Central Time (US & Canada)"

I have a requirement...

I started out and got thrown into the world of SQL with nothing but a select and a where clause to work with. I was lucky enough to have someone...

Talk about a holy war.

CaseSensitivity ++;

I can't really say I enjoy writing all that much, but it's a skill that you need to continue to work on throughout your life. If you can't communicate your...

I have done a similar thing with matching flight dates/times and it worked out really well using SSIS. It takes a bit of time playing with the threshold you want...

There is one thing you can do while the computer is locked. You can turn on...

So basically you deleted all of the rows that didn't have foreign key relationships?

I don't think using min(ID) would work since the ID column is a GUID right?

I've had bad dealings with Amazon in the past so I'm biased, but I know I'd fight it tooth and nail. Who's to say I have the money to pay...