Advanced Retail (UK) Ltd
Company Wiki

CREATE TABLE #Data (code varchar(30), description varchar(50), quantity int, sky varchar(30), product int, current_location int, sky_location int) GO

– etc INSERT INTO #Data (code, description, quantity, sky) VALUES ('211469', 'Fiesta Purple Mouse Long Tail', 576,'SKYDD030102')

EXEC [traxs_Utility_#Data_CodeToProduct]

UPDATE #Data SET current_location = whs_location FROM #Data D INNER JOIN whs_loc_prod W ON W.product = D.product WHERE is_primary = 1

UPDATE #Data SET sky_location = whs_location FROM #Data D INNER JOIN whs_location W ON W.location COLLATE Latin1_General_CI_AS = D.sky COLLATE Latin1_General_CI_AS

– copy to second table SELECt * INTO #d FROM #Data

DROP TABLE #Data

– THIS ASSUMES NDS!

CREATE TABLE #Data (

[line_no] [smallint] NOT NULL IDENTITY(1, 1),
[whse_no] [smallint] NOT NULL ,
[whs_location] [int] NOT NULL ,
[product] [int] NOT NULL ,
[quantity] [decimal](11, 3) NOT NULL ,
[cost] [decimal](11, 4) NULL ,
[price] [decimal](13, 3) NULL ,
[vat_code] [tinyint] NULL ,
[barcode] [varchar] (20) NULL ,
[description] [varchar] (50) NULL ,
[guid_batch] [uniqueidentifier] NULL)

INSERT INTO #Data

([whse_no] ,
[whs_location],
[product],
[quantity])

SELECT

1 ,
current_location,
[product],
[quantity]*-1

FROM

#d

INSERT INTO #Data

([whse_no] ,
[whs_location],
[product],
[quantity])

SELECT

1 ,
sky_location,
[product],
[quantity]

FROM

#d

–SELECT D.*, W.location FROM #Data D INNER JOIN whs_location W ON W.whs_location = D.whs_location –SELECt * FROM whs_loc_prod WHERE product = 133082

UPDATE #Data SET barcode = V.barcode, description = V.description FROM

#Data D
	INNER JOIN vw_Product1 V ON V.product = D.product

EXEC traxs_Utility_MovementFrom#Data_InterLocMove

SELECT SUM(quantity) FROM movements WHERE doc_terminal_id = 2 AND doc_no = 210059 ORDER BY date_time DESC