Jonathan thank you!! It works. I appreciate your help!!

Something must be incorrect. It just keeps running and running. There are only around 249K rows I believe and it is running for pretty long time already and no output.

Jonathan thanks for your help. I appreciate it.

There is an issue here. It just prints all the chain names and doesn't differentiate that some UPCs are not available or available...

Jonathan it is Microsoft SQL Server 2016

I have SSMS v18.5.1. When I tried to do it, it gave me an error namely 'STRING_AGG' is not a recognized built-in function name.

Thank you for your help.

Jonathan great. Thanks. I appreciate your help.

One more small question. This code basically compares items between ITEM/LOC and temp and returns if there is a mutual match between temp table...

Jonathan AC Roberts I think yours work. Thank you.

Can I ask do you know guys what am I doing wrong?

I am trying to detect if items from the table TEMPLATE...

drew.alen

It doesn't want to accept the code in the middle with ;WITH clause

Jeff you are right. It shows last week. My apology for this question. Thank you for helping.

@jonathan-2 AC Roberts it works. Thank you!!

@drew.allen it is still wrong though.

The first row should return 46006690.094600 and it returns smth unexpected 36980572.510250

I thought that I need to do just simple moving average

AVG([ONQTYCOGS]) OVER ( ORDER BY [WED]

ROWS BETWEEN 52 PRECEDING AND CURRENT ROW

) ROLL1

but it doesn't return what I need (the...

/* drop table DC_ANALYSIS;

create table DC_ANALYSIS (

DC int,

WED int,

ONQTYCOGS decimal(12,2),

OBCOGS decimal(12,2))

*/

The explanation what I am trying to achieve is above. ROLL1 should be average of 1 week for the first...

ScottPletcher and pietlinden this is what I need. Thank you very much!!

Jeff Moden I did it 3 times to show that I visually display the result of each of them....