scottklement.com

Found a solution using InLine SQL Function as follows: Create or Replace Function NONWORKHRS( facility VarChar(3) ,pmiBDate Date ,pmiEDate Date ) returns Decimal(7, 2) language sql specific NONWORKHRS not deterministic not fenced reads sql data returns null on null input Set Option DBGVIEW = *SOURCE...

Will preface this is my first time trying to create a UDF. I created the function. The function is getting executed from the SQL statement correctly. Then I realized the value I was calculating in the function needed a set of non-workday hours removed from the sum. I thought, why not use another SQL...