Buckets and Amounts Tables

    CREATE TABLE Buckets
    (
    InstrumentID INT NOT NULL,
    Bucket1 NUMERIC(19, 2) NULL,
    Bucket2 NUMERIC(19, 2) NULL,
    Bucket3 NUMERIC(19, 2) NULL,
    )

    CREATE TABLE Amount
    (
    InstrumentID INT NOT NULL,
    SEQUENCE INT  IDENTITY(1,1) NOT NULL,
    TypeID INT NULL,
    EffectiveDate datetime NULL,
    Amount NUMERIC(19, 2) NULL,
    Bucket1 NUMERIC(19, 2) NULL,
    Bucket2 NUMERIC(19, 2) NULL,
    Bucket3 NUMERIC(19, 2) NULL,
    )

    INSERT INTO Buckets (InstrumentID,Bucket1,Bucket2,Bucket3)
         VALUES (1,500,200,3000)

    INSERT INTO Buckets (InstrumentID,Bucket1,Bucket2,Bucket3)
         VALUES (2,300,400,9000)

    INSERT INTO Amount (InstrumentID,TypeID,EffectiveDate,Amount)
         VALUES (1,0,'2015-06-29',600)

    INSERT INTO Amount (InstrumentID,TypeID,EffectiveDate,Amount)
         VALUES (1,2,'2015-06-30',400)

    INSERT INTO Amount (InstrumentID,TypeID,EffectiveDate,Amount)
         VALUES (1,0,'2015-06-30',600)

    INSERT INTO Amount (InstrumentID,TypeID,EffectiveDate,Amount)
         VALUES (2,0,'2015-06-29',500)

    INSERT INTO Amount (InstrumentID,TypeID,EffectiveDate,Amount)
         VALUES (2,1,'2015-06-30',500)

    INSERT INTO Amount (InstrumentID,TypeID,EffectiveDate,Amount)
         VALUES (2,0,'2015-06-30',300)