Good idea. I was utterly dumbstruck by his performance ranking of the rCTE solution to...

Jeff Moden (7/26/2012)

---

I know I enjoyed it. Gave me a chance to try out my new 4 band porkchop...

Glad you got it sorted. If you're interested in a way to generate a depreciation schedule (including accumulated depreciation, which was the value you were seeking),...

Brandie Tarvin (7/26/2012)

---

dwain.c (7/25/2012)

---

Jeff Moden (7/25/2012)

---

Please join me in reporting this and all other posts of this nature by this person. This has got to stop. If anyone...

Gert,

Now that I've looked, I'm not sure I understand what the remaining question is.

It appears that your second query is correctly using CROSS APPLY VALUES to UNPIVOT the flat table...

Gert,

I'm taking a look now.

Had a bit of a problem getting your last posted script to run. You had this (in the second SELECT):

FROM dbo.bo_MatchResult

And I had to change...

Jeff Moden (7/25/2012)

---

Please join me in reporting this and all other posts of this nature by this person. This has got to stop. If anyone of us made...

Actually, it's a technique that I don't think has widespread knowledge. I hit upon...

I think you may have forgotten to include the attachment?

The code you posted is likely to perform better than any looping/dynamic script you can create.

If you just want to do it as an exercise, that's fine. But for...

Not sure why you're hard coding the Feb date into your queries. The "effective date" should already be in a Rates table.

As Koen suggests, post your DDL and sample...

OK apology accepted.

The real question is do you have something that works and does it perform satisfactorily?

If you provide DDL and sample data for your PO Header and Detail tables, I or someone else can make short work of this and give you a tested solution.

I'm using the cross tab approach and it's quite easy to construct with copy and paste.

Read my mantra and avoid loops when they're not necessary. It is better to...

After only minor fixes to your DDL and sample INSERT, I propose the following as your solution instead of UNPIVOT.

CREATE TABLE #Test

(

ProductID INT NULL,

Name NVARCHAR(50),

ProductNumber NVARCHAR(25),

MakeFlag BIT null,

FinishedGoodsFlag BIT null,

Color...