Post reply

cannot update using temporary table

  • February 19, 2010 at 7:28 am

    #230190

    I have created a table A and trying to insert the data using temporary table .

    i.e pivoted the data from another table B into temporary table #Q and inserting data into table A using update statement .but, the problem is, it is not insertring any rows.i am getting the message 0 rows affected.but i can see the data in #q,i have also used right outer join but no use.

    here is structure of the tables and code (what i am trying to achieve)...

    Appreciate the help ....

  • February 19, 2010 at 7:39 am

    #1121842

    Are you trying to do an update or an insert? I'm seeing in your code for tablea that you have a lot of not null columns, so I assume that you either have a lot of data in tablea already and are trying to update, in which case your joins aren't resulting in matches, or you are trying to insert data into tablea using an update statement which also won't work. Can you clarify which you are trying to do?

    Tim Januario

  • February 19, 2010 at 7:55 am

    #1121852

    here is what i am trying to do ,intially i am creating a procedure and inserting the values as 0,0,0.and later updating using updation criteria.

  • February 19, 2010 at 8:47 am

    #1121897

    I got it ...

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

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