If you can set up your sample dataset in a readily-consumable format, I'll see what I can do.

Readily-consumable means a script which will run and populate the sample table with...

Try again:

Like Jeff I set up a scaled-up dataset to test against but ran out of time over the weekend to post it up. After reading Jeff's post I've added...

There appears to be a severe problem with posting at present.

Like Jeff I set up a scaled-up dataset to test against but ran out of time over the weekend to post it up. After reading Jeff's post I've added the...

sqldriver (10/24/2014)

---

ChrisM@home (10/24/2014)

---

Sure. Have a good look at the...

You're welcome:

--------------------------------------------------------------------------------------

-- Items

--------------------------------------------------------------------------------------

IF OBJECT_ID ('tempdb..#Items') IS NOT NULL DROP TABLE #Items

SELECT DISTINCT

ipcm.KeyDepot,

KeyVendor,

ipcm.KeyItem,

StockingUnitofMeasure,

LeadTime,

LotSize,

ipcm.MinimumBalance,

ipcm.PurchasingBuyerCode

,CASE WHEN BuyerCodes.PrimaryCode IS NULL THEN 'No Buyer Code Linked' ELSE BuyerCodes.Description END AS...

So now you understand that if you were to include this date column in your result set, it would increase your output rowcount by quite a lot - which was...

Thanks.

Here's that same query reduced even more so it's much easier to understand:

--------------------------------------------------------------------------------------

-- PlannedRequirement (cut down even more)

--------------------------------------------------------------------------------------

SELECT

KeyDepot = fpo.KeyDepotPlannedOrder,

fpo.KeyItem,

MIN_keydate = MIN(fpo.KeyDatePlannedRelease),

MAX_keydate = MAX(fpo.KeyDatePlannedRelease)

FROM BI1_DW_Fact_FirmPlannedOrders...

Thanks. Can you check this one please? I'm interested in the row count compared with the original, and also the difference between the min and max dates. "The original" in...

Here's that query again as a reminder. I need to know which table the column "keyitem" comes from:

/*

dbo.BI1_view_Dim_ItemMaster IM = keyitem

BI1_DW_Dim_CalendarDefinition = keydate

*/

--------------------------------------------------------------------------------------

--...

Hi Ben

ben.brugman (10/23/2014)

---

First of all thanks,

Now I see I did muck up a bit, the temp table ##WW should have been ordered, see the code below. Probably lost that part...

Which table contains column "keyitem" as referenced in the original query?

Can you describe the result set you get from this query please? I'm interested in the row count compared with the PlannedRequirement query (they should be the same), and any...

Excellent! Now we can work with a much smaller query than the original. You want to see keydate in the output of the PlannedRequirement query, correct?

Excellent. Next step, can you test this modification of your query please?

--------------------------------------------------------------------------------------

-- Items

--------------------------------------------------------------------------------------

IF OBJECT_ID ('tempdb..#Items') IS NOT NULL DROP TABLE #Items

SELECT DISTINCT

ipcm.KeyDepot,

KeyVendor,

ipcm.KeyItem,

StockingUnitofMeasure,

LeadTime,

LotSize,

ipcm.MinimumBalance,

ipcm.PurchasingBuyerCode

,CASE WHEN BuyerCodes.PrimaryCode IS...