Hi All,
I have 2 tables(A and B) with following columns:
ID
Ticket Number (Primary Key)
Type of Ticket
Priority
Actual Start
Actual Finish Date
Status
Hours
Worklog
AssignedTo
I want to copy data from table A to table B. While copying data if there is any existing ticket number then I need to update the record and if the record is new then i need append.
Please help me on how to write both append and update quiries in the same query.
Thanks
Ramesh Katta
I have 2 tables(A and B) with following columns:
ID
Ticket Number (Primary Key)
Type of Ticket
Priority
Actual Start
Actual Finish Date
Status
Hours
Worklog
AssignedTo
I want to copy data from table A to table B. While copying data if there is any existing ticket number then I need to update the record and if the record is new then i need append.
Please help me on how to write both append and update quiries in the same query.
Thanks
Ramesh Katta