Need help with a recursive query - DDL Part 3
in [Programming SQL]
|
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. > |