Here is another way:

CREATE FUNCTION dbo.GetSaturday (@Date DATETIME)
RETURNS DATETIME
AS
BEGIN
  RETURN
  (
   SELECT FirstSat = dates.dt
   FROM
     (
       VALUES

Here is some SQL which does this, on the assumption that the value with the highest percentage split is the one to be 'corrected'.

DECLARE @SplitPc TABLE (SplitPercentage DECIMAL(18,...

In this instance, which results would you deem as 'right'? I'm assuming that you want want of those results to round down by 0.01, but which one and what is...

I advise you to check the All Executions report (assuming your package is deployed to SSISDB) to work out the running times for the individual components of the package, in...

Thanks for posting back & glad you got it working.

Select from table
where Steel > 0 and Wood > 0
But I'm guessing your question is more complex than that?