This call for a treat !!!

thanks, SeEa

In that case also teh above approach of grouping by should work !!!

thanks, SeEa

yup

thanks, SeEa

Is the error issued by the database??

thanks, SeEa

man this sql script is not work like this .... u should use the group by function to get that effect and any aggr functions select CODE, min(OID) from tableA group by CODE This should fetch you the result

thanks, SeEa

Try the sql authentication method and make sure that the username and the password supplied are correct..

thanks, SeEa

You can use the osql command to execute the sql commands from the batch fils.

thanks, SeEa