time changed 15
3/8/2020 10:55:59 PM
9/5/2019 12:47:06 PM9/5/2019 12: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, 309, 309, '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+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1385', 3, 2.7, 38, 38, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1386', 10.5, 9.5, 304, 304, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1393', 5.5, 5, 174, 174, '1 - 499', '500+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1402', 31, 29, 96, 96, '1 - 99', '100+', 'D'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1450', 8.5, 7.5, 282, 282, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1614', 8.5, 8, 251, 251, '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+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1705', 0.7, 0.5, 1873, 1873, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1735BK', 22, 20.5, 334, 329, '1 - 99', '100+', 'POA'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1735CL', 22, 20.5, 69, 69, '1 - 99', '100+', 'POA'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1751', 23, 21.5, 188, 188, '1 - 99', '100+', 'POA'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1780', 22, 20, 322, 322, '1 - 99', '100+', 'POA'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '1782', 24, 22, 31, 31, '1 - 99', '100+', 'POA'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '180', 2.6, 2.4, 630, 630, '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, 690, 690, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '207BL', 4.9, 4.7, 225, 225, '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, 130, 130, '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+', 'POA'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '2451', 1.1, 0.95, 1495, 1414, '1 - 499', '500+', 'POA'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '2452', 1.1, 0.95, 120, 120, '1 - 499', '500+', 'POA'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '2453', 1.1, 0.95, 3640, 3640, '1 - 499', '500+', 'POA'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '2454', 1.1, 0.95, 366, 366, '1 - 499', '500+', 'POA'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '2455', 1.1, 0.95, 3344, 3344, '1 - 499', '500+', 'POA'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '2RING', 3, 3, 112, 112, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '3640BK', 15.5, 14.5, 262, 262, '1 - 99', '100+', 'D'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4027BK', 8, 7.5, 340, 340, '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, 275, 275, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4030WH', 6, 5.5, 68, 68, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4035BK', 4.3, 3.8, 87, 87, '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, 168, 168, '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, 56, 56, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4039RD', 5.5, 5, 257, 257, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4043CL', 6.5, 6, 60, 60, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4046CL', 5.5, 5, 336, 336, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4061BK', 8, 7, 420, 420, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4067BL', 5.5, 5, 322, 322, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4067OR', 5.5, 5, 226, 226, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4067RD', 5.5, 5, 417, 417, '1 - 499', '500+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4067WH', 5.5, 5, 164, 164, '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, 1227, 1227, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4070BOX', 2, 2, 345, 345, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4070SL', 13, 12, 1048, 1048, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4070WH', 13, 12, 776, 776, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4074BK', 16, 15, 479, 479, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4074SL', 16, 15, 253, 253, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4075BK', 14.5, 13.5, 805, 805, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4075OR', 14.5, 13.5, 229, 229, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4081BK', 7, 6, 788, 788, '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, 566, 566, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4089WH', 16.5, 15.5, 570, 570, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4091BK', 34, 32, 328, 328, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099BK/CO', 15, 14, 1227, 1227, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099BK/RD', 15, 14, 1227, 1227, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099BK/PK', 15, 14, 1227, 1227, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099BK/OR', 15, 14, 1227, 1227, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099BK/WH', 15, 14, 1227, 1227, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099WH/CO', 15, 14, 776, 776, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099WH/RD', 15, 14, 776, 776, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099WH/PK', 15, 14, 776, 776, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099WH/OR', 15, 14, 776, 776, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099WH/BK', 15, 14, 776, 776, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099SL/WH', 15, 14, 1048, 1048, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099SL/CO', 15, 14, 1048, 1048, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099SL/RD', 15, 14, 1048, 1048, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099SL/PK', 15, 14, 1048, 1048, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099SL/OR', 15, 14, 1048, 1048, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4099SL/BK', 15, 14, 1048, 1048, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4190BL', 0, 0, 0, 0, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4190RD', 0, 0, 0, 0, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4192SM', 4.5, 4, 353, 353, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4193WH', 4.8, 4.3, 326, 326, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4196BL', 6.5, 6, 617, 617, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4196CL', 6.5, 6, 127, 127, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4199', 7.5, 7, 176, 176, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4226BK', 12, 11, 315, 315, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4247', 49, 47, 189, 189, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '425', 9.5, 8.5, 101, 101, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '426', 17, 16, 31, 31, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4260', 25, 23, 1, 1, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4262BL', 14.5, 13.5, 199, 199, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4262GR', 14.5, 13.5, 230, 230, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4262RD', 14.5, 13.5, 207, 207, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4263', 47, 45, 34, 34, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '427', 20, 19, 393, 393, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '4322', 24, 22, 535, 535, '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, 191, 191, '1 - 99', '100+', 'AL'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5047BK', 9.5, 8.5, 290, 290, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5047BL', 9.5, 8.5, 0, 0, '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, 42, 42, '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, 15, 15, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5100BK', 5.5, 5, 194, 194, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5123G', 15.5, 14.5, 232, 232, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5127', 8.5, 7.5, 59, 59, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5130BK', 9, 8, -1, 0, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5131BK', 6.5, 6, 163, 163, '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, 201, 201, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5138GN', 7, 6.5, 0, 0, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5139GR', 7, 6.5, 406, 406, '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, 143, 143, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5145', 9, 8, 222, 222, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5147BK', 7, 6, 12, 12, '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, 458, 458, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5158BL', 10, 9, 296, 296, '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, 168, 168, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5170LM', 15, 14, 243, 243, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5170RY', 15, 14, 55, 55, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5170WH', 15, 14, 182, 182, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '520', 15.5, 14.5, 4, 4, '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, 2121, 2121, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '5262SL', 15.5, 14.5, 562, 562, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '530', 18, 17, 29, 9, '1 - 99', '100+', 'D'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '572', 25, 23, 235, 235, '1 - 99', '100+', 'D'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '574', 37, 35, 216, 216, '1 - 99', '100+', 'D'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '611', 5, 4.5, 73, 73, '1 - 499', '500+', 'AP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '629BK', 7, 6.5, 235, 235, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '629S', 7, 6.5, 223, 223, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '630', 8, 7, 40, 40, '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, 274, 274, '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, 444, 444, '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, 157, 157, '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, 153, 153, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '675', 6.5, 6, 256, 256, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '677', 5.5, 4.5, 458, 458, '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, 0, 0, '1 - 499', '500+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '687', 10, 9, 402, 402, '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, 89, 89, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '691', 10, 9, 212, 212, '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, 343, 343, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '701S', 5.5, 5, 807, 807, '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, 170, 170, '1 - 99', '100+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '720BK', 8.5, 7.5, 1155, 1155, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '720NY', 8.5, 7.5, 0, 0, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '726', 0.9, 0.9, 10, 10, '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, 511, 511, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '750GN', 16, 15, 227, 227, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '750RD', 16, 15, 188, 188, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7691BK', 35, 33, 54, 54, '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, 373, 361, '1 - 99', '100+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7707WH', 15, 14, 101, 101, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '771', 30, 28.5, 133, 133, '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, 175, 175, '1 - 99', '100+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '772', 4.5, 4, 300, 300, '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, 488, 488, '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+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7770BK', 26, 24, 49, 49, '1 - 99', '100+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7815', 17, 16, 148, 148, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '7854', 18, 17, 68, 68, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '796WD', 18, 17, 153, 153, '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, 216, 216, '1 - 499', '500+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '8820', 0, 0, 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, 85, 85, '1 - 99', '100+', 'C'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '884BK', 42, 38, 258, 258, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '885BK', 28, 26, 233, 217, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '886BK', 45, 42, 0, 0, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '8904', 10, 9, 97, 97, '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+', 'D'
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, 358, 358, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9012', 24.5, 22.5, 175, 175, '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, 635, 635, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9022', 14, 13, 13, 13, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9028', 8.5, 7.5, 253, 253, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9035', 5, 4.5, 289, 289, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9037', 19, 17, 169, 169, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9057', 28, 26, 476, 476, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9068', 0, 0, 0, 0, '1 - 99', '100+', 'CP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9078', 17, 16, 189, 189, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9082', 2.5, 2.3, 455, 455, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9083', 23, 21, 118, 118, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9089', 20, 18, 263, 263, '1 - 99', '100+', 'POA'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9090', 14, 13, 302, 302, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9103', 13, 12, 76, 76, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9105', 16, 15, 124, 124, '1 - 99', '100+', 'POA'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9111', 20, 19, 78, 78, '1 - 99', '100+', 'POA'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9113', 4.5, 4, 136, 136, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9115', 7, 6.5, 1216, 1216, '1 - 499', '500+', 'DP'
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, 113, 113, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9135BK', 6.4, 6, 166, 166, '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+', 'DP'
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, 0, 0, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9161G', 5, 4.5, 64, 64, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9161P', 5, 4.5, 355, 355, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9163', 16.5, 15, 301, 301, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9164', 4.5, 4, 247, 247, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9165', 12, 11, 173, 173, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9173', 15.5, 14.5, 326, 326, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9174', 9.5, 8.5, 242, 242, '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, 337, 337, '1 - 99', '100+', 'EP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9189BK', 9.5, 8.5, 85, 85, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9194BK', 8.5, 7.5, 718, 718, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '9198BK', 7.9, 7.4, 550, 451, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT '972', 12.5, 11.5, 368, 368, '1 - 99', '100+', 'DP'
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, 20, 20, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'AZ1007', 36, 34, 178, 178, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'BSBB', 25, 23, 91, 91, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'CB1001', 13, 12, 195, 195, '1 - 99', '100+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'CB1002', 14, 13, 101, 101, '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, 1, 1, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'CB1008', 64, 61, 29, 29, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'CB1009', 20, 18.5, 143, 143, '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, 631, 631, '1 - 499', '500+', 'B'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EL001', 19.5, 18.5, 249, 249, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EL002', 105, 95, 51, 51, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EL003', 62, 58, 74, 57, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EL005', 5, 4.5, 357, 357, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EL006', 18, 17, 178, 178, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EL007', 5, 4.5, 438, 357, '1 - 499', '500+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EL013', 66, 62, 71, 71, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'EL017', 31, 29, 192, 192, '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, 71, 71, '1 - 99', '100+', 'BP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1001BL', 4.95, 4.65, 252, 252, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1001GN', 4.95, 4.65, 454, 454, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1001GR', 4.95, 4.65, 659, 659, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1001OR', 4.95, 4.65, 273, 273, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1001RD', 4.95, 4.65, 524, 524, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1003BK', 5.75, 5.45, 1932, 1932, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1003BL', 5.75, 5.45, 613, 613, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1003PP', 5.75, 5.45, 424, 424, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1003RD', 5.75, 5.45, 508, 508, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1006BK', 7.5, 7, 725, 725, '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', 4.95, 4.65, 537, 537, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1009GR', 4.95, 4.65, 738, 738, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1009RD', 4.95, 4.65, 564, 564, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'JB1021BK', 6.4, 6, 789, 789, '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, 84, 84, '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, 114, 114, '1 - 99', '100+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'LUX8936', 13, 12, 314, 314, '1 - 99', '100+', 'A'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'MM010', 5, 4.5, 1062, 1062, '1 - 499', '500+', 'DP'
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, 769, 769, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'NT-001BK', 0, 0, 0, 0, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'NT-001WH', 0, 0, 0, 0, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'NT-002BK', 0, 0, 0, 0, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'NT-002WH', 0, 0, 0, 0, '1 - 499', '500+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1001', 18.5, 17.5, 114, 114, '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, 58, 58, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1013', 27, 25, 265, 265, '1 - 99', '100+', 'D'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1016BK', 25, 23, 114, 114, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1018BK', 15.5, 14.5, 213, 213, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1020', 27, 25, 98, 98, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1022', 22.5, 21.5, 1, 1, '1 - 99', '100+', 'F'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1028BK', 39, 36, 211, 211, '1 - 99', '100+', ' '
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'TK1034WD', 17.5, 16.5, 246, 246, '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, 308, 308, '1 - 499', '500+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'ZM1001', 24, 22, 151, 151, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'ZM1002', 28, 26, 541, 541, '1 - 99', '100+', 'DP'
INSERT INTO tblNZStock(sItemNumber, fPrice1, fPrice2, iQtyInStock, iStocktoDisplay, sQuantityBreak1, sQuantityBreak2, sDecPriceBracket) SELECT 'ZM1010', 46, 44, 54, 41, '1 - 99', '100+', ' '