Update field as the same as field in where clause

Asked Oct 05 '15 at 04:49

Active Oct 05 '15 at 05:03

Viewed 53 times

I have a table

TICKET_ID   ASSIGN          TERM           ASSIGN_DATE          ASSIGN_MEMO OFFICER
5988085     ASSIGN-5        S1IIPF381   2015-09-01 08:28:04.000 NULL        NULL
5988085     RESOLVED-CLOSED S1IIPF381   2015-09-01 05:38:46.000 NULL        NULL
5988085     RESOLVED-CLOSED S1IIPF381   2015-09-01 08:28:04.000 NULL        NULL

with an update clause

UPDATE PROBLEM
  SET assign = 'ASSIGN-2',
      ASSIGN_MEMO = '12345'
  WHERE assign_date ='2015-09-01 08:28:04.000'
    AND ticket_id = '5988085'
    AND assign = 'ASSIGN-5';

I need to update where ASSIGN as the same as ASSIGN in where clause. Is it possible?

Expected output

TICKET_ID   ASSIGN          TERM           ASSIGN_DATE          ASSIGN_MEMO OFFICER
5988085     ASSIGN-2        S1IIPF381   2015-09-01 08:28:04.000 12345       NULL
5988085     RESOLVED-CLOSED S1IIPF381   2015-09-01 05:38:46.000 NULL        NULL
5988085     RESOLVED-CLOSED S1IIPF381   2015-09-01 08:28:04.000 NULL        NULL

edited Oct 05 '15 at 04:59

asked Oct 05 '15 at 04:49

Touchy Vivace

please show expected output.. – Dhaval Oct 05 '15 at 04:53
sorry but, Is update clause have an output ? – Touchy Vivace Oct 05 '15 at 04:55
1

i mean output after update ..@touchy – Dhaval Oct 05 '15 at 04:57
2

The above update query can update the table. – Ullas Oct 05 '15 at 05:02
Question is not clear – Ravi Oct 05 '15 at 05:03
maybe my code in asp.net /vb.net was wrong thanks to you all – Touchy Vivace Oct 05 '15 at 05:04
2

I think you wrote perfect query for your desire output... – Dhaval Oct 05 '15 at 05:04
Question seems to answer itself... It is possible, and your query looks correct. – Michael Petito Oct 05 '15 at 05:04

Update field as the same as field in where clause

0 Answers0