Home Forums SQL Server 7,2000 T-SQL Creating view from stored procedure results RE: Creating view from stored procedure results

  • January 5, 2010 at 9:54 am

    #1099039

    Here it comes...

    SELECT TOP (100) PERCENT *

    FROM OPENROWSET('SQLOLEDB', 'Trusted_Connection=Yes;Server=(local);Database=Your_DB', 'exec usp_MySP)

    AS derivedtbl_1

    Enjoy!:-)


    Jacob Milter