Hi Sean et. al,

What a waste of time that was 🙂 After many fruitless attempts to change the Stored Procedure, which either ended in not updating the desired Field anymore...

The only way to fix this in the SP is to check the value of the column you care about and not include that column in the update if it...

Hey Sean,

I moved my last one about the Stored Procedure into a New Topic ... you're more than welcome to check it out 🙂 ...

Is there a way to...

Hi and thanks again for your input ...

I think you are making this way too complicated by having denormalized information. The relationship between Customer and rooms like you are doing...

Hey Sean,

a German Final in Wembley ... lol 🙂

Now if you try to update any of your existing data and increase the Amount_ACA or insert a new Wages row it...

... I played around with it now (sober), but I can't get it to work ... the problem seems to be somewhat to be the Calculation and with that the...

It still is, especially if you like Borussia Dortmund 🙂 ...

So to make sure we are on the same page....

Oh Bollocks, I entered the Break_ID 3 twice in my TestData - sorry ... after Removing the first one the statement returns 1 row only ... obviously with the real...

Cheers for the reply ...

There's two problems here with this solution ... 1.) The Breakdown-Table contains the constants, I'd need these Computed Columns on my Wages Entry table as e.g....

Hi Sean,

after a looong sleep I'm a bit more rested and cleared up a bit ... First my 3 slightly shorter Tables & some Data:

First Table is the Breakdown-Table -...

Hey Sean,

about to fall to sleep - 4:15 AM here, but the Football kept me up ...

Just to clarify: In my Scenario it's the other way around. The Breakdown.Amount_Aca is...

Hey Sean,

thanks and sorry - I am new to posting on Forums, usually I find what I need in other Posts 🙂 ... and new to the whole problem ...

I...