Advanced Retail (UK) Ltd
Company Wiki

–Tables for barcode, prices live and product need to be update.

–Run following on barcode to see date time for barcode
SELECT TOP 100 * FROM BARCODE WHERE BARCODE = '@barcode'
ORDER BY DATE_TIME DESC

–Update Barcode, Price_live and Product tables with date parameter.

–Barcode
UPDATE BARCODE SET BARCODE = BARCODE WHERE DATE_TIME > '@Date'

–Product
UPDATE [dbo].[product] SET desc_long = desc_long
WHERE product IN (select product from barcode where DATE_TIME > '@Date')

–Prices_live
UPDATE [dbo].[prices_live] SET vat_code = vat_code
WHERE product IN (select product from barcode where DATE_TIME > '@Date')