MS SQL - Using Stored Procedure in Select of another Stored Procedure?
Posted on 2014-09-25
This is all I'm finding so far and it doesn't work, don't have permissions. This is much easier to do in Oracle.
Q. Is there a better way?
(SELECT * FROM OPENROWSET('SQLNCLI','Server=(local);Trusted_Connection=Yes;Database=Database1','EXEC Get_Roles(272389)')) as [Roles]