I’m uploading excel files to my server to import into my db. I need to delete duplicate combo primary key values from the temp table created. So far I have:
sc_exec_sql("select PARPRT_02, COMPRT_02, count()
group by PARPRT_02, COMPRT_02
having count() > 1
DELETE FROM Product_Structure_[PMdate] WHERE PARPRT_02 ");
but I am not grasping how to accomplish the finishing blow.