In MicroSoft Sql Server you can create Table-Valued
function, which returns as a result a resultset instead of a
discrete value.

When ever I try to create the DW based off of this function
I get 2 different errors depending on the version of PB.

Under PB9.02(connected via SQLCNI) I get "sqlstate = 42000
MicroSoft SQL Native Client
The request for procedure "FC_blah"failed because "Fc_blah"
is atable valued function object"


Under pb11.1 (connected via SQLCNI) I get "Requested result
set number 1 not found"

Usually I just wrap the function in a stored procedure , and
all is good.

My question is why isn't table-valued function allowed?