 | |
Spreadsheet totals
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Spreadsheet totals -
07-28-2006
, 11:08 AM
#2
| |||
| |||
|
|
I have a query that I need to do subtotals on. The query is as follows: select ba, rg, sum(order_qty) as oqty, sum(order_val) as oval from sales_ord_curr_yr a inner join sales_product on sales_product.prod_cd = a.prod_cd inner join tblproducthierarchy on sales_product.level_1_1 + sales_product.level_1_2 + sales_product.level_2 + sales_product.level_3 = sproducthierarchy where level_1_1 in ('10','11','14') and convert(varchar,ord_date,101) = convert(varchar,DATEADD(day, -1, getdate()),101) group by ba,rg left(sProductHierarchy,5) order by left(sProductHierarchy,5) Basically, I am just after the previous day's orders. However, what I need to do is print out subtotals based on the field BA (varchar) changing, from 10, to 11, to 14. There are 2 RG's in BA 10, 5 in BA 11, and 5 in BA 14. I want to create a spreadsheet in DTS and then email it to a user as a regular job. The results should be similar to: BA RG Oqty Oval 10 100 1000 15000 10 200 550 12000 1550 27000 11 100 5 1000 11 200 5 1500 11 500 10 10000 20 12500 14 100 50 5000 14 200 25 2500 75 7500 Total 1550 + 75 + 20 27000+12500+7500 Is there any way to do this in SQL? I know how to do all of that, except for putting subtotals on each change in BA, and a grand total on all of it. Any help would be appreciated, BC |
#3
| |||
| |||
|
|
It would help us better assist you if you could include table DDL, query strategy used so far, sample data in the form of INSERT statements, and an illustration of the desired results. (For help with that refer to: http://www.aspfaq.com/5006 ) The less 'set up' work we have to do, the more likely you are going to have folks tackle your problem and help you. Without this effort from you, we are just playing guessing games. Here is one of the three data sources |
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26831',0,0,290.50,290.50)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26910',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26914',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26916',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26918',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89060',1,0,366.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24224',1,0,1173.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24512',10,0,4539.26,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25069',5,0,1295.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26056',1,0,230.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24602',1,0,292.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25069',1,0,259.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26056',2,0,460.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29383',1,0,749.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24602',2,0,584.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',2,0,246.90,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',2,0,246.90,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',2,0,246.90,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',2,0,246.90,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',2,0,246.90,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',2,0,246.90,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',2,0,246.90,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',2,0,246.90,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',2,0,246.90,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',2,0,246.90,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26062',1,0,123.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26619',2,0,683.72,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26619',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26619',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26619',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26621',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26621',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26621',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26621',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26621',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26621',2,0,683.72,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26621',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26621',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26621',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26621',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26621',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26621',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26621',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26621',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26621',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26621',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26621',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26621',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26621',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26623',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26910',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26910',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26910',2,0,575.56,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26910',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26910',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26910',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26910',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26910',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26910',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26910',2,0,575.56,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26910',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26910',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26910',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26910',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26910',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26910',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26914',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26914',2,0,575.56,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26914',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26914',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26914',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26914',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26914',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26914',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26914',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26914',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26914',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26914',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',2,0,450.54,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',4,0,901.08,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25082',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25082',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25082',2,0,450.54,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25082',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25082',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25082',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25082',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25082',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25082',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25082',2,0,450.54,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25082',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25082',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25082',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',2,0,450.54,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',2,0,450.54,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',2,0,450.54,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',4,0,901.08,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',2,0,450.54,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,225.27,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26625',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26625',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26625',1,0,341.86,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26625',2,0,683.72,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26916',3,0,863.34,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26916',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26916',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26916',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26916',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26916',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26918',2,0,575.56,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26918',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26918',1,0,287.78,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',2,0,148.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',2,0,148.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',2,0,148.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',2,0,148.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89260',1,0,74.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',2,0,138.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89290',1,0,69.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25065',2,0,430.46,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25071',2,0,585.02,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24606',1,0,250.96,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26065',2,0,325.75,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26060',1,0,275.06,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26016',1,0,291.68,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25094',1,0,309.13,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25124',1,0,317.44,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24185',2,0,1170.05,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25915',1,0,523.53,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29051',1,0,580.04,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29297',1,0,385.58,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29283',1,0,385.58,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24171',1,0,432.12,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24161',1,0,432.12,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26859',1,0,348.19,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26843',1,0,365.64,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25069',2,0,430.46,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25083',1,0,215.23,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25082',1,0,215.23,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,215.23,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25077',1,0,231.85,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25087',1,0,215.23,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','23903',60,0,20158.20,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','23917',25,0,8881.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26561',1,0,439.20,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25089',1,0,215.23,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25163',1,0,356.50,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25065',1,0,215.23,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24600',2,0,485.30,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24606',1,0,250.96,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26050',2,0,217.72,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26065',2,0,325.75,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26060',1,0,275.06,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25124',1,0,317.44,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24185',1,0,585.02,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26555',1,0,479.49,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29296',2,0,771.17,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29297',1,0,385.58,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24153',1,0,432.12,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24159',2,0,864.24,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24649',2,0,722.97,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26859',1,0,348.19,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26916',1,0,273.40,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25069',1,0,215.23,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25082',1,0,215.23,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25087',1,0,215.23,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25089',1,0,215.23,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25065',1,0,215.23,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25071',2,0,585.02,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24600',2,0,485.30,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24787',1,0,565.08,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29331',1,0,617.43,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26065',2,0,325.75,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26056',1,0,201.10,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26060',1,0,275.06,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26081',1,0,328.24,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25124',1,0,317.44,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24185',2,0,1170.05,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25915',1,0,523.53,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24159',2,0,864.24,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24649',2,0,722.97,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26849',1,0,348.19,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26859',1,0,348.19,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26843',1,0,365.64,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26839',1,0,365.64,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26916',1,0,273.40,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25069',1,0,215.23,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25083',1,0,215.23,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25061',1,0,215.23,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25077',1,0,231.85,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25087',2,0,430.46,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','23988',2,0,289.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','23990',2,0,333.20,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24076',2,0,285.60,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24082',1,0,142.80,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24122',4,0,367.20,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25145',6,0,4021.62,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25931',1,0,392.23,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','27016',1,0,206.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89406',250,0,0.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','23903',12,0,4475.16,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24013',2,0,206.46,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','23903',12,0,4475.16,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24013',2,0,206.46,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89406',750,0,0.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89406',250,0,0.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','23903',12,0,4475.16,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24013',2,0,206.46,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','23903',12,0,4475.16,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24013',2,0,206.46,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','23903',12,0,4475.16,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24013',2,0,206.46,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24063',1,0,65.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25933',1,0,344.40,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24633',5,0,1599.67,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89406',250,0,0.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24741',1,0,587.20,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24286',1,0,232.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25163',1,0,356.50,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25065',1,0,215.23,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26050',3,0,326.58,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26065',2,0,325.75,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26056',2,0,402.20,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26060',1,0,275.06,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26081',1,0,328.24,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25094',1,0,309.13,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25124',1,0,317.44,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24185',1,0,585.02,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26557',1,0,479.49,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29296',1,0,385.58,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29283',1,0,385.58,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24159',2,0,864.24,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24157',1,0,432.12,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24171',2,0,864.24,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24649',2,0,722.97,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26859',1,0,348.19,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26861',1,0,348.19,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26839',1,0,365.64,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25069',2,0,430.46,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25083',1,0,215.23,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24053',1,0,104.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29381',5,0,2385.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26050',5,0,609.15,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26056',5,0,1125.30,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26065',5,0,911.40,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29294',5,0,2157.60,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25068',5,0,1204.35,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25809',1,0,374.63,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26594',1,0,247.72,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26969',1,0,397.79,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26669',1,0,588.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25713',1,0,392.03,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89082',1,0,1380.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','23938',2,0,212.50,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24058',2,0,334.90,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24082',2,0,285.60,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24092',2,0,285.60,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24109',20,0,2448.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24111',10,0,1224.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24120',5,0,386.75,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24129',2,0,368.90,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29037',2,0,440.30,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29127',2,0,261.80,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','23995',1,0,129.20,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24147',1,0,169.15,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25812',1,0,116.45,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','27099',2,0,306.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29063',6,0,1014.90,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29065',1,0,130.90,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29070',1,0,169.15,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29106',1,0,169.15,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29123',1,0,130.90,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','23987',5,0,3175.95,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24308',2,0,2174.34,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24328',1,0,1191.33,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24483',5,0,2743.50,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24577',50,0,12508.50,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24597',25,0,6719.25,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24657',5,0,1436.85,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24859',5,0,3162.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24927',5,0,3050.40,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25298',5,0,2831.85,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25301',3,0,1754.91,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25303',5,0,2924.85,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25357',2,0,1233.18,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25683',2,0,1450.80,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25696',1,0,725.40,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25856',1,0,1041.60,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25862',1,0,1041.60,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25869',5,0,3022.50,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25925',40,0,26188.80,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26421',5,0,2678.40,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26551',10,0,6045.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26557',10,0,5366.10,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26563',5,0,2683.05,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26579',5,0,2683.05,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26605',5,0,3022.50,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26609',5,0,3115.50,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26683',5,0,3417.75,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26691',10,0,6835.50,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26693',2,0,1367.10,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26767',20,0,9188.40,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26837',10,0,4092.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26859',20,0,7793.40,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26885',5,0,1948.35,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26993',5,0,2994.60,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29039',5,0,2208.75,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29294',10,0,4315.20,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29358',30,0,16377.30,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','88795',10,0,2790.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','88798',15,0,4185.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','88786',5,0,1395.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','88960',5,0,1525.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89020',5,0,1465.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89184',10,0,2990.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89040',5,0,1200.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89190',5,0,1200.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89046',10,0,3450.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89022',5,0,1620.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89224',5,0,1725.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89066',5,0,1990.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89206',10,0,3980.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89204',5,0,1990.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','88892',20,0,4800.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89406',250,0,0.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','89406',250,0,0.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24577',1,0,223.54,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24635',2,0,639.87,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','24111',1,0,123.12,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29123',1,0,131.67,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','29115',1,0,202.64,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','25933',3,0,1033.20,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','88799',1,0,319.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','27067',1,0,1199.00,0.00)
INSERT INTO [sales_ord_curr_yr_test1]
([ord_date],[prod_cd],[order_qty],[ship_qty],[order_val],[ship_val])VALUES('Jul
27 2006 12:00:00:000AM','26831',0,0,-344.86,-344.86)
#4
| |||
| |||
|
|
It would help us better assist you if you could include table DDL, query strategy used so far, sample data in the form of INSERT statements, and an illustration of the desired results. (For help with that refer to: http://www.aspfaq.com/5006 ) The less 'set up' work we have to do, the more likely you are going to have folks tackle your problem and help you. Without this effort from you, we are just playing guessing games. Here is the second data source |
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('89406','14','700','00200','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25163','11','001','00640','0040')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25094','11','002','01100','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25071','11','001','00640','0040')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('88892','14','375','00100','0410')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('27067','11','004','00095','0000')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('29331','11','001','00300','0040')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26683','11','002','00170','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25301','11','002','00100','0040')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('29039','11','002','00300','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26859','11','002','00100','0027')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24058','11','005','00100','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('89184','14','001','00200','0015')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26837','11','002','00100','0027')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('89060','14','001','00300','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25124','11','002','01100','0030')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26767','11','002','00200','0025')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24111','11','005','00100','0030')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('29070','11','005','00300','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('89260','14','001','00100','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25087','11','001','00600','0030')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25869','11','002','00305','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24787','11','001','00300','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26561','11','002','00390','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24120','11','005','00100','0040')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26914','10','002','00100','0060')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26060','10','003','01100','0050')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26421','11','001','00500','0015')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24657','11','001','00625','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('29294','11','002','00400','0015')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('89290','14','001','00100','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('29063','11','005','00200','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26691','11','002','00170','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24512','11','001','00500','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24602','11','001','00600','0015')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24649','11','002','00410','0025')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25931','11','001','00690','0040')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('23990','11','005','00300','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24159','11','002','00410','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26621','11','002','00100','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25809','11','002','00200','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25915','11','002','00305','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24633','11','001','00600','0015')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26605','11','002','00100','0032')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('27099','11','005','00100','0030')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('29383','11','001','00300','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25683','11','002','00200','0035')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25069','11','001','00600','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24286','11','002','00300','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25856','11','002','00200','0017')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25061','11','001','00620','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26969','11','001','00500','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('88798','14','600','00100','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('23917','11','001','00500','0040')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26551','11','002','00100','0032')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('29037','11','005','00200','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25077','11','001','00600','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('89082','14','001','00400','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('23987','11','001','00400','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24577','11','001','00600','0030')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26669','11','002','00170','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24013','11','005','00100','0040')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('23995','11','005','00100','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26849','11','002','00100','0027')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('89066','14','001','00300','0040')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('29115','11','005','00200','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('23903','11','001','00500','0040')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('29123','11','005','00200','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26843','11','002','00100','0027')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24185','11','002','00340','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26081','10','003','01100','0050')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24859','11','001','00300','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('29296','11','002','00400','0015')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25298','11','002','00100','0040')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('89190','14','001','00200','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24122','11','005','00100','0030')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24224','11','004','00100','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('88799','14','600','00100','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25862','11','002','00200','0017')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25933','11','001','00690','0040')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('23988','11','005','00300','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26050','10','003','01100','0040')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24129','11','005','00200','0025')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24153','11','002','00410','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24082','11','005','00100','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26623','11','002','00100','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('89206','14','001','00300','0040')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26693','11','002','00170','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24741','11','001','00400','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25713','11','001','00500','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24600','11','001','00600','0015')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25925','11','002','00200','0023')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('29051','11','002','00310','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('29358','11','001','00300','0038')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('29381','11','001','00300','0038')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24092','11','005','00100','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24161','11','002','00410','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26579','11','002','00390','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26625','11','002','00100','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26594','11','002','00100','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24483','11','001','00500','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('23938','11','005','00300','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('29297','11','002','00400','0015')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25812','11','005','00100','0030')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26910','10','002','00100','0060')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26557','11','002','00390','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26065','10','003','01100','0040')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25083','11','001','00620','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26609','11','002','00100','0032')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24308','11','001','00200','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26918','10','002','00100','0060')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25068','11','001','00600','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('27016','11','002','00100','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24076','11','005','00100','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25696','11','002','00200','0035')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('89040','14','001','00200','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26056','10','003','01100','0040')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('29106','11','005','00200','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24606','11','001','00600','0015')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('89204','14','001','00300','0040')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26993','11','002','00100','0060')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24053','11','005','00100','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('89224','14','001','00200','0012')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24147','11','005','00200','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('89020','14','001','00200','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25065','11','001','00600','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24927','11','001','00400','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('88786','14','600','00100','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25357','11','002','00100','0080')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24171','11','002','00410','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('29283','11','002','00400','0015')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24328','11','001','00200','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26831','11','002','00100','0027')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25303','11','002','00100','0040')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26861','11','002','00100','0027')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24109','11','005','00100','0030')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26555','11','002','00390','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24597','11','001','00600','0030')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26016','10','003','01100','0060')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26062','10','003','01100','0040')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26563','11','002','00390','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25089','11','001','00600','0030')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('29127','11','005','00200','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('88960','14','250','00100','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26916','10','002','00100','0060')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('88795','14','600','00100','0010')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26839','11','002','00100','0027')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26885','11','002','00100','0027')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('89046','14','001','00200','0029')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24157','11','002','00410','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('26619','11','002','00100','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25145','11','002','00100','0110')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24063','11','005','00100','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('89022','14','001','00200','0012')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('24635','11','001','00600','0015')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('25082','11','001','00620','0020')
INSERT INTO [sales_product_test1]
([prod_cd],[level_1_1],[level_1_2],[level_2],[level_3])VALUES('29065','11','005','00300','0010')
#5
| |||
| |||
|
|
It would help us better assist you if you could include table DDL, query strategy used so far, sample data in the form of INSERT statements, and an illustration of the desired results. (For help with that refer to: http://www.aspfaq.com/5006 ) The less 'set up' work we have to do, the more likely you are going to have folks tackle your problem and help you. Without this effort from you, we are just playing guessing games. Here is the 3rd data source |
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10000000000000','BUSINESS AREA
1','RG 8')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10001000000000','BUSINESS AREA
1','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10002000000000','BUSINESS AREA
1','RG 16')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10002001000000','BUSINESS AREA
1','RG 16')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10002001000040','BUSINESS AREA
1','RG 16')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10002001000060','BUSINESS AREA
1','RG 16')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10002001200000','BUSINESS AREA
1','RG 16')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10002001200060','BUSINESS AREA
1','RG 16')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10002001500000','BUSINESS AREA
1','RG 16')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10002001500060','BUSINESS AREA
1','RG 16')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10003000000000','BUSINESS AREA
1','RG 23')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10003011000000','BUSINESS AREA
1','RG 23')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10003011000040','BUSINESS AREA
1','RG 23')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10003011000050','BUSINESS AREA
1','RG 23')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10003011000060','BUSINESS AREA
1','RG 23')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10004000000000','BUSINESS AREA
1','RG 3')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10004002000000','BUSINESS AREA
1','RG 3')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10004002000010','BUSINESS AREA
1','RG 3')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10004002000015','BUSINESS AREA
1','RG 3')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10004002000020','BUSINESS AREA
1','RG 3')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10100000000000','BUSINESS AREA
1','RG 22')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10100001000000','BUSINESS AREA
1','RG 22')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10100001000100','BUSINESS AREA
1','RG 22')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10100001000130','BUSINESS AREA
1','RG 22')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10100001000150','BUSINESS AREA
1','RG 22')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10100002000000','BUSINESS AREA
1','RG 22')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10100002000100','BUSINESS AREA
1','RG 22')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10300000000000','BUSINESS AREA
1','RG 12')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10300001000000','BUSINESS AREA
1','RG 12')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10300001000010','BUSINESS AREA
1','RG 12')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10300003000000','BUSINESS AREA
1','RG 12')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10300005000000','BUSINESS AREA
1','RG 12')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10300005000100','BUSINESS AREA
1','RG 12')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10500000000000','BUSINESS AREA
1','RG 11')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10500002000000','BUSINESS AREA
1','RG 11')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10500002000010','BUSINESS AREA
1','RG 11')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10500002000020','BUSINESS AREA
1','RG 11')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10992000000000','BUSINESS AREA
1','RG 20')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10992001000000','BUSINESS AREA
1','RG 20')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('1099200100100','BUSINESS AREA
1','RG 20')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('1099200100200','BUSINESS AREA
1','RG 20')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10992001200000','BUSINESS AREA
1','RG 20')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('1099200120100','BUSINESS AREA
1','RG 20')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('1099200120200','BUSINESS AREA
1','RG 20')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10992001500000','BUSINESS AREA
1','RG 20')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('1099200150100','BUSINESS AREA
1','RG 20')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('1099200150200','BUSINESS AREA
1','RG 20')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10993000000000','BUSINESS AREA
1','RG 21')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10993001000000','BUSINESS AREA
1','RG 21')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('1099300100100','BUSINESS AREA
1','RG 21')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('1099300100200','BUSINESS AREA
1','RG 21')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10994000000000','BUSINESS AREA
1','RG 17')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10994001000000','BUSINESS AREA
1','RG 17')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('1099400100100','BUSINESS AREA
1','RG 17')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('1099400100200','BUSINESS AREA
1','RG 17')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10994002000000','BUSINESS AREA
1','RG 17')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('1099400200100','BUSINESS AREA
1','RG 17')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('1099400200200','BUSINESS AREA
1','RG 17')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10994002500000','BUSINESS AREA
1','RG 17')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('1099400250100','BUSINESS AREA
1','RG 17')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('1099400250200','BUSINESS AREA
1','RG 17')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10997000000000','BUSINESS AREA
1','RG 24')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10998000000000','BUSINESS AREA
1','RG 2')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('10999000000000','BUSINESS AREA
1','RG 1')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11000000000000','BUSINESS AREA
2','RG 7')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001000000000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001001000000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001001000010','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001001100000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001001100010','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001001200000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001001200010','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001001300000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001001300010','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001001400000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001001400010','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001002000000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001002000010','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001002500000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001002500010','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001002500015','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001002500020','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001002500025','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001002500030','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001002500035','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001002700000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001002700010','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001002760000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001002760010','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001003000000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001003000010','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001003000015','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001003000020','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001003000025','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001003000030','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001003000035','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001003000038','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001003000039','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001003000040','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001003000050','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001003050000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001003050040','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001003100000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001003100010','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001004000000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001004000010','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001004000020','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001004300000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001004300040','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001005000000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001005000010','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001005000015','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001005000020','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001005000025','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001005000027','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001005000030','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001005000040','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001005200000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001005200010','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006000000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006000010','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006000011','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006000012','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006000015','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006000020','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006000030','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006000033','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006000036','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006000040','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006100000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006100020','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006200000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006200020','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006250000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006250020','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006400000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006400040','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006900000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001006900040','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001007000000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001007000010','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001008000000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001008000010','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001009000000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001009000010','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11001010000000','BUSINESS AREA
2','RG 29')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002000000000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000010','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000020','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000025','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000026','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000027','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000029','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000030','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000032','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000033','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000035','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000040','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000050','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000060','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000070','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000078','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000080','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000090','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000091','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000092','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000100','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001000110','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001400000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001400010','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001700000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002001700010','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002002000000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002002000005','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002002000010','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002002000015','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002002000017','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002002000020','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002002000023','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002002000025','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002002000028','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002002000030','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002002000035','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002002000040','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002002000100','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002002900000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002002900010','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002003000000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002003000010','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002003000020','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002003050000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002003050010','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002003100000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002003100010','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002003150000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002003150010','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002003400000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002003400010','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002003900000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002003900010','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002003940000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002003940010','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002004000000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002004000010','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002004000015','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002004000020','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002004000025','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002004050000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002004050010','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002004050015','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002004100000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002004100020','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002004100025','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002004150000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002004150020','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002004200000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002004200010','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002004300000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002004300010','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002005000000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002006000000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002007000000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002011000000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002011000010','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002011000020','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002011000030','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002011000040','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002012000000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002012000010','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002012000020','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002012000030','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11002015000000','BUSINESS AREA
2','RG 15')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11003000000000','BUSINESS AREA
2','RG 5')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11003001000000','BUSINESS AREA
2','RG 5')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11003003000000','BUSINESS AREA
2','RG 5')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11003004000000','BUSINESS AREA
2','RG 5')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004000000000','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004000600000','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004000600050','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004000800000','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004000800050','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004000850000','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004000850050','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004000950000','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004001000000','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004001000010','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004001000015','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004001000020','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004001000025','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004001000030','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004001000040','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004002000000','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004002000010','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004002000040','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004002000050','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004003000000','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11004004000000','BUSINESS AREA
2','RG 6')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11005000000000','BUSINESS AREA
2','RG 26')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11005001000000','BUSINESS AREA
2','RG 26')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11005001000010','BUSINESS AREA
2','RG 26')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11005001000020','BUSINESS AREA
2','RG 26')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11005001000030','BUSINESS AREA
2','RG 26')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11005001000040','BUSINESS AREA
2','RG 26')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11005002000000','BUSINESS AREA
2','RG 26')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11005002000010','BUSINESS AREA
2','RG 26')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11005002000020','BUSINESS AREA
2','RG 26')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11005002000025','BUSINESS AREA
2','RG 26')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11005002000040','BUSINESS AREA
2','RG 26')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11005003000000','BUSINESS AREA
2','RG 26')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11005003000010','BUSINESS AREA
2','RG 26')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11005003000020','BUSINESS AREA
2','RG 26')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11005004000000','BUSINESS AREA
2','RG 26')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11005004000010','BUSINESS AREA
2','RG 26')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11005005000000','BUSINESS AREA
2','RG 26')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11005006000000','BUSINESS AREA
2','RG 26')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11400000000000','BUSINESS AREA
2','RG 25')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11700000000000','BUSINESS AREA
2','RG 14')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11900000000000','BUSINESS AREA
2','RG 10')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('11999000000000','BUSINESS AREA
2','RG 24')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14000000000000','BUSINESS AREA
3','RG 9')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001000000000','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001001000000','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001001000010','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001001000015','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001001000060','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001002000000','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001002000010','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001002000012','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001002000015','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001002000020','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001002000022','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001002000025','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001002000027','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001002000029','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001003000000','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001003000010','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001003000020','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001003000040','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001003000080','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001003000200','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001004000000','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001004000010','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001004000020','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14001004000030','BUSINESS AREA
3','RG 30')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14250000000000','BUSINESS AREA
3','RG 4')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14250001000000','BUSINESS AREA
3','RG 4')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14250001000010','BUSINESS AREA
3','RG 4')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14350000000000','BUSINESS AREA
3','RG 27')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14350001000000','BUSINESS AREA
3','RG 27')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14350001000012','BUSINESS AREA
3','RG 27')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14375000000000','BUSINESS AREA
3','RG 28')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14375001000000','BUSINESS AREA
3','RG 28')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14375001000012','BUSINESS AREA
3','RG 28')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14375001000410','BUSINESS AREA
3','RG 28')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14400000000000','BUSINESS AREA
3','RG 18')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14400001000000','BUSINESS AREA
3','RG 18')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14400001000010','BUSINESS AREA
3','RG 18')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14400001000020','BUSINESS AREA
3','RG 18')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14400002000000','BUSINESS AREA
3','RG 18')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14400002000010','BUSINESS AREA
3','RG 18')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14400004000000','BUSINESS AREA
3','RG 18')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14400004000010','BUSINESS AREA
3','RG 18')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14400004000020','BUSINESS AREA
3','RG 18')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14400006000000','BUSINESS AREA
3','RG 18')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14600000000000','BUSINESS AREA
3','RG 13')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14600001000000','BUSINESS AREA
3','RG 13')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14600001000010','BUSINESS AREA
3','RG 13')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14700000000000','BUSINESS AREA
3','RG 19')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14700001000000','BUSINESS AREA
3','RG 19')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14700001000010','BUSINESS AREA
3','RG 19')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14700001000020','BUSINESS AREA
3','RG 19')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14700001800000','BUSINESS AREA
3','RG 19')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14700001800010','BUSINESS AREA
3','RG 19')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14700001800020','BUSINESS AREA
3','RG 19')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14700002000000','BUSINESS AREA
3','RG 19')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14700002000005','BUSINESS AREA
3','RG 19')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14700002000010','BUSINESS AREA
3','RG 19')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14700002000020','BUSINESS AREA
3','RG 19')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14700005000000','BUSINESS AREA
3','RG 19')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14700005000010','BUSINESS AREA
3','RG 19')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14700005000020','BUSINESS AREA
3','RG 19')
INSERT INTO [tblproducthierarchy_test1]
([sProductHierarchy],[BA],[RG])VALUES('14700005000030','BUSINESS AREA
3','RG 19')
#6
| |||
| |||
|
|
It would help us better assist you if you could include table DDL, query strategy used so far, sample data in the form of INSERT statements, and an illustration of the desired results. (For help with that refer to: http://www.aspfaq.com/5006 ) The less 'set up' work we have to do, the more likely you are going to have folks tackle your problem and help you. Without this effort from you, we are just playing guessing games. Here are the table definitions. I posted them a while ago, but they |
Here's the main table:
CREATE TABLE [sales_ord_curr_yr_test1] (
[ord_date] [datetime] NULL ,
[prod_cd] [char] (18) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[order_qty] [int] NULL ,
[ship_qty] [int] NULL ,
[order_val] [decimal](18, 2) NULL ,
[ship_val] [decimal](18, 2) NULL
) ON [PRIMARY]
GO
Here's the product file:
CREATE TABLE [SALES_PRODUCT_test1] (
[prod_cd] [char] (18) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[level_1_1] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[level_1_2] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[level_2] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[level_3] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [tblProductHierarchy_test1] (
[sProductHierarchy] [varchar] (14) COLLATE
SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[BA] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[RG] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
CONSTRAINT [aaaaatblProductHierarchy_PK] PRIMARY KEY NONCLUSTERED
(
[sProductHierarchy]
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
I will try to post the data in a few.
BC
#7
| |||
| |||
|
|
Arnie Rowland wrote: It would help us better assist you if you could include table DDL, query strategy used so far, sample data in the form of INSERT statements, and an illustration of the desired results. (For help with that refer to: http://www.aspfaq.com/5006 ) The less 'set up' work we have to do, the more likely you are going to have folks tackle your problem and help you. Without this effort from you, we are just playing guessing games. Here are the table definitions. I posted them a while ago, but they never showed up. Here's the main table: CREATE TABLE [sales_ord_curr_yr_test1] ( [ord_date] [datetime] NULL , [prod_cd] [char] (18) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [order_qty] [int] NULL , [ship_qty] [int] NULL , [order_val] [decimal](18, 2) NULL , [ship_val] [decimal](18, 2) NULL ) ON [PRIMARY] GO Here's the product file: CREATE TABLE [SALES_PRODUCT_test1] ( [prod_cd] [char] (18) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [level_1_1] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [level_1_2] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [level_2] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [level_3] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [tblProductHierarchy_test1] ( [sProductHierarchy] [varchar] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [BA] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [RG] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , CONSTRAINT [aaaaatblProductHierarchy_PK] PRIMARY KEY NONCLUSTERED ( [sProductHierarchy] ) WITH FILLFACTOR = 90 ON [PRIMARY] ) ON [PRIMARY] GO I will try to post the data in a few. BC |
#8
| |||
| |||
|
|
= midnight yesterday and < midnight today), but will run much faster because it only needs to do the conversion once (since it treats getdate() |
ord_date column.
HTH,
Tom
"Blasting Cap" <goober (AT) christian (DOT) net> wrote
Quote:
|
Arnie Rowland wrote: It would help us better assist you if you could include table DDL, query strategy used so far, sample data in the form of INSERT statements, and an illustration of the desired results. (For help with that refer to: http://www.aspfaq.com/5006 ) The less 'set up' work we have to do, the more likely you are going to have folks tackle your problem and help you. Without this effort from you, we are just playing guessing games. Here are the table definitions. I posted them a while ago, but they never showed up. Here's the main table: CREATE TABLE [sales_ord_curr_yr_test1] ( [ord_date] [datetime] NULL , [prod_cd] [char] (18) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [order_qty] [int] NULL , [ship_qty] [int] NULL , [order_val] [decimal](18, 2) NULL , [ship_val] [decimal](18, 2) NULL ) ON [PRIMARY] GO Here's the product file: CREATE TABLE [SALES_PRODUCT_test1] ( [prod_cd] [char] (18) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [level_1_1] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [level_1_2] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [level_2] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [level_3] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [tblProductHierarchy_test1] ( [sProductHierarchy] [varchar] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [BA] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [RG] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , CONSTRAINT [aaaaatblProductHierarchy_PK] PRIMARY KEY NONCLUSTERED ( [sProductHierarchy] ) WITH FILLFACTOR = 90 ON [PRIMARY] ) ON [PRIMARY] GO I will try to post the data in a few. BC |
#9
| |||
| |||
|
|
From YourTable group by ba,rg |
Select '2' ,ba,' ' rg,Sum(order_qty),sum(order_val)
Quote:
|
From YourTable group by ba |
I hope this helps.
With Warm regards
Jatinder Singh
http://jatindersingh.blogspot.com
http://sqloracle.tripod.com
#10
| |||
| |||
|
|
Thanks for posting the DDL and data. You can use the rollup option of the group by to generate subtotals (lookup rollup and cube in BOL), so your query should look something like I have chosen to mark the total rows with the literal 'Totals', there are lots of other ways you can do this, for example, you can include the grouping() function results as a column in your output, you just need some some way to tell which rows are totals and which rows are details: select Case When Grouping (ba) = 1 Then 'Totals' Else ba End as ba, Case When Grouping (rg) = 1 Then 'Totals' Else rg End as rg, sum(order_qty) as oqty, sum(order_val) as oval from sales_ord_curr_yr_test1 a inner join sales_product_test1 p on p.prod_cd = a.prod_cd inner join tblproducthierarchy_test1 h on p.level_1_1 + p.level_1_2 + p.level_2 + p.level_3 = h.sproducthierarchy where level_1_1 in ('10','11','14') and ord_date >= DATEADD(day, -1, convert(char,getdate(),101)) and ord_date < convert(char,getdate(),101) group by ba,rg, left(sProductHierarchy,5) with rollup having grouping (left(sProductHierarchy,5)) = 1 order by ba, Grouping (ba), rg , Grouping (rg), left(sProductHierarchy,5) A couple of comments, first when testing this query with the sample data you provided, remember it will stop working at midnight tonight (I feel like I'm talking to Cinderella <BG>) because it is testing for data with yesterday's date. If testing after midnight tonight, either change the getdate() functions to a date literal of '2006-07-28' (todays date) or change the dates on your sample data so that they have yesterday's date since this query only finds yesterday's data. Second, your original query had a where clause that included: and convert(varchar,ord_date,101) = convert(varchar,DATEADD(day, -1, getdate()),101) which is intended to get all the data from yesterday. You don't want to do it this way because it has a function applied to a column in your table. If at all posible you don't want to do this because 1) SQL Server will not be able to use an index if you do this, and 2) SQL Server has to apply the convert function on every row it examines. Instead, write it something like: and ord_date >= DATEADD(day, -1, convert(char,getdate(),101)) and ord_date < convert(char,getdate(),101) which is logically exactly the same thing (give me all rows with a datetime = midnight yesterday and < midnight today), but will run much faster because it only needs to do the conversion once (since it treats getdate() as a constant and only evaluates it once) and can use indexes on the ord_date column. HTH, Tom "Blasting Cap" <goober (AT) christian (DOT) net> wrote in message news:%231P0slosGHA.4324 (AT) TK2MSFTNGP05 (DOT) phx.gbl... Arnie Rowland wrote: It would help us better assist you if you could include table DDL, query strategy used so far, sample data in the form of INSERT statements, and an illustration of the desired results. (For help with that refer to: http://www.aspfaq.com/5006 ) The less 'set up' work we have to do, the more likely you are going to have folks tackle your problem and help you. Without this effort from you, we are just playing guessing games. Here are the table definitions. I posted them a while ago, but they never showed up. Here's the main table: CREATE TABLE [sales_ord_curr_yr_test1] ( [ord_date] [datetime] NULL , [prod_cd] [char] (18) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [order_qty] [int] NULL , [ship_qty] [int] NULL , [order_val] [decimal](18, 2) NULL , [ship_val] [decimal](18, 2) NULL ) ON [PRIMARY] GO Here's the product file: CREATE TABLE [SALES_PRODUCT_test1] ( [prod_cd] [char] (18) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [level_1_1] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [level_1_2] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [level_2] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [level_3] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [tblProductHierarchy_test1] ( [sProductHierarchy] [varchar] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [BA] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [RG] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , CONSTRAINT [aaaaatblProductHierarchy_PK] PRIMARY KEY NONCLUSTERED ( [sProductHierarchy] ) WITH FILLFACTOR = 90 ON [PRIMARY] ) ON [PRIMARY] GO I will try to post the data in a few. BC |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.