it's the same as in #plannedrequirement

the row count is: 3296.

oh, sorry, it comes from: BI1_DW_Fact_FirmPlannedOrders

dbo.BI1_view_Dim_ItemMaster IM = keyitem

BI1_DW_Dim_CalendarDefinition = keydate

this query has almost half the rows 3296, whereas the larger query that you wrote had the correct amount of rows: 6810

Yep. I await with baited breath how you are going to do this. I am studying your code as we type

Hi Chris. Yes it works, but had to take the keydate out of the main query as that is part of the:

LEFT JOIN BI1_DW_Dim_CalendarDefinition PlannedRelease (NOLOCK)

on PlannedRelease.keydate = KeyDatePlannedRelease

in...

Yes I am

Hi Chris

Thanks in advance.

Down below is the original query. I have made a note in the query of the column that I want to populate.

SELECT --- this...

Hi Koen

Thanks for your reply. What version of SQL Server did you run this on? It might just be me being silly, but I can't run the...

Thanks Koen.

Hi Alex

Unfortunately it does not, hence my question.

Kind regards

Hi Luis

It's always rounded to the full decimal, ie, 7.000, 8.000.

Kind regards

Hi Koen

There's no other variable datatype that I use that seem to work other than the object data type.

Will make do with it in the meantime and see...

Hi Koen

It actually works when I set it up as an object. I just didn't debug it, so put a Script Task up and it actually displays it as...