new time
19/10/2019 2:58:10 AM
9/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, 580, 580, '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, 50, 50, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1386', 10.5, 9.5, 319, 319, '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, 109, '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, 1875, 1875, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1735BK', 22, 20.5, 351, 346, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1735CL', 22, 20.5, 79, 79, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1750', 28, 26, 23, 0, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1751', 23, 21.5, 211, 211, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1780', 22, 20, 490, 490, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1782', 24, 22, 103, 83, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '180', 2.6, 2.4, 632, 632, '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, 715, 715, '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, 113, 113, '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, 1453, 1453, '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, 154, 154, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '3640BK', 15.5, 14.5, 348, 348, '1 - 99', '100+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4027BK', 8, 7.5, 342, 342, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4030BK', 6, 5.5, 7, 7, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4030RD', 6, 5.5, 302, 302, '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, 208, '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, 228, 228, '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, 170, 170, '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, 1716, 1692, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4070BOX', 2, 2, 343, 343, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4070SL', 13, 12, 769, 769, '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, 511, 487, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4074SL', 16, 15, 328, 304, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4075BK', 14.5, 13.5, 513, 513, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4075OR', 14.5, 13.5, 286, 286, '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, 586, 586, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4089BK', 16.5, 15.5, 570, 470, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4089WH', 16.5, 15.5, 572, 572, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4091BK', 34, 32, 439, 390, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099BK/CO', 15, 13, 1716, 1692, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099BK/RD', 15, 13, 1716, 1692, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099BK/PK', 15, 13, 1716, 1692, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099BK/OR', 15, 13, 1716, 1692, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099BK/WH', 15, 13, 1716, 1692, '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, 769, 769, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099SL/CO', 15, 13, 769, 769, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099SL/RD', 15, 13, 769, 769, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099SL/PK', 15, 13, 769, 769, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099SL/OR', 15, 13, 769, 769, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099SL/BK', 15, 13, 769, 769, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4190BL', 7, 6.5, 107, 107, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4190RD', 7, 6.5, 9, 9, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4192SM', 4.5, 4, 359, 359, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4193WH', 4.8, 4.3, 332, 332, '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, 645, 645, '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, 378, 68, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4247', 49, 47, 206, 206, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '425', 9.5, 8.5, 151, 151, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '426', 17, 16, 144, 144, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4260', 25, 23, 22, 22, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4262BL', 14.5, 13.5, 301, 301, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4262GR', 14.5, 13.5, 292, 292, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4262RD', 14.5, 13.5, 217, 217, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4263', 47, 45, 35, 35, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '427', 20, 19, 737, 737, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4322', 24, 22, 550, 549, '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, 574, 574, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '500', 26, 24, 211, 211, '1 - 99', '100+', 'AL'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5047BK', 9.5, 8.5, 318, 318, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5047BL', 9.5, 8.5, 23, 23, '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, 388, 388, '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, 71, 11, '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, 472, 472, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5158BL', 10, 9, 799, 799, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5158RD', 10, 9, 767, 767, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5165', 20, 18.5, 174, 174, '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, 155, 155, '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, 1044, 1004, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5262SL', 15.5, 14.5, 641, 617, '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, 239, 239, '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, 397, 397, '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, 479, 479, '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, 97, 97, '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, 360, 360, '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, 1082, 1082, '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, 123, 123, '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, 554, 554, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '750GN', 16, 15, 238, 238, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '750RD', 16, 15, 246, 226, '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, 400, 400, '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, 141, 141, '1 - 99', '100+', 'D'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7710', 14, 13, 69, 69, '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, 55, 55, '1 - 99', '100+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7815', 17, 16, 364, 220, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7854', 18, 17, 213, 213, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '796WD', 18, 17, 171, 171, '1 - 99', '100+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '8794', 20, 18, 171, 171, '1 - 99', '100+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '8814', 4.5, 4, 219, 219, '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, 281, 281, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '885BK', 28, 26, 279, 263, '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, 286, 286, '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, 326, 326, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9022', 14, 13, 0, 0, '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, 486, 486, '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, 27, 27, '1 - 99', '100+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9082', 2.5, 2.3, 786, 786, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9083', 23, 21, 161, 161, '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, 113, 113, '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, 449, 449, '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, 327, 327, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9161B', 5, 4.5, 188, 188, '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, 2, 2, '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, -1, 0, '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, 349, 349, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9189BK', 9.5, 8.5, 126, 126, '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, 333, 333, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'AZ1006', 24.5, 23, 66, 66, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'AZ1007', 36, 34, 189, 189, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'BSBB', 25, 23, 307, 295, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'CB1001', 13, 12, 197, 197, '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, 196, 196, '1 - 99', '100+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'CB1008', 64, 61, 48, 48, '1 - 99', '100+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'CB1009', 20, 18.5, 164, 104, '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, 209, 209, '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, 64, 64, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EL003', 62, 58, 105, 68, '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, 101, 101, '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, 262, 262, '1 - 99', '100+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EV1007', 26, 24, 265, 265, '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, 494, 494, '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, 2556, 2556, '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, 612, 612, '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, 449, 409, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1011', 14.5, 13.5, 101, 101, '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 'TK1016BL', 25, 23, 318, 298, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1018BK', 15.5, 14.5, 352, 352, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1020', 27, 25, 144, 144, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1022', 22.5, 21.5, 168, 168, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1028BK', 39, 36, 221, 221, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1034WD', 17.5, 16.5, 398, 378, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1035GY', 29, 27, 0, 0, '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, 154, 154, '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+', ' '