Jeff Moden (7/2/2008)

---

You didn't know it was a mostly ETL job going in? Company either made a mistake or weren't getting any responses to begin with so changed the...

sead.j (7/2/2008)

---

smunson (7/2/2008)

---

Come to think of it, I realized this wasn't all that hard if a table variable is ok...

Try this on for size - I have no NORTHWIND available,...

Sounds to me you'd be best off with a "parts classification" process, which you could then codify into a "generic" part number to see all of the equivalents. As...

Looks like some incredibly arcane lookup table that seems to be getting called recursively. My initial reaction would be - there has GOT to be a better way to...

smunson (7/2/2008)

---

Matt,

I by no means advocate a loop solution, but was just trying to get the OP to come clean on the whole deal instead of feeding it in piecemeal....

smunson (7/2/2008)

---

Really? Perhaps you need to restate the problem. What it appears you are asking for is a solution to a general class of problem: ...

Education of your user base....

Even with the excellent advice from Gus - enough detail records being rounded off will STILL introduce those occasional "issues", even if you're maintaining...

Woohoo! That's awesome! Good for both of you! Definitely some great choices in the MVP category this go-round!

alorenzini (7/1/2008)

---

Is there a way to created a derived column expression based on a Case Statement or how would I convert it into a appropriate expression?

code:

UPDATE newvolume.Volume

SET PaidAtLevelXID =...

All right....I'll spare you the comment (been there done that got the Duhh t-shirt on right now!)...

that being said - I'm thinking you want to read through this article -...

Jeff Moden (7/1/2008)

---

Ross McMicken (6/30/2008)

---

I would love to improve the vendor package I support, but management won't let me unless I can convince the vendor to make the change. Which...

I have to disagree with you, not at your conclusion, or your personal choice, but at your...

All right - no problem. Under those circumstances - mine is actually the slowest of the three methods, then Brother Itzik's, with the fastest being the cross join. ...

You're right of course - here's an actual useable version. This would create a temporary numbers table (1M rows), with the requisite index to make it all worthwhile...

drop table...

you mean the extra comma? ...hehe...:D

Let me go correct that