Viewing 2 posts - 1 through 2 (of 2 total)
Thanks for pointing out the problems with Microsofts built-in stored procedures.
If the OPENROWSET can handle this, that is great.
In Excel I'm using table-valued functions and do not specify "Table"...
October 29, 2009 at 9:12 am
I agree, the code for using OPENROWSET is very interesting.
But since the stored procedure has to return a result set, what is the advantage over using a table-valued function?
October 29, 2009 at 2:47 am