Hi there,
I have a shop with an e-procurement site that allows me to update a
price list by downloading a CSV file, making the changes, and then
uploading it back into there system.

The CSV file has the following headings:

@UKID - there unique ID for each products
Item Name - the name of the item
Part NO - our unique ID for each product
Price - the price for the product

I have an SQL view that shows our unique ID (Part NO) and the price.

How can I merge the CSV and the SQL view? Our system does not have the
@UKID code, but I don't think it needs it if I can easily merge the 2
together.

Any comments, ideas and criticisms are welcome.

Cheers,

Steve