gints.plivna (2/14/2008)

---

If one gets a new car by another vendor he understands that the core functionality is the same i.e. the car can be driven but switches, detectors, the general...

JohnG (2/14/2008)

---

Heh... thanks Steve... I'll consider it. It would be very difficult, though, because I break out in a bad case of Tourette's syndrome every time I try to do...

Christopher Ford (2/13/2008)

---

Earlier Jeff posted a question on using SUM(SAL) OVER()

Since OVER() doesn't support ORDER BY when used with an aggregation.

How about this one?

SELECT J1.AccountID,

J1.Date,

...

While I certainly agree that one should use the right tool for the right job, I'll also be the first to disagree about the shorter the code, the faster it...

Steve Rosenbach (2/14/2008)

---

Hey Jeff!

Sounds like you're a good candidate to write "ORACLE for SQL Server Developers." 🙂

Seriously, would you consider writing an article for SQLServerCentral.com about some of the...

Agreed... basically the same... I've got an extra "Compute Scalar" 'cause of the formatting I did...

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 😀