How could i updated a table created with 5 tables.

Hi Kalman,

Thank you for your email, but your solution doesn´t work. The problem is still.

I leave my script

IF OBJECT_ID('Non_current_assets_Historic') IS NOT NULL
  DROP TABLE Non_current_assets_Historic
GO
CREATE TABLE Non_current_assets_Historic
(
        [IdCuenta] [float] NOT NULL,
        [NameCuenta] [nvarchar](255) NULL,
        Year_2006 decimal (14,2) NULL,
        Year_2007 decimal (14,2) NULL,
        Year_2008 decimal (14,2) NULL,
        Year_2009 decimal (14,2) NULL,
        Year_2010 decimal (14,2) NULL,
        Year_2011 decimal (14,2) NULL,
        Year_2012 decimal (14,2) NULL,
        Year_2013 decimal (14,2) NULL,
        Year_2014 decimal (14,2) NULL,
        Dif_2007_2006 decimal (14,2) NULL,
        Dif_2008_2007 decimal (14,2) NULL,
        Dif_2009_2008 decimal (14,2) NULL,
        Dif_2010_2009 decimal (14,2) NULL,
        Dif_2011_2010 decimal (14,2) NULL,
        Dif_2012_2011 decimal (14,2) NULL,
        Dif_2013_2012 decimal (14,2) NULL,
        Dif_2014_2013 decimal (14,2) NULL,
        AHP_2007_2006 decimal (14,2) NULL,
        AHP_2008_2007 decimal (14,2) NULL,
        AHP_2009_2008 decimal (14,2) NULL,
        AHP_2010_2009 decimal (14,2) NULL,
        AHP_2011_2010 decimal (14,2) NULL,
        AHP_2012_2011 decimal (14,2) NULL,
        AHP_2013_2012 decimal (14,2) NULL,
        AHP_2014_2013 decimal (14,2) NULL,
        )
GO

ALTER TABLE Non_current_assets_Historic
  ADD CONSTRAINT PK_Non_current_assets_Historic PRIMARY KEY (IdCuenta)
GO


UPDATE Non_current_assets_Historic  SET Year_2006=0 WHERE Year_2006 IS NULL
UPDATE Non_current_assets_Historic  SET Year_2007=0 WHERE Year_2007 IS NULL
UPDATE Non_current_assets_Historic  SET Year_2008=0 WHERE Year_2008 IS NULL
UPDATE Non_current_assets_Historic  SET Year_2009=0 WHERE Year_2009 IS NULL
UPDATE Non_current_assets_Historic  SET Year_2010=0 WHERE Year_2010 IS NULL
UPDATE Non_current_assets_Historic  SET Year_2011=0 WHERE Year_2011 IS NULL
UPDATE Non_current_assets_Historic  SET Year_2012=0 WHERE Year_2012 IS NULL
UPDATE Non_current_assets_Historic  SET Year_2013=0 WHERE Year_2013 IS NULL
UPDATE Non_current_assets_Historic  SET Year_2014=0 WHERE Year_2014 IS NULL  

GO


INSERT INTO Non_current_assets_Historic
SELECT *
FROM  Property_plant_equipment_Historic

INSERT INTO Non_current_assets_Historic
SELECT *
FROM  Intangible_assets_Historic

INSERT INTO Non_current_assets_Historic
SELECT *
FROM  Available_financial_assets_Historic

INSERT INTO Non_current_assets_Historic
SELECT *
FROM  Deferred_tax_assets_Historic

INSERT INTO Non_current_assets_Historic
SELECT *
FROM  Deposits_restricted_12M_Historic

GO

Regards,

Francisco