thanks for the replies

the problem is that probably i would have the same customer with a different cust_id.(by same i mean same last name, same fname....). For example

 when i will try...

got it from books on line

Retrieving and Writing XML Data

You can execute SQL queries to return results as XML rather than standard rowsets. These queries can...

thanks for the responses

i was thinking if there is a better approach to the whole thing,like creating a #table,inserting the values in that and do a final update in the...