1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
|
INSERT INTO Location
(LocationID, SiteID, LocationName, LocationCode, Path, PathName, WhenUpdated, RecordStatus, ApplicationCode, Updated)
SELECT DISTINCT 'SHS'+ right('0000000000000' + ltrim(rtrim(SHS.StockLocationCode)),13),
@DefaultSite,
SHS.StockLocationName,
SHS.StockLocationCode,
'/' + rtrim('SHS'+ right('0000000000000' + ltrim(rtrim(SHS.StockLocationCode)),13)) + '/',
'/' + rtrim(SHS.StockLocationCode) + '/',
Getdate(),0, 0, 0
FROM Optim_Jobs.dbo.Catalog as SHS LEFT OUTER JOIN Location
ON 'SHS'+ right('0000000000000' + ltrim(rtrim(SHS.[StockLocationCode])),13) collate database_default = Location.LocationID collate database_default
WHERE Location.LocationID is null
AND SHS.StockLocationCode is not null
AND len(ltrim(rtrim(SHS.SupplierCode)))>0 |
Partager