Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: insert into...exec-- help

    I need to insert the results into a temp table and i recieve the "MSDTC on server 'servername' is unavailable error".

    declare @thestringall varchar(1000)
    set @thestringall = 'select statment here'

    insert into #temptable exec (@thestringall)

    Thanks
    Wooanaz

  2. #2
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393

    Re: insert into...exec-- help

    Try this :
    If your 'select statment here' is <Select Name From TablePerson>


    Select Name Into #TableTemp From TablePerson


    Don't forget to drop #TableTemp when finished using it

  3. #3
    Join Date
    Jan 2004
    Posts
    2
    that worked thanks for your help.



    -Wooanaz

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •