• It does not even allow an insert into a temp table. The clr returns a single value, thus:

    CREATE TABLE #Temp (

    tValue NUMERIC(18,4))

    INSERT INTO #Temp

    SELECT fncFormula(5, 2014, 6, 28)

    or

    SELECT fncFormula(5, 2014, 6, 28)

    INTO #Temp

    Both fail because it inserts a zero value, but "SELECT fncFormula(5, 2014, 6, 28)" returns the correct value.

    5ilverFox
    Consulting DBA / Developer
    South Africa