Post reply

How to insert result from dynamic openquery into an existing table?

  • September 25, 2014 at 2:45 pm

    #311209

    How can I insert the result of below dynamic openquery into an existing table

    DECLARE @TSQL varchar(8000), @VAR char(2)

    SELECT @VAR = 'CA'

    SELECT @TSQL = 'SELECT * FROM OPENQUERY(MyLinkedServer,''SELECT * FROM pubs.dbo.authors WHERE state = ''''' + @VAR + ''''''')'

    EXEC (@TSQL)

    I tried Insert into but didn't work.

    INSERT INTO TableA

    SELECT *

    FROM (EXEC (@TSQL))

  • September 25, 2014 at 2:51 pm

    #1748318

    sql84 (9/25/2014)

    How can I insert the result of below dynamic openquery into an existing table

    DECLARE @TSQL varchar(8000), @VAR char(2)

    SELECT @VAR = 'CA'

    SELECT @TSQL = 'SELECT * FROM OPENQUERY(MyLinkedServer,''SELECT * FROM pubs.dbo.authors WHERE state = ''''' + @VAR + ''''''')'

    EXEC (@TSQL)

    I tried Insert into but didn't work.

    INSERT INTO TableA

    SELECT *

    FROM (EXEC (@TSQL))

    Insert Into Table

    Execute(@Tsql)

  • September 25, 2014 at 3:01 pm

    #1748323

    Awesome.. Thanks!

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

You must be logged in to reply to this topic. Login to reply