Need help with a recursive query - DDL Part 3

Prev: T-SQL to retrieve language pairs with a fallback to a default language when missing
Next: Alter table

From: Blasting Cap on 5 Mar 2010 17:39

---

INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008252 AS
Numeric(8, 0)), N'70857', N'', N'RW12HMH4 RW 12HM MAG_4 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008255 AS
Numeric(8, 0)), N'70861', N'', N'RW12HMH6 RW 12HM MAG_6 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008258 AS
Numeric(8, 0)), N'70867', N'', N'RW12B00 RW 12B_00 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008260 AS
Numeric(8, 0)), N'70869', N'', N'RW12B RW 12_BB 100_CA', N'AM001SS116',
N'', N'EA', N'', N'0', N'', N'US', N'DC', N'210010024000000012', N'',
N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008262 AS
Numeric(8, 0)), N'70871', N'', N'RW122 RW 12_2 100_CA', N'AM001SS116',
N'', N'EA', N'', N'0', N'', N'US', N'DC', N'210010024000000012', N'',
N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008264 AS
Numeric(8, 0)), N'70873', N'', N'RW124 RW 12_4 100_CA', N'AM001SS116',
N'', N'EA', N'', N'0', N'', N'US', N'DC', N'210010024000000012', N'',
N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008266 AS
Numeric(8, 0)), N'70875', N'', N'RW126 RW 12_6 100_CA', N'AM001SS116',
N'', N'EA', N'', N'0', N'', N'US', N'DC', N'210010024000000012', N'',
N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008280 AS
Numeric(8, 0)), N'70901', N'', N'RW12HMB RW 12H MAG_BB 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008281 AS
Numeric(8, 0)), N'70903', N'', N'RW12HM2 RW 12H MAG_2 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008283 AS
Numeric(8, 0)), N'70905', N'', N'RW12HM4 RW 12H MAG_4 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008285 AS
Numeric(8, 0)), N'70907', N'', N'RW12HM6 RW 12H MAG_6 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008290 AS
Numeric(8, 0)), N'70917', N'', N'RW12VT RW 12VT _ T 3_ 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008292 AS
Numeric(8, 0)), N'70919', N'', N'RW1235VT RW 1235VT _ T 3_1_2_ 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008294 AS
Numeric(8, 0)), N'70921', N'', N'RW1235M6 RW 1235 MAG_6 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008299 AS
Numeric(8, 0)), N'70929', N'', N'RW1235HM4 RW 1235H MAG_4 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008301 AS
Numeric(8, 0)), N'70931', N'', N'RW1235HM5 RW 1235H MAG_5 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008303 AS
Numeric(8, 0)), N'70933', N'', N'RW1235HM6 RW 1235H MAG_6 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008314 AS
Numeric(8, 0)), N'70949', N'', N'RW1235B RW 1235_BB 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008316 AS
Numeric(8, 0)), N'70951', N'', N'RW12352 RW 1235_2 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008317 AS
Numeric(8, 0)), N'70953', N'', N'RW12354 RW 1235_4 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012049 AS
Numeric(8, 0)), N'76670', N'', N'NM12S5 SP 12S NM_5 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012050 AS
Numeric(8, 0)), N'76672', N'', N'NM122 SP 12 NM_2 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012051 AS
Numeric(8, 0)), N'76674', N'', N'NM124 SP 12 NM_4 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012052 AS
Numeric(8, 0)), N'76676', N'', N'NM12S2 SP 12S NM_2 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012053 AS
Numeric(8, 0)), N'76678', N'', N'NM12S4 SP 12S NM_4 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012054 AS
Numeric(8, 0)), N'76680', N'', N'NM12HB SP 12H NM_BB 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012055 AS
Numeric(8, 0)), N'76682', N'', N'NM12H2 SP 12H NM_2 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012056 AS
Numeric(8, 0)), N'76684', N'', N'NM12H4 SP 12H NM_4 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012057 AS
Numeric(8, 0)), N'76685', N'', N'NM12H6 SP 12H NM_6 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012059 AS
Numeric(8, 0)), N'76688', N'', N'NT12S5 NT12S_5 100_CA', N'AM001SS109',
N'', N'EA', N'', N'0', N'', N'US', N'DC', N'210010020000000012', N'',
N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012060 AS
Numeric(8, 0)), N'76690', N'', N'NT12S4 NT12S_4 100_CA', N'AM001SS109',
N'', N'EA', N'', N'0', N'', N'US', N'DC', N'210010020000000012', N'',
N'', N'21', N'N', N'N', N'Y', N'H1')
GO
print 'Processed 200 total records'
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012062 AS
Numeric(8, 0)), N'76693', N'', N'NT12H4 NT 12H _ 4 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012063 AS
Numeric(8, 0)), N'76695', N'', N'NT12H5 NT 12H _ 5 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012064 AS
Numeric(8, 0)), N'76696', N'', N'MP10H46 MRP 10H MAG_4x6 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000010', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012065 AS
Numeric(8, 0)), N'76697', N'', N'NT12H6 NT 12H _ 6 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012066 AS
Numeric(8, 0)), N'76700', N'', N'RW12HM4 RW 12H MAG_4 5_BOX_100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012067 AS
Numeric(8, 0)), N'76702', N'', N'RW12HM6 RW 12H MAG_6 5_BOX_100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012069 AS
Numeric(8, 0)), N'76706', N'', N'RW1235M6 RW 1235 MAG_6 5_BOX_100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012070 AS
Numeric(8, 0)), N'76708', N'', N'NT12355 NT 12_5 3.5_ 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012071 AS
Numeric(8, 0)), N'76710', N'', N'NT12354 NT 12_4 3.5_ 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012072 AS
Numeric(8, 0)), N'76712', N'', N'NT12356 NT 12_6 3.5_ 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012076 AS
Numeric(8, 0)), N'76720', N'', N'76720 SP 12S MAG_2 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012077 AS
Numeric(8, 0)), N'76722', N'', N'76722 SP 12S MAG_4 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012078 AS
Numeric(8, 0)), N'76730', N'', N'NT20M5 NT 20M_5 100_CA', N'AM001SS109',
N'', N'EA', N'', N'0', N'', N'US', N'DC', N'210010020000000020', N'',
N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012079 AS
Numeric(8, 0)), N'76734', N'', N'76734 SP 12H MAG_BB 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012081 AS
Numeric(8, 0)), N'76742', N'', N'MP12SB4 MRP 12S MAG_BBx4 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012083 AS
Numeric(8, 0)), N'76744', N'', N'MP12S26 MRP 12S MAG_2x6 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012085 AS
Numeric(8, 0)), N'76746', N'', N'MP12S46 MRP 12S MAG_4x6 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012086 AS
Numeric(8, 0)), N'76747', N'', N'MP12S46 MRP 12S MAG_4x6 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012087 AS
Numeric(8, 0)), N'76750', N'', N'MP12HB4 MRP 12H MAG_BBx4 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012088 AS
Numeric(8, 0)), N'76752', N'', N'MP12H26 MRP 12H MAG_2x6 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012089 AS
Numeric(8, 0)), N'76753', N'', N'MP12H46 MRP 12H MAG_4x6 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012090 AS
Numeric(8, 0)), N'76754', N'', N'MP12H46 MRP 12H MAG_4x6 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012093 AS
Numeric(8, 0)), N'76757', N'', N'MP12S24 MRP 12S MAG_2x4 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012100 AS
Numeric(8, 0)), N'76767', N'', N'MP12H24 MRP 12H MAG 2x4 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012105 AS
Numeric(8, 0)), N'76772', N'', N'MP12XH MRP 12XH MAG 4x6 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012106 AS
Numeric(8, 0)), N'76773', N'', N'MP12XH46 MRP 12XH MAG 4x6 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012124 AS
Numeric(8, 0)), N'76808', N'', N'P10HM4_ PR 10H MAG_4 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000010', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012125 AS
Numeric(8, 0)), N'76809', N'', N'P10HM4 PR 10H MAG_4 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000010', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012126 AS
Numeric(8, 0)), N'76810', N'', N'P10HM6_ PR 10H MAG_6 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000010', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012127 AS
Numeric(8, 0)), N'76811', N'', N'P10HM6 PR 10H MAG_6 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000010', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012128 AS
Numeric(8, 0)), N'76812', N'', N'P12SM4_ PR 12S MAG_4 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012129 AS
Numeric(8, 0)), N'76813', N'', N'P12SM4 PR 12S MAG_4 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012130 AS
Numeric(8, 0)), N'76814', N'', N'P12SM5_ PR 12S MAG_5 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012131 AS
Numeric(8, 0)), N'76815', N'', N'P12SM5 PR 12S MAG_5 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012132 AS
Numeric(8, 0)), N'76816', N'', N'P12SM6_ PR 12S MAG_6 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012133 AS
Numeric(8, 0)), N'76817', N'', N'P12SM6 PR 12S MAG_6 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012137 AS
Numeric(8, 0)), N'76834', N'', N'P12XHM4_ PR 12XH MAG_4 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012138 AS
Numeric(8, 0)), N'76835', N'', N'P12XHM4 PR 12XH MAG_4 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012139 AS
Numeric(8, 0)), N'76836', N'', N'P12XHM5_ PR 12XH MAG_5 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012140 AS
Numeric(8, 0)), N'76837', N'', N'P12XHM5 PR 12XH MAG_5 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012141 AS
Numeric(8, 0)), N'76838', N'', N'P12XHM6_ PR 12XH MAG_6 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012142 AS
Numeric(8, 0)), N'76839', N'', N'P12XHM6 PR 12XH MAG_6 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012143 AS
Numeric(8, 0)), N'76846', N'', N'P1235M4_ PR 1235 MAG_4 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012144 AS
Numeric(8, 0)), N'76847', N'', N'P1235M4 PR 12 3.5_ MAG_4 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012145 AS
Numeric(8, 0)), N'76848', N'', N'P1235M6_ PR 1235 MAG_6 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012146 AS
Numeric(8, 0)), N'76849', N'', N'P1235M6 PR 12 3.5_ MAG_6 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012150 AS
Numeric(8, 0)), N'76860', N'', N'P20XHM6_ PR 20H MAG_6 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000020', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012151 AS
Numeric(8, 0)), N'76861', N'', N'P20XHM6 PR 20H MAG_6 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000020', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012181 AS
Numeric(8, 0)), N'76919', N'', N'Marshmallow COMP 12_30 PROBORE VT HG',
N'PFASG01Marshmallow', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'110010040000100012', N'', N'', N'11', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012185 AS
Numeric(8, 0)), N'76923', N'', N'Marshmallow COMP 12_30 PROBORE VT HG
ADJ COMB', N'PFASG01Marshmallow', N'', N'EA', N'', N'0', N'', N'US',
N'DC', N'110010040000100012', N'', N'', N'11', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012953 AS
Numeric(8, 0)), N'78003', N'', N'SP164 SP 16_4 250_CA', N'AM001SS107',
N'', N'EA', N'', N'0', N'', N'US', N'DC', N'210010010000000016', N'',
N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012955 AS
Numeric(8, 0)), N'78007', N'', N'SP166 SP 16_6 250_CA', N'AM001SS107',
N'', N'EA', N'', N'0', N'', N'US', N'DC', N'210010010000000016', N'',
N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012957 AS
Numeric(8, 0)), N'78009', N'', N'SP1675 SP 16_7.5 250_CA',
N'AM001SS107', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010010000000016', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012958 AS
Numeric(8, 0)), N'78010', N'', N'SP169 SP 16_9 500_CA', N'AM001SS107',
N'', N'EA', N'', N'0', N'', N'US', N'DC', N'210010010000000016', N'',
N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012959 AS
Numeric(8, 0)), N'78012', N'', N'SP16M2 SP 16C MAG_2 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000016', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012962 AS
Numeric(8, 0)), N'78016', N'', N'SP16M6 SP 16C MAG_6 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000016', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012966 AS
Numeric(8, 0)), N'78022', N'', N'PHV12M4 PR 12HV MAG_4 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012967 AS
Numeric(8, 0)), N'78024', N'', N'PHV12M5 PR 12HV MAG_5 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012968 AS
Numeric(8, 0)), N'78026', N'', N'PHV12M6 PR 12HV MAG_6 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012972 AS
Numeric(8, 0)), N'78034', N'', N'PHV1235M4 PR 12 3.5_ HV MAG_4 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012973 AS
Numeric(8, 0)), N'78036', N'', N'PHV1235M5 PR 12 3.5_ HV MAG_5 100_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012978 AS
Numeric(8, 0)), N'78047', N'', N'SP286 SP 28_6 250_CA', N'AM001SS107',
N'', N'EA', N'', N'0', N'', N'US', N'DC', N'210010010000000028', N'',
N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012980 AS
Numeric(8, 0)), N'78049', N'', N'SP2875 SP 28_7.5 250_CA',
N'AM001SS107', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010010000000028', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1012998 AS
Numeric(8, 0)), N'78076', N'', N'78076 SP 12H MAG_BB 500_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013004 AS
Numeric(8, 0)), N'78088', N'', N'78088 SP 20H MAG_2 500_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000020', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013008 AS
Numeric(8, 0)), N'78096', N'', N'78096 SP 12H MAG_6 500_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013026 AS
Numeric(8, 0)), N'78134', N'', N'NP12B NP 12 _ B 250_CA', N'AM001SS107',
N'', N'EA', N'', N'0', N'', N'US', N'DC', N'210010010000000012', N'',
N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013027 AS
Numeric(8, 0)), N'78136', N'', N'NP122 NP 12 _ 2 250_CA', N'AM001SS107',
N'', N'EA', N'', N'0', N'', N'US', N'DC', N'210010010000000012', N'',
N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013029 AS
Numeric(8, 0)), N'78140', N'', N'SPHV124 SP 12HV_4 250_CA',
N'AM001SS107', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010010000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013030 AS
Numeric(8, 0)), N'78142', N'', N'SPHV125 SP 12HV_5 250_CA',
N'AM001SS107', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010010000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013032 AS
Numeric(8, 0)), N'78144', N'', N'SPHV126 SP 12HV_6 250_CA',
N'AM001SS107', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010010000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013033 AS
Numeric(8, 0)), N'78146', N'', N'SPHV1275 SP 12HV_7.5 250_CA',
N'AM001SS107', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010010000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013046 AS
Numeric(8, 0)), N'78159', N'', N'RK123GM2 RK 12 MAG_2 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013047 AS
Numeric(8, 0)), N'78160', N'', N'SPHV204 SP 20HV_4 250_CA',
N'AM001SS107', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010010000000020', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013048 AS
Numeric(8, 0)), N'78161', N'', N'RK123GMBB RK 12 MAG_BB 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013050 AS
Numeric(8, 0)), N'78163', N'', N'RK123TM4 RK 12 TMAG_4 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013051 AS
Numeric(8, 0)), N'78164', N'', N'SPHV206 SP 20HV_6 250_CA',
N'AM001SS107', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010010000000020', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013052 AS
Numeric(8, 0)), N'78165', N'', N'RK123TM6 RK 12 TMAG_6 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013053 AS
Numeric(8, 0)), N'78166', N'', N'SPHV2075 SP 20HV_75 250_CA',
N'AM001SS107', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010010000000020', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013091 AS
Numeric(8, 0)), N'78227', N'', N'RW20HM4 RW 20H MAG_4 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000020', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013093 AS
Numeric(8, 0)), N'78231', N'', N'RW20HM6 RW 20H MAG_6 100_CA',
N'AM001SS116', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010024000000020', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013198 AS
Numeric(8, 0)), N'78507', N'', N'R413LR6 R 410LR_6 3_ 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000410', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013200 AS
Numeric(8, 0)), N'78509', N'', N'R413LR75 R 410LR_7.5 3_ 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000410', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013201 AS
Numeric(8, 0)), N'78510', N'', N'R410LR6 R 410LR_6 250_CA',
N'AM001SS107', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010010000000410', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013205 AS
Numeric(8, 0)), N'78514', N'', N'P12M4 PR 12 MAG_4 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013211 AS
Numeric(8, 0)), N'78520', N'', N'P12SM2 PR 12S MAG_2 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013212 AS
Numeric(8, 0)), N'78521', N'', N'P12SM5 PR 12S MAG_5 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013213 AS
Numeric(8, 0)), N'78522', N'', N'P12SM4 PR 12S MAG_4 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013214 AS
Numeric(8, 0)), N'78523', N'', N'P12SM4 PR 12S MAG_4 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013215 AS
Numeric(8, 0)), N'78524', N'', N'P12SM6_ PR 12S MAG_6 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013216 AS
Numeric(8, 0)), N'78525', N'', N'P12SM6 PR 12S MAG_6 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013217 AS
Numeric(8, 0)), N'78526', N'', N'P12HMB PR 12H MAG_BB 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013218 AS
Numeric(8, 0)), N'78527', N'', N'R12LR4 R 12LR_4 250_CA', N'AM001SS107',
N'', N'EA', N'', N'0', N'', N'US', N'DC', N'210010010000000012', N'',
N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013219 AS
Numeric(8, 0)), N'78528', N'', N'R12LR6 R 12LR_6 250_CA', N'AM001SS107',
N'', N'EA', N'', N'0', N'', N'US', N'DC', N'210010010000000012', N'',
N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013220 AS
Numeric(8, 0)), N'78529', N'', N'R12LR75 R 12LR_7.5 250_CA',
N'AM001SS107', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010010000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013225 AS
Numeric(8, 0)), N'78534', N'', N'P12HM2 PR 12H MAG_2 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013226 AS
Numeric(8, 0)), N'78535', N'', N'R16LR4 R 16LR_4 250_CA', N'AM001SS107',
N'', N'EA', N'', N'0', N'', N'US', N'DC', N'210010010000000016', N'',
N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013227 AS
Numeric(8, 0)), N'78536', N'', N'R16LR6 R 16LR_6 250_CA', N'AM001SS107',
N'', N'EA', N'', N'0', N'', N'US', N'DC', N'210010010000000016', N'',
N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013228 AS
Numeric(8, 0)), N'78537', N'', N'P12HM6 PR 12H MAG_6 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013229 AS
Numeric(8, 0)), N'78538', N'', N'R20LR6 R 20LR_6 250_CA', N'AM001SS107',
N'', N'EA', N'', N'0', N'', N'US', N'DC', N'210010010000000020', N'',
N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013230 AS
Numeric(8, 0)), N'78539', N'', N'R20LR75 R 20LR_75 250_CA',
N'AM001SS107', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010010000000020', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
GO
print 'Processed 300 total records'
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013232 AS
Numeric(8, 0)), N'78543', N'', N'P12XHM4 PR 12XH MAG_4 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013234 AS
Numeric(8, 0)), N'78545', N'', N'P12XHM5 PR 12XH MAG_5 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013236 AS
Numeric(8, 0)), N'78547', N'', N'P12XHM6 PR 12XH MAG_6 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N'DC',
N'210010020000000012', N'', N'', N'21', N'N', N'N', N'Y', N'H1')
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION],
[PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS],
[ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG],
[PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1013238 AS
Numeric(8, 0)), N'78554', N'', N'P1235MBB PR 1235 MAG_BB 250_CA',
N'AM001SS109', N'', N'EA', N'', N'0', N'', N'US', N

From: --CELKO-- on 7 Mar 2010 20:22

---

Where is the DDL? Those pages of INSERT INTO is DML! And I hope you
know better than to use the dialect INSERT and square brackets.

You already decided to use recursion; that is the way procedural
programmers think. SQL programmers think in terms of data and
declaration, not process.

You don't know that fields and columns are totally different concepts;
you have totally meaningless data element names (<something>_seq,
magical_id, and new_magical_id are examples of file system mindset
coupled with no exposure to ISO-11179 rules).

Read a basic RDBMS book, so you will use the right terms and have
basic concepts. Get a copy of TREES & HIERARCHIES IN SQL. Read the
parts about the Nested Sets model and put the recursion into the data
and not the process.

From: Blasting Cap on 8 Mar 2010 10:06

---

Not all of the DDL posted when I sent it out. For some reason, 2 of the
3 pieces went, but not the first. Sorry the first did not make it.

I provided the DML to illustrate the data that the recursive query ran on.

Part of the issue I have is where the data is going- into
Salesforce.com, where I have very limited ability to relate tables to
each other. What I am having to do is to "flatten" this table to load
so that code can be written in salesforce.com or somewhere else to
traverse it, determining & returning "two levels above sku/ID" that is
not null & could be in one of several columns.

BC


--CELKO-- wrote:
> Where is the DDL? Those pages of INSERT INTO is DML! And I hope you
> know better than to use the dialect INSERT and square brackets.
>
> You already decided to use recursion; that is the way procedural
> programmers think. SQL programmers think in terms of data and
> declaration, not process.
>
> You don't know that fields and columns are totally different concepts;
> you have totally meaningless data element names (<something>_seq,
> magical_id, and new_magical_id are examples of file system mindset
> coupled with no exposure to ISO-11179 rules).
>
> Read a basic RDBMS book, so you will use the right terms and have
> basic concepts. Get a copy of TREES & HIERARCHIES IN SQL. Read the
> parts about the Nested Sets model and put the recursion into the data
> and not the process.
>

From: Blasting Cap on 9 Mar 2010 11:27

---

Joe -

I have been reading the info you have suggested, and I am sure it's the
way I need to write this. I'd prefer to not use recursion, but right now
do not have that option. I have to make this work until I have the time
available to do trees.

Since my original post, there's a field that's been added to the source
table to indicate the level it's at, since not only is the table ragged,
but what the fields are referred to within that structure is ragged, too.

Ex:

LOB
BA1
BA1-A
BA1-A-A
BA1-A-A-1 <--- this is what they are calling a "family class"
BA1-A-A-1-A <-- this is what they call a "sales class"
12345 <-- sku
BA2
BA2-A <-- in this product, this is now a "family class"
BA2-A-A
BA2-A-A-1 <-- in this product this is a "sales class"
54321 <-- sku

The indicator field they added to the table tells me which one is
referred to as the particular class within that structure.

I want to get away from recursion since the number of levels will be
indeterminate and subject to change.

Given the DDL & DML I posted, how would I go about doing this in a tree
hierarchy?

BC





--CELKO-- wrote:
> Where is the DDL? Those pages of INSERT INTO is DML! And I hope you
> know better than to use the dialect INSERT and square brackets.
>
> You already decided to use recursion; that is the way procedural
> programmers think. SQL programmers think in terms of data and
> declaration, not process.
>
> You don't know that fields and columns are totally different concepts;
> you have totally meaningless data element names (<something>_seq,
> magical_id, and new_magical_id are examples of file system mindset
> coupled with no exposure to ISO-11179 rules).
>
> Read a basic RDBMS book, so you will use the right terms and have
> basic concepts. Get a copy of TREES & HIERARCHIES IN SQL. Read the
> parts about the Nested Sets model and put the recursion into the data
> and not the process.
>

 | 
Pages: 1
Prev: T-SQL to retrieve language pairs with a fallback to a default language when missing
Next: Alter table