Wow that's spot on!! That's amazing.

I certainly need to brush up on sql.

Thank you very much.

Cheers

Graham.

Sample data in csv:

TiffNotes:

URN,Date_Entered,Username,Note

93200548,20110122 14:03:04,websupport@netdocs.co.uk,check supplier

93200549,20110122 14:04:48,websupport@netdocs.co.uk,change values

93200550,20110122 14:05:06,websupport@netdocs.co.uk,check for duplicate

93200550,20110123 14:05:06,paul.timmerman@netdocs.co.uk,process

Sample data in csv:

TiffIndex:

URN,Supplier_Name,Supplier_No,Invoice_No,Invoice_Date,Invoice_Currency,Invoice_Type,Net_Value,VAT_Value,Gross_Value,Credit_No,Company_No,Doc_Id,UserId,Doc_Status,Page_No,Authoriser,Parked,Approved,tiffpath,media_no,date_imported

93200548,COVERGOLD LTD,C16,147214,20100930,GBP,INVOICE,700,122.5,822.5,,1,101500000095,,3,1,websupport@netdocs.co.uk,N,N,\1015\00000095.tif,1,20110322

93200549,COVERGOLD LTD,C16,147225,20100930,GBP,INVOICE,500,87.5,587.5,,1,101500000096,,3,1,websupport@netdocs.co.uk,N,N,\1015\00000096.tif,1,20110322

93200550,COVERGOLD LTD,C16,147196,20100930,GBP,INVOICE,138.66,24.27,162.93,,1,101500000097,,3,1,websupport@netdocs.co.uk,N,N,\1015\00000097.tif,1,20110322

93200550,COVERGOLD LTD,C16,147196,20100930,GBP,INVOICE,138.66,24.27,162.93,,1,101500000097,,3,2,websupport@netdocs.co.uk,N,N,\1015\00000098.tif,1,20110322

93200550,COVERGOLD LTD,C16,147196,20100930,GBP,INVOICE,138.66,24.27,162.93,,1,101500000097,,3,3,websupport@netdocs.co.uk,N,N,\1015\00000099.tif,1,20110322

93200550,COVERGOLD LTD,C16,147196,20100930,GBP,INVOICE,138.66,24.27,162.93,,1,101500000097,,3,4,websupport@netdocs.co.uk,N,N,\1015\00000100.tif,1,20110322

Table Definitions:

Tiffindex table

URN varchar(20)

Supplier_Namevarchar(50)

Supplier_Novarchar(20)

Invoice_Novarchar(20)

Invoice_Datevarchar(10)

Invoice_Currencyvarchar(10)

Invoice_Typevarchar(10)

Net_Valuedecimal(18, 2)

VAT_Valuedecimal(18, 2)

Gross_Valuedecimal(18, 2)

Credit_Novarchar(20)

Company_Novarchar(2)

Doc_Id ...