Hi

Pls. find the file. Where A222, a223, A940,.... is the name of the File followed by field name....

A222|ZS08          |0005      |H350        |GENERAL_REPAIR      |A              |28.02.2004|01.02.2004|0000352836     |000

A223|ZS16          |0005      |02            |03      |03         |20W50FOL080KLG     ...

Hi Phill,

Thanks for prompt reply... Actually Pls. find the the whole procedure... In which i am 1st import a text file. Then i have to Fetch the Table name from...

No Its Transaction i believe...... Just one changes ... MAX(HFC_Epay.dbo.Epay_Traction_Table.batch_num) instead of  MAX(batch_num)