select distinct salesYear, salesMonth from tbl_IMPORT_DistributorSales where ownerId = and ownerType = and eai_batchId = order by salesYear, salesMonth ---> update tbl_IMPORT_DistributorSales set fseForecast_Year = , fseForecast_Month = , fseFiscalYear = , fseFiscalPeriod = , fseFiscalWeek = where salesYear = and salesMonth = and eai_batchId = and ownerId = and ownerType = select distinct sku from tbl_IMPORT_DistributorSales where ownerId = and ownerType = and eai_batchId = and nullif( sku, '' ) is not null select s.sku, s.skuId, s.skuType, s.isOrderable, coalesce( s.equivUnitsPerCase, 1 ) equivUnitsPerCase, s.bgtCatId l1BgtCatId, p.prodId, p.bgtCatId l2BgtCatId, s.bgtCatOverride l1BgtCatOverride from tbl_PRD_Skus s with (nolock) inner join tbl_PRD_Products p with (nolock) on p.prodId = s.prodId and p.ownerId = s.ownerId and p.fsl_tablecode = s.fsl_tablecode where s.sku like and s.ownerId = and s.fsl_tablecode = order by s.skuId select * from qmd_skuLookup where skuType = 'CA' or isOrderable = 'Y' select s.sku, s.skuId, s.skuType, s.isOrderable, coalesce( s.equivUnitsPerCase, 1 ) equivUnitsPerCase, p.prodId, s.bgtCatId l1BgtCatId, p.bgtCatId l2BgtCatId, s.bgtCatOverride l1BgtCatOverride from tbl_PRD_Skus s with (nolock) inner join tbl_PRD_Products p with (nolock) on p.prodId = s.prodId and p.ownerId = s.ownerId and p.fsl_tablecode = s.fsl_tablecode where s.ownerId = and s.fsl_tablecode = and LTRIM(RTRIM(SUBSTRING(s.sku, (PATINDEX('%[^0]%', s.sku)), 25))) = select * from qmd_skuLookup where skuType = 'CA' or isOrderable = 'Y' update tbl_IMPORT_DistributorSales set fseSkuId = , fseSku = , fseProdId = , fseBgtCatId = where eai_batchId = and ownerId = and ownerType = and sku = select distinct customerNbr from tbl_IMPORT_DistributorSales where eai_batchId = and ownerId = and ownerType = select cdr.cdr_recordId, ter.territoryId from tbl_CDR_Distributors cdr inner join tbl_TER_Territories ter on ter.territoryId = cdr.cdr_territoryId and ter.ownerId = cdr.ownerId and ter.fsl_tablecode = cdr.fsl_tablecode where cdr.ownerId = and cdr.fsl_tablecode = and EXISTS (SELECT * FROM tbl_CDR_Dstcodes cdrd WHERE cdrd.ownerId = cdr.ownerId AND cdrd.ownerType = cdr.fsl_tablecode AND cdrd.cdr_dstcode = AND cdrd.cdr_recordid = cdr.cdr_recordid) order by cdr.cdr_recordId update tbl_IMPORT_DistributorSales set fseCdr_RecordId = , fseSalesTerritoryId = , fseDistributorStatus = 'M' where eai_batchId = and ownerId = and ownerType = and customerNbr = select distinct fseForecast_year, fseForecast_month from tbl_IMPORT_DistributorSales with (nolock) where eai_batchId = and ownerId = and ownerType = delete from tbl_MFR_TPF_Detail#_tpfSuffix# where mfr_id = and forecast_status = 'F' and tPartnerType = 'CDR' and forecast_year = and forecast_month = insert into tbl_MFR_TPF_Detail#_tpfSuffix# ( mfr_id, forecast_status, forecast_year, forecast_month, productItemCode, productLevel, skuId, prodId, bgtCategoryId, tPartnerId, tPartnerType, territoryId, forecast_alt, forecast_qty, forecast_amt, lastUpdateSource, lastUpdate) select ownerId mfr_id, 'F' forecast_status, fseforecast_year forecast_year, fseforecast_month forecast_month, fseSku productItemCode, 'SKU' productLevel, fseSkuId skuId, nullif( fseProdId, 0 ) prodId, nullif( fseBgtCatId, 0 ) bgtCatId, fseCdr_recordId tPartnerId, 'CDR' tPartnerType, fseSalesTerritoryId territoryId, sum( fseAlt ) forecast_alt, sum( #_forecastQty# ) forecast_qty, sum( fseDollars) forecast_amt, , from tbl_IMPORT_DistributorSales where eai_batchId = and ownerId = and ownerType = and fseForecast_year = and fseForecast_month = and fsecdr_recordId is not null and fseskuId is not null group by ownerId, fseforecast_year, fseforecast_month, fseSku, fseSkuId, fseProdId, fseBgtCatId, fseCdr_recordId, fseSalesTerritoryId select fseforecast_year, fseforecast_month, fseSku, fseSkuId, fseProdId, fseBgtCatId, fseCdr_recordId, fseSalesTerritoryId, sum( fseAlt ) fseAlt, sum( fseCases ) fseCases, sum( fseLbs ) fseLbs, sum( fseDollars) fseDollars from tbl_IMPORT_DistributorSales where eai_batchId = and fsecdr_recordId is not null and fseskuId is not null and fseForecast_year is not null and fseForecast_month is not null group by fseforecast_year, fseforecast_month, fseSku, fseSkuId, fseProdId, fseBgtCatId, fseCdr_recordId, fseSalesTerritoryId update tbl_MFR_TPF_Detail set forecast_alt = , forecast_qty = , forecast_amt = , productItemCode = , prodId = , bgtCategoryId = , lastUpdateSource = , lastUpdate = , territoryId = where forecast_year = and forecast_month = and tPartnerType = 'CDR' and tPartnerId = and productLevel = 'SKU' and skuId = and mfr_id = and forecast_status = 'F' insert into tbl_MFR_TPF_Detail ( forecast_alt, forecast_qty, forecast_amt, productItemCode, prodId, bgtCategoryId, lastUpdateSource, lastUpdate, forecast_year, forecast_month, tPartnerType, tPartnerId, skuId, productLevel, mfr_id, forecast_status, territoryId ) values ( , , , , , , , , , , 'CDR', , , 'SKU', , 'F', ) ---> select fseForecast_year, fseForecast_month, fseSalesTerritoryId, fseBgtCatId, sum( fseCases ) fseCases, sum( fseLbs ) fseLbs, sum( fseDollars ) fseDollars, sum( fseAlt ) fseAlt from tbl_IMPORT_DistributorSales where eai_batchId = and ownerId = and ownerType = and fseBgtCatId is not null and fseSalesTerritoryId is not null group by fseForecast_year, fseForecast_month, fseSalesTerritoryId, fseBgtCatId order by fseSalesTerritoryId, fseForecast_year, fseForecast_month update tbl_MFR_TPF_Detail#_tpfSuffix# set forecast_alt = , forecast_qty = , forecast_amt = , lastUpdateSource = , lastUpdate = where forecast_year = and forecast_month = and tPartnerType = 'TER' and tPartnerId = and bgtCategoryId = and productLevel = 'UOM' and productItemCode = and mfr_id = and forecast_status = 'F' insert into tbl_MFR_TPF_Detail#_tpfSuffix# ( forecast_alt, forecast_qty, forecast_amt, lastUpdateSource, lastUpdate, forecast_year, forecast_month, tPartnerType, tPartnerId, bgtCategoryId, productLevel, productItemCode, mfr_id, forecast_status ) values ( , , , , , , , 'TER', , , 'UOM', , , 'F' ) update tbl_MFR_TPF_Detail#_tpfSuffix# set forecast_alt = , forecast_qty = , forecast_amt = , lastUpdateSource = , lastUpdate = where forecast_year = and forecast_month = and tPartnerType = 'TER' and tPartnerId = and productLevel = 'UOM' and productItemCode = 'MKT_0' and mfr_id = and forecast_status = 'F' insert into tbl_MFR_TPF_Detail#_tpfSuffix# ( forecast_alt,forecast_qty, forecast_amt, lastUpdateSource, lastUpdate, forecast_year, forecast_month, tPartnerType, tPartnerId, productLevel, productItemCode, mfr_id, forecast_status ) values ( , , , , , , , 'TER', , 'UOM', 'MKT_0', , 'F' ) select distinct fseFiscalYear fiscalYear from tbl_IMPORT_DistributorSales where eai_batchId = and fseBgtCatId is not null and fseSalesTerritoryId is not null order by fiscalYear desc select distinct fseSalesTerritoryId, fseFiscalYear fiscalYear from tbl_IMPORT_DistributorSales where eai_batchId = and fseBgtCatId is not null and fseSalesTerritoryId is not null