SQL Server table-valued function Parameters were not supplied for the function-

Question

I keep getting the error : "Parameters were not supplied" for a very simple table-valued function. I cannot figure out what is the issue. I narrowed the function down to :

create FUNCTION udf_XX_OddFCST()
    RETURNS @output TABLE (
        articlecode nvarchar(50)
    )
AS
BEGIN
    insert into @output(articlecode) values ('abc');
    RETURN
END

So I get the error when executing

select * from udf_XX_OddFCST

Any help would be greatly appreciated.

kind regards

Answer 1

you need to use parentheses in your function call :

SELECT * FROM udf_XX_OddFCST()

however as it has been mentioned in the comments, it would be more simpler and more efficient using iTVF:

CREATE FUNCTION udf_XX_OddFCST()
RETURNS TABLE
AS
    RETURN (select 'abc' as articlecode)

SELECT * FROM udf_XX_OddFCST()