I have a table with 14 columns. The first column is Part #. I need to insert a new line and add different data to the other 13 columns if the data in column 10 is different. 

For example:

```

Part #  Description Lead Time   Price 1 Price 2 Price 3 Min. Buy    Date    ATA
1693    SHORTY PLUG     045  $-      $-      $4.25  100 110612  STC
2617    DOME PLUG            045     $-      $-      $0.75   100    111912  CIS
2617    DOME PLUG            045     $-      $-      $0.50  100 91012   STC
2617    DOME PLUG            045     $-      $-      $0.50  100 91012   STD
2646    PLUG (BLACK 045  $-      $-      $6.75  100 91012   STC
2646    PLUG (BLACK)    045  $-      $-      $6.00  100 91012   STD

```

The key column is the "ATA" column. How would I add, say Part # 2646 which had an ATA Code of "CIS". The Part # is the only Column which will stay the same. I want to leave the other Rows in the table, just add another row with a Part # of 2646 with the rest of the data different.

I'm not very proficient in SQL, and have tried everything I can find on the Internet with no success. Thanks for your help.