Post reply

Can you UPDATE a temp table?

  • April 8, 2004 at 10:42 am

    #163330

    Hello,

    SQL 7 w/SP2

    Can you update the values in a temp using UPDATE and values from another temp table? my code keeps bobmbing. any suggestion would be greatly appreciated.

    create table #jeff_MinFilesize (

     Col_1 varchar(50),

     col_2 int

    &nbsp

    ---> INSERT statement used her to populate #jeff_MinFilesize <which works>

    create table #jeff_combo (

     col_1 varchar(50),

     col_2 int,

     col_3 int )

    update #jeff_combo

    set col_1 = (select col_1 from #jeff_MinFilesize)

    select * from #jeff_combo

    ---> (0 row(s) affected)

    Many thanks. Jeff

  • April 8, 2004 at 11:44 am

    #502190

    Looks like you are attempting to update the #jeff_combo table before putting any data in it. Try changing the update #jeff_combo to insert #jeff_combo


    Shamless self promotion - read my blog http://sirsql.net

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

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