time changed 15
21/11/2019 5:55:38 PM
9/5/2019 1:47:06 PM9/5/2019 1:47:06 PM
processing stock
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1143', 4, 3.7, 376, 376, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1372', 8, 7.5, 330, 330, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1377', 4, 3.7, 755, 755, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1385', 3, 2.7, 49, 49, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1386', 10.5, 9.5, 294, 294, '1 - 99', '100+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1393', 5.5, 5, 224, 224, '1 - 499', '500+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1402', 31, 29, 109, 89, '1 - 99', '100+', 'D'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1450', 8.5, 7.5, 382, 382, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1614', 8.5, 8, 253, 253, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1615', 10, 9, 67, 67, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1618', 9, 8, 214, 214, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1630', 6.5, 6, 366, 366, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1705', 0.7, 0.5, 1873, 1873, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1735BK', 22, 20.5, 351, 326, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1735CL', 22, 20.5, 80, 60, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1751', 23, 21.5, 210, 190, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1780', 22, 20, 449, 449, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1782', 24, 22, 32, 12, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '180', 2.6, 2.4, 631, 631, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '185BL', 1.6, 1.5, 125, 125, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '185T', 1.6, 1.5, 943, 943, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '191', 4, 3.8, 371, 371, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '199BK', 1, 0.9, 1757, 1757, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '199WH', 1, 0.9, 1261, 1261, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '203BK', 1.3, 1.2, 335, 335, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '203S', 1.3, 1.2, 902, 902, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '203WH', 1.3, 1.2, 175, 175, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '207BK', 4.9, 4.7, 450, 450, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '207BL', 4.9, 4.7, 245, 245, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '209S', 1.9, 1.7, 621, 621, '1 - 499', '500+', 'B'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '2245', 10, 9, 110, 110, '1 - 99', '100+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '2403', 3, 2.5, 131, 131, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '2405', 0.65, 0.6, 1474, 1474, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '2406', 0.55, 0.5, 1353, 1353, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '2450', 1.1, 0.95, 3882, 3882, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '2451', 1.1, 0.95, 1695, 1614, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '2452', 1.1, 0.95, 121, 121, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '2453', 1.1, 0.95, 3640, 3640, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '2454', 1.1, 0.95, 367, 367, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '2455', 1.1, 0.95, 3344, 3344, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '2RING', 3, 3, 138, 138, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '3640BK', 15.5, 14.5, 346, 346, '1 - 99', '100+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4027BK', 8, 7.5, 341, 341, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4030BK', 6, 5.5, -10, 0, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4030RD', 6, 5.5, 277, 277, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4030WH', 6, 5.5, 73, 73, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4035BK', 4.3, 3.8, 88, 88, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4035BL', 4.3, 3.8, 72, 72, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4037BK', 3.5, 3, 70, 70, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4037BL', 3.5, 3, 268, 268, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4037WH', 3.5, 3, 324, 324, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4039BK', 5.5, 5, 58, 58, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4039RD', 5.5, 5, 258, 258, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4043CL', 6.5, 6, 2, 2, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4046CL', 5.5, 5, 538, 538, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4061BK', 8, 7, 421, 421, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4067BL', 5.5, 5, 323, 323, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4067OR', 5.5, 5, 227, 227, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4067RD', 5.5, 5, 419, 419, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4067WH', 5.5, 5, 169, 169, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4069BK', 5.5, 5, 215, 215, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4070BK', 13, 12, 1541, 1541, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4070BOX', 2, 2, 393, 393, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4070SL', 13, 12, 745, 745, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4070WH', 13, 12, 780, 780, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4074BK', 16, 15, 487, 467, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4074SL', 16, 15, 284, 284, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4075BK', 14.5, 13.5, 29, 0, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4075OR', 14.5, 13.5, 234, 214, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4081BK', 7, 6, 789, 789, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4081SL', 7, 6, 790, 790, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4082BK', 8, 7, 555, 555, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4089BK', 16.5, 15.5, 570, 570, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4089WH', 16.5, 15.5, 571, 571, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4091BK', 34, 32, 338, 338, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099BK/CO', 15, 13, 1541, 1541, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099BK/RD', 15, 13, 1541, 1541, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099BK/PK', 15, 13, 1541, 1541, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099BK/OR', 15, 13, 1541, 1541, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099BK/WH', 15, 13, 1541, 1541, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099WH/CO', 15, 13, 780, 780, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099WH/RD', 15, 13, 780, 780, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099WH/PK', 15, 13, 780, 780, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099WH/OR', 15, 13, 780, 780, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099WH/BK', 15, 13, 780, 780, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099SL/WH', 15, 13, 745, 745, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099SL/CO', 15, 13, 745, 745, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099SL/RD', 15, 13, 745, 745, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099SL/PK', 15, 13, 745, 745, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099SL/OR', 15, 13, 745, 745, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099SL/BK', 15, 13, 745, 745, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4190BL', 7, 6.5, 2, 2, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4190RD', 7, 6.5, 8, 8, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4192SM', 4.5, 4, 358, 358, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4193WH', 4.8, 4.3, 330, 330, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4196BL', 6.5, 6, 635, 635, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4196CL', 6.5, 6, 445, 445, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4199', 7.5, 7, 181, 181, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4226BK', 12, 11, 368, 368, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4247', 49, 47, 203, 183, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '425', 9.5, 8.5, 100, 100, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '426', 17, 16, 84, 84, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4260', 25, 23, 18, 0, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4262BL', 14.5, 13.5, 251, 231, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4262GR', 14.5, 13.5, 292, 272, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4262RD', 14.5, 13.5, 207, 187, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4263', 47, 45, 35, 15, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '427', 20, 19, 717, 717, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4322', 24, 22, 462, 442, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4986BK', 6.5, 6, 573, 573, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4986CL', 6.5, 6, 573, 573, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '500', 26, 24, 210, 210, '1 - 99', '100+', 'AL'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5047BK', 9.5, 8.5, 315, 295, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5047BL', 9.5, 8.5, 23, 3, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5052', 10, 9, 275, 275, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5056BL', 6.5, 6, 43, 43, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5056RD', 6.5, 6, 392, 392, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5087BL', 9.5, 8.5, 16, 16, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5100BK', 5.5, 5, 294, 294, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5123G', 15.5, 14.5, 386, 386, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5127', 8.5, 7.5, 60, 60, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5130BK', 9, 8, 1, 1, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5131BK', 6.5, 6, 375, 375, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5138BK', 7, 6.5, 6, 6, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5138BL', 7, 6.5, 202, 202, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5138GN', 7, 6.5, -6, 0, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5139GR', 7, 6.5, 405, 405, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5142BL', 10, 9, 0, 0, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5142G', 10, 9, 147, 147, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5142RD', 10, 9, 22, 22, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5143', 18.5, 17.5, 168, 168, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5145', 9, 8, 223, 223, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5147BK', 7, 6, 258, 258, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5149BK', 6, 5.5, 432, 432, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5153BL', 5.5, 5, 291, 291, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5153GR', 5.5, 5, 812, 812, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5153RD', 5.5, 5, 513, 513, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5158BK', 10, 9, 470, 470, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5158BL', 10, 9, 296, 276, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5158RD', 10, 9, 767, 747, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5165', 20, 18.5, 172, 172, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5170LM', 15, 14, 253, 253, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5170RY', 15, 14, 154, 54, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5170WH', 15, 14, 249, 249, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '520', 15.5, 14.5, 57, 57, '1 - 99', '100+', 'D'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '525', 14.5, 13.5, 180, 180, '1 - 99', '100+', 'D'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5262BK', 15.5, 14.5, 2218, 2202, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5262SL', 15.5, 14.5, 616, 616, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '530', 18, 17, 44, 44, '1 - 99', '100+', 'D'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '572', 25, 23, 60, 60, '1 - 99', '100+', 'D'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '574', 37, 35, 238, 238, '1 - 99', '100+', 'D'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '611', 5, 4.5, 74, 74, '1 - 499', '500+', 'AP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '629BK', 7, 6.5, 240, 240, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '629S', 7, 6.5, 323, 323, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '630', 8, 7, 52, 52, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '631', 9, 8, 57, 57, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '632', 11.5, 10.5, 144, 144, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '633', 10, 9, 99, 99, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '634', 9.5, 8.5, 265, 265, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '638', 10.5, 9.5, 11, 11, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '639', 10, 9, 275, 275, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '647', 9, 8, 358, 358, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '648', 9, 8, 99, 99, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '652', 8.5, 7.5, 445, 445, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '667', 8.5, 7.5, 319, 319, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '668', 8, 7, 158, 158, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '670', 9, 8, 392, 392, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '671', 9.5, 8.5, 472, 472, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '672', 9, 8, 154, 154, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '675', 6.5, 6, 283, 283, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '677', 5.5, 4.5, 459, 459, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '681', 7, 6.5, 318, 318, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '683', 5.5, 5, 202, 202, '1 - 499', '500+', 'B'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '684', 3, 2.8, 92, 92, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '687', 10, 9, 403, 403, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '688', 10, 9, 143, 143, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '689', 11, 9.5, 90, 90, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '691', 10, 9, 213, 213, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '692BL', 4.5, 4, 359, 359, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '695', 10.5, 9.5, 178, 178, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '696', 9.5, 8.5, 780, 780, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '697', 10.5, 9.5, 551, 551, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '698', 9.5, 8.5, 594, 594, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '700BK', 8.5, 7.5, 43, 43, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '701S', 5.5, 5, 982, 982, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '713', 4.5, 4, 96, 96, '1 - 499', '500+', 'B'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7199', 22, 20, 171, 171, '1 - 99', '100+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '720BK', 8.5, 7.5, 1158, 1158, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '720NY', 8.5, 7.5, 64, 64, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '726', 0.9, 0.9, 76, 76, '1 - 499', '500+', 'AP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '727', 3.5, 3, 288, 288, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '728BK', 6, 5.5, 257, 257, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '750BL', 16, 15, 551, 531, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '750GN', 16, 15, 237, 217, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '750RD', 16, 15, 226, 206, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7691BK', 35, 33, 115, 115, '1 - 99', '100+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7695BK', 28, 26, 107, 107, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7696BK', 14, 13, 374, 374, '1 - 99', '100+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7707WH', 15, 14, 102, 102, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '771', 30, 28.5, 134, 134, '1 - 99', '100+', 'D'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7710', 14, 13, 68, 68, '1 - 99', '100+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7712', 20, 18, 176, 176, '1 - 99', '100+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '772', 4.5, 4, 0, 0, '1 - 499', '500+', 'B'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7744BL', 4.2, 3.8, 90, 90, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7744RD', 4.2, 3.8, 490, 490, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '775', 4, 3.5, 183, 183, '1 - 499', '500+', 'B'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7770BK', 26, 24, 54, 54, '1 - 99', '100+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7815', 17, 16, 220, 220, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7854', 18, 17, 204, 184, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '796WD', 18, 17, 166, 146, '1 - 99', '100+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '8794', 20, 18, 170, 170, '1 - 99', '100+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '8814', 4.5, 4, 218, 218, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '8820', 11, 10, 0, 0, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '8829NSL', 8.5, 7.5, 54, 54, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '8839', 11, 10, 100, 100, '1 - 99', '100+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '884BK', 42, 38, 350, 350, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '885BK', 28, 26, 238, 222, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '886BK', 45, 42, 25, 25, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '8904', 10, 9, 207, 207, '1 - 499', '500+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '8943', 9.5, 8.5, 17, 17, '1 - 499', '500+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '8968', 19.5, 18, 107, 107, '1 - 99', '100+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '8982', 7, 6, 218, 218, '1 - 499', '500+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '8999', 4, 3.5, 452, 452, '1 - 499', '500+', 'B'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9009', 17.5, 16.5, 164, 164, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9010BK', 12, 11, 410, 410, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9012', 24.5, 22.5, 265, 245, '1 - 99', '100+', 'POA'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9013', 14, 13, 293, 293, '1 - 99', '100+', 'POA'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9018', 25, 23, 675, 675, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9022', 14, 13, 220, 220, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9028', 8.5, 7.5, 255, 255, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9035', 5, 4.5, 290, 290, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9037', 19, 17, 169, 169, '1 - 99', '100+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9057', 28, 26, 476, 476, '1 - 99', '100+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9068', 15, 14, 0, 0, '1 - 99', '100+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9078', 17, 16, 217, 217, '1 - 99', '100+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9082', 2.5, 2.3, 636, 10, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9083', 23, 21, 151, 151, '1 - 99', '100+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9089', 20, 18, 263, 263, '1 - 99', '100+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9090', 14, 13, 303, 303, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9103', 13, 12, 99, 99, '1 - 99', '100+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9105', 16, 15, 179, 179, '1 - 99', '100+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9111', 20, 19, 78, 78, '1 - 99', '100+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9113', 4.5, 4, 136, 136, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9115', 7, 6.5, 450, 450, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9117', 10, 9, 134, 134, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9118', 3.5, 3, 183, 183, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9135BK', 7, 6.5, 167, 167, '1 - 499', '500+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9138BK', 16, 15, 145, 145, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9139BK', 13, 12, 242, 242, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9141', 5, 4.5, 367, 367, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9152', 15, 14, 328, 328, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9161B', 5, 4.5, 132, 132, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9161G', 5, 4.5, 64, 64, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9161P', 5, 4.5, 355, 355, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9163', 16.5, 15, 302, 302, '1 - 99', '100+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9164', 4.5, 4, 247, 247, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9165', 12, 11, 193, 193, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9173', 15.5, 14.5, 252, 252, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9174', 9.5, 8.5, 392, 392, '1 - 499', '500+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9184BK', 14.5, 13.5, 206, 206, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9187', 34, 32, 348, 348, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9189BK', 9.5, 8.5, 125, 125, '1 - 99', '100+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9194BK', 8.5, 7.5, 719, 719, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9198BK', 7.9, 7.4, 802, 703, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '972', 12.5, 11.5, 370, 370, '1 - 99', '100+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9922', 12.5, 11.5, 297, 297, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'AZ1004', 7.5, 7, 303, 303, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'AZ1006', 24.5, 23, 64, 64, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'AZ1007', 36, 34, 187, 187, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'BSBB', 25, 23, 303, 271, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'CB1001', 13, 12, 196, 196, '1 - 99', '100+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'CB1002', 14, 13, 102, 102, '1 - 99', '100+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'CB1003', 11, 10, 93, 93, '1 - 99', '100+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'CB1004', 12, 11, 154, 154, '1 - 99', '100+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'CB1007', 28, 26, 94, 94, '1 - 99', '100+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'CB1008', 64, 61, 42, 42, '1 - 99', '100+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'CB1009', 20, 18.5, 151, 151, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'CB1010', 29, 27, 149, 149, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'CL1001', 28, 26, 252, 252, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'CL1002', 32, 30, 208, 208, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'DT2', 2.5, 2, 632, 632, '1 - 499', '500+', 'B'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EL001', 19.5, 18.5, 251, 251, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EL002', 105, 95, 60, 60, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EL003', 62, 58, 84, 67, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EL005', 5, 4.5, 358, 358, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EL006', 18, 17, 179, 179, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EL007', 5, 4.5, 439, 358, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EL013', 66, 62, 86, 86, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EL017', 31, 29, 194, 194, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EL022', 5, 4.5, 357, 357, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EV1006', 17.5, 16.5, 261, 261, '1 - 99', '100+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EV1007', 26, 24, 263, 263, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EV1008', 33, 31, 182, 182, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'FID1002', 49, 47, 35, 35, '1 - 99', '100+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'FID1009', 39, 37, 72, 72, '1 - 99', '100+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1001BL', 5.9, 5.6, 252, 252, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1001GN', 5.9, 5.6, 454, 454, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1001GR', 5.9, 5.6, 660, 660, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1001OR', 5.9, 5.6, 273, 273, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1001RD', 5.9, 5.6, 524, 524, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1003BK', 5.9, 5.6, 1353, 1353, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1003BL', 5.9, 5.6, 613, 613, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1003PP', 5.9, 5.6, 424, 424, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1003RD', 5.9, 5.6, 508, 508, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1006BK', 7.5, 7, 4, 4, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1006BL', 7.5, 7, 190, 190, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1006RD', 7.5, 7, 384, 384, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1009BL', 5.9, 5.6, 537, 537, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1009GR', 5.9, 5.6, 742, 742, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1009RD', 5.9, 5.6, 564, 564, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1021BK', 6.9, 6.5, 792, 792, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'LUX1001BK', 13, 12, 97, 97, '1 - 99', '100+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'LUX1002S', 13, 12, 124, 124, '1 - 99', '100+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'LUX1003', 9, 8, 1155, 1155, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'LUX8934', 11, 10, 115, 115, '1 - 99', '100+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'LUX8936', 13, 12, 317, 317, '1 - 99', '100+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'MM010', 5, 4.5, 1063, 1063, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'MM055', 7.5, 7, 261, 261, '1 - 499', '500+', 'D'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'MM1006', 9.5, 8.5, 770, 770, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'NT-001BK', 4.5, 4, 0, 0, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'NT-001WH', 4.5, 4, 0, 0, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'NT-002BK', 4, 3.5, 0, 0, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'NT-002WH', 4, 3.5, 0, 0, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1001', 18.5, 17.5, 59, 59, '1 - 99', '100+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1005', 14, 13, 409, 409, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1011', 14.5, 13.5, 100, 100, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1013', 27, 25, 266, 266, '1 - 99', '100+', 'D'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1016BK', 25, 23, 145, 145, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1018BK', 15.5, 14.5, 221, 221, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1020', 27, 25, 111, 111, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1022', 22.5, 21.5, 83, 83, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1028BK', 39, 36, 221, 201, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1034WD', 17.5, 16.5, 372, 252, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1035GY', 29, 27, 477, 477, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TZ1001', 18.5, 17.5, 246, 246, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TZ1002', 17, 16, 363, 363, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'UB1', 2.5, 2.3, 494, 494, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'ZM1001', 24, 22, 155, 155, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'ZM1002', 28, 26, 0, 0, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'ZM1010', 46, 44, 66, 53, '1 - 99', '100+', ' '