Viewing 2 posts - 1 through 2 (of 2 total)
Yes, Tom,
Thanks for pointing out the problems with Microsofts built-in stored procedures.
If the OPENROWSET can handle this, that is great.
BTW:
In Excel I'm using table-valued functions and do not specify "Table"...
October 29, 2009 at 9:12 am
#1072525
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
#1072287