• When using that example it produced an error

    IN

    (

    SELECT ConfiguredValue

    FROM

    dbo.table1(@CompanyID, ',')

    )

    Parameters supplied for object 'dbo.table1' which is not a function. If the parameters are intended as a table hint, a WITH keyword is required.