Alright, I've got a related question then.

How do you convert sql datetime values to Excel values? It looks like Excel only supports DT_DATE, but when I set...

steveb (3/3/2009)

---

Also you mention that they do not want to use CSV files, is there a reason for this? as this would save a lot of headaches involved...

Interesting - thanks for all the replies! I'll play with it some more today and see what happens!

Thanks! I'll turn the deadlock flag on....I'm pretty sure it's definitely a code and/or index problem (it's a legacy VB6 app I've inherited), but trying to pinpoint where things...

Hmmmm....it does seem like that would work; I wasn't sure if the...

GSquared (5/21/2008)

---

I also have to ask about having to propagate all structure changes to all databases (on all servers). Is that really necessary in this case? If one...

Thank you everyone! Interesting points, and it's good to see a different perspective. Thanks for the lesson!

Nice list! One thing I've been looking for forever, but never found (for free) is some tool to help manage pushing changes from development or testing servers to production...

Thank you for the interesting article! I'm just starting to try and get real virtualization going as a development environment and have run into similar issues, too. Since...

Hah, I thought the same thing! ...

Yeah, I've determined that from some more searching. Bah! What a stupid, stupid move. I was able to reinstall the stripped down VS2005 from the SQL install...

Nice article! I may have to take another look at some of my queries....

So, something like this:

Select

*

FROM

CadencedEventCustomer

WHERE

((FullName1 = 'Ed Jones')...

Thanks, that was my thinking, too regarding the 'easier...

Thank you,...

Doh, I'm on SQL2000 for a month or so longer until we finish the upgrade to 2005....what's the CTE again?

The subquery seems to work, it just takes longer than what...