SELECT Date,
       SUM([101]) OVER (ORDER BY Date) Acct#1,
       SUM([201]) OVER (ORDER BY Date)...

I'm not sure if the OVER clause is available in SQL 2008, if it isn't you can use this method:

SELECT a.Date,
      ...

SELECT Date,
       SUM([101]) OVER (ORDER BY Date) Acct#1,
       SUM([201]) OVER (ORDER BY Date) Acct#2,
 ...

Don't know how come I missed that. The BWAvg will be NULL when the data is inserted and will be updated later.

insert into tblData3 Values ('4567','ABC',NULL)
insert...

It would be helpful if you could show what results are expected.

There is no data in tblData3 so I don't see how you can do an update?

I also realize that this post is really old but below is a script I put together that could be helpful to others running across this post. This...

Regarding question #3, let's say I didn't have columns called "Installed" and "Date Received."  I just put those in there to give examples of other fields.  So I I...

1. Yes
2. Yes, and a lot more. On some Fact tables in data warehouses it's not uncommon to have over 100 foreign keys on a table. A foreign key must...

I usually don't accept a method claimed to be "most efficient" without data to support. More importantly, I don't like your tone. Could you please not use words like...

I think you need a new CycleParts table with two columns CycleId and  PartId. You need 2 foreign keys on this table. One pointing to the Cycle table the other...

Why on Earth...

First I would try adding this index to table CommoditySupplier:

CREATE INDEX IX_CommoditySupplier_CommodityID_INC_SupplierID
          ON CommoditySupplier(CommodityID) INCLUDE (SupplierID);

If that doesn't...

lol, I take it that is a joke?

declare @i as int=16
select right('00000'+convert(varchar,@i),5)

Why have you posted this in SQL 2017 when it's for SQL 2014? What do you mean by getting struck? Did you mean stuck? What are you trying to do?...