Well stated in both posts, Christopher... But, you've been spoiled by SS 2k5... none of that works in 2k and, I don't know about other folks, but the companies I've...

No, they really don't.

In SQL Server, the UPDATE statement has a FROM clause where you can do...

Just curious, Art... haven't seen it before... what does a "Database Analyst" do? In other words, what's the job description for a "Database Analyst"?

Aaron,

This should do it... also, take a look at how I created the test table and data... would help a lot if you could post sample data like that in...

Christopher Ford (2/13/2008)

---

Jeff, I could almost hug you actually...you wrote an article the other day that I have been working a problem for 6 months on trying to solve. ...

Vika (2/4/2008)

---

OK you are right. It is not possible to bulk insert from the file into a table variable. It is possible to bulk insert from the file into a...

Tom Leykis (2/13/2008)

---

Ok, this will really light your fire :hehe:

The reason I was asking is becuase it's my database, for my company, that I manage the db for, because I'm...

Absolutely agree with that... that's what makes forums like this so interesting and useful... differing experiences and opinions...

By the way... We did run into the problem of "If the...

Heh.... it's ok Steve... we're all friends here... I don't know how to read either 😀

What are you going to mess around with in the phsical...

Tom Leykis (2/13/2008)

---

I think having proper code should be assumed. My original question was asked so that I can properly setup a new db and not worry about adding multiple...

Christopher Ford (2/13/2008)

---

What if you can't fix the code?

I did mention fixing code in my post. But that's not what this topic was about. It...

Nuts,

I always like to see what people have up their sleeves for date and other utility tables... would you mind generating/posting the CREATE statement for your date table and maybe...

Heh... all of that good information to solve, what?... .5% of the total performance problem? The real problem associated with most performance problems has nothing to do with hardware...

Ya gotta learn to do it right, Matt... when you're running and screaming from his/her office, it's his/her hair that you're supposed to have a handful of... not your own...