Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Insert into ##Table from linked server

    INSERT INTO #temp

    SELECT * FROM OPENQUERY(RemoteServer, 'EXEC Database.Schema.StoredProcedure')

    I never heard of OpenQuery, so don't really know what the line above does yet 🙂

    I will look into it!

    Thank you

    September 24, 2009 at 9:07 am

    #1058088

  • RE: Insert into ##Table from linked server

    Hi,

    Thank you for the replies.

    I'm sorry, I didn't give enough details.

    Simple insert from Select works fine. Thing that doesn't work - is inserting from the result set...

    September 24, 2009 at 7:49 am

    #1058014

Viewing 2 posts - 1 through 2 (of 2 total)