Hi!
I have an inline table-valued function (with parameters) which if course returns a table.
I can use a query 'SELECT * FROM Myfunction(par1, par2)' which returns ALL records.
I can also use a query 'SELECT * FROM Myfunction(par1, par2) WHERE myfield=1', but I cannot use a query 'SELECT * FROM Myfunction(par1, par2) where myCalculatedResultfield=1'.
'myCalculatedResultfield' exists as fieldname in the result table, but cannot be selected.
There is no error but no result at all.
How do I use a prior calculated field of a function in a WHERE clause for selecting from a result table?
Thanks.
Michael
SQL server 2008 R2
I have an inline table-valued function (with parameters) which if course returns a table.
I can use a query 'SELECT * FROM Myfunction(par1, par2)' which returns ALL records.
I can also use a query 'SELECT * FROM Myfunction(par1, par2) WHERE myfield=1', but I cannot use a query 'SELECT * FROM Myfunction(par1, par2) where myCalculatedResultfield=1'.
'myCalculatedResultfield' exists as fieldname in the result table, but cannot be selected.
There is no error but no result at all.
How do I use a prior calculated field of a function in a WHERE clause for selecting from a result table?
Thanks.
Michael
SQL server 2008 R2