I want to insert new costcode values in to table only if the new value dose not exsist in costcode column already.
if it exsists so
the TranDate and amount will be updated for the exsisting cost code.
if costCode exsist then update tranDate and amount else insert new row with new valuse for each column.
CostCode TranDate Amount
04 31/01/2013 12:00:00 AM 262033.83
07 31/01/2013 12:00:00 AM 31579.87
01 31/01/2013 12:00:00 AM 980834.24
09 31/01/2013 12:00:00 AM 197237.28
I need help urgently.
please someone help me here.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)