|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Spreadsheet totalsselect 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 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. -- Show quoteArnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous "Blasting Cap" <goo***@christian.net> wrote in message news:uB1caAmsGHA.4608@TK2MSFTNGP04.phx.gbl... >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 Arnie Rowland wrote:
> It would help us better assist you if you could include table DDL, query Here is one of the three data sources> 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. > > INSERT INTO [sales_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) Arnie Rowland wrote:
> It would help us better assist you if you could include table DDL, query Here is the second data source> 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. > > 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') Arnie Rowland wrote: > It would help us better assist you if you could include table DDL, query Here is the 3rd data source> 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. > > 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 A | |||||||||||||||||||||||
