Hi,

The DimAccounts table is only there to provide with the column AccountCodeAlternateKey for the WHERE filter.

It is the Amount column of [dbo].[FactFinance] I would like to update. That column is...

The original table looks like this:

CREATE TABLE [dbo].[FactFinance](

[FinanceKey] [int] IDENTITY(1,1) NOT NULL,

[DateKey] [int] NOT NULL,

[OrganizationKey] [int] NOT NULL,

[ClientKey]...

Thanks,

I think I was a bit unclear in my post. I have managed to get that far. It's the update part that is still unsolved. That is, I want to...