Seems like this should work okay.

There is not a way that I am aware of. You could do it in the CLR, but I don' think you could have the CLR procedure be Trusted....

GilaMonster (10/29/2009)

School?

It's 11pm and I'm just starting on a report that'll likely take 2-3 hours. Answer your...

Unfortunately no one can really give you an answer to this question, but we can offer advice.

Are you married or in a serious relationship? Do you have...

Nabha has provided what I would consider to be the best solution. In SQL Server you cannot evaluate multiple columns using column in (Select columnA, ColumnB from Table). ...

Nice solution David. I was going to suggest that an ordering column in the table would be necessary. It may still be if the other languages come out...

I'd do SSIS. It is designed and optimized to do this. I think it will likely work better. Realize that there will be a learning curve.

Check out this blog post on the CSS SQL Server Engine Blog.

If I recall I totally choked my last phone interview. Of course it was for a Software Developer position not a DBA position, so when they got into all...

Data stored as 23-Apr, without a year are not a date datatype so they will not match a true datetime datatype.

If you can get your hands on the 2008 tools there is a Copy With Headers option in the right-click context menu.

Sure there may be many valid reasons for it to be there, but I'd still be concerned and do something to find out why it is there.

Wow, glad you are "okay" Roy. That's scary. Will pray that you heal up quickly and can get the car fixed/replaced without too much effort.

Y'all may want to take a look at this thread, http://www.sqlservercentral.com/Forums/Topic771369-149-1.aspx as the resolution is a workaround provided by MS for a bug in a HASH MAP JOIN plan.

Interesting. Thanks for posting the resolution even though it came months later.