SELECT distinct CUST.ABC_FORECASTGROUPID, FORCAST.DESCRIPTION, SALE.ITEMID, sum(SALE.QTYORDERED), DATACELLS.cellvalue, cast(year(SALE.CONFIRMEDDLV) AS varchar(4)) + cast(DATEPART(week,SALE.CONFIRMEDDLV) as varchar(2)) FROM [hgf-sql01].[hfgh-axdb5-drift].[DBO].[SALESLINE] AS SALE INNER JOIN [hgf-sql01].[hfgh-axdb5-drift].[DBO].[CUSTTABLE] AS CUST ON ( ((SALE.CUSTACCOUNT = CUST.ACCOUNTNUM) AND (SALE.DATAAREAID COLLATE DATABASE_DEFAULT = CUST.DATAAREAID COLLATE DATABASE_DEFAULT)) ) INNER JOIN [hgf-sql01].[bizview_hfs].[dat].[data_cells] AS DATACELLS ON ( ((CUST.ABC_FORECASTGROUPID COLLATE DATABASE_DEFAULT = DATACELLS.ws_name COLLATE DATABASE_DEFAULT) OR (CUST.ABC_FORECASTGROUPID=' ')) AND (DATACELLS.version_id='PU4012') AND (DATACELLS.valtype_id='ANT') AND (DATACELLS.timeunit_id='ISOWEEK') AND (DATACELLS.timeval_id=cast(year(SALE.CONFIRMEDDLV) AS varchar(4)) + cast(DATEPART(week,SALE.CONFIRMEDDLV) as varchar(2))) ) INNER JOIN [hgf-sql01].[bizview_hfs].[dat].[data_dimensions] AS DIMENTIONS ON ( ((DATACELLS.dim_cluster_id = DIMENTIONS.dim_cluster_id) AND (DIMENTIONS.obj_id='item') AND (DATACELLS.client_id = DIMENTIONS.client_id)) ) INNER JOIN [hgf-sql01].[hfgh-axdb5-drift].[DBO].[ABC_FORECASTGROUP] AS FORCAST ON ( ((FORCAST.FORECASTGROUPID = CUST.ABC_FORECASTGROUPID) AND (FORCAST.DATAAREAID = CUST.DATAAREAID)) ) group by CUST.ABC_FORECASTGROUPID, FORCAST.DESCRIPTION, SALE.ITEMID, DATACELLS.cellvalue, cast(year(SALE.CONFIRMEDDLV) AS varchar(4)) + cast(DATEPART(week,SALE.CONFIRMEDDLV) as varchar(2))
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
Is CUSTACCOUNT, ACCOUNTNUM and DATAAREAID are indexed columns?