Procedure to create and insert warehouses

db_procedure_wh

CREATE PROCEDURE GenerateWarehouseTbl
AS
BEGIN

-- create warehouse table
CREATE TABLE IMQCDev.dbo.Warehouses ( id int IDENTITY(1,1) NOT NULL, name varchar(50) NOT NULL, siteId varchar(50) NOT NULL, PRIMARY KEY(id), UNIQUE(name, siteId) );

-- fetch warehouses from IMQCdev and insert into warehouses table
INSERT INTO IMQCDev.dbo.Warehouses (name, siteId) SELECT DISTINCT SUBSTRING(CONVERT(varchar(10), WhseLocID), 0, 3) as WhseName, SiteID as SiteId FROM IMQCDev.dbo.WhseLocDesc WHERE WhseLocID >= 10000 ORDER BY WhseName asc;

-- fetch warehouses from IMQCSitesdev and insert into warehouses table
INSERT INTO IMQCDev.dbo.Warehouses (name, siteId) SELECT DISTINCT SUBSTRING(CONVERT(varchar(10), WhseLocID), 0, 3) as WhseName, SiteID as SiteId FROM IMQCSitesDev.dbo.WhseLocDesc WHERE WhseLocID >= 10000 ORDER BY WhseName asc;

END

What's with the WhseLocID >= 10000 check?

WhseLocID columb has many invalid entries. According to Jon's bacecamp post only 5 digit entries are valid row entries