Wouildn't it be quicker to load the data into a temproary table using SQL Loader then write a SP to perform the test and insert?
Sometimes the Programmer Sometimes the DBA Mazz1
Forum Rules
Reply With Quote