LINQ To DataSet Samples - Grouping Operators
GroupBy - Simple 1
This sample uses group by to partition a list of numbers by their remainder when divided by 5.
Public Sub DataSetLinq40()
Dim numbers = TestDS.Tables("Numbers").AsEnumerable
Dim numberGroups = From n In numbers _
Group n By num = n.Field(Of Integer)("number") Mod 5 Into Group _
Select Remainder = num, NumberGroup = Group
For Each g In numberGroups
Console.WriteLine("Numbers with a remainder of {0} when divided by 5:", g.Remainder)
For Each n In g.NumberGroup
Console.WriteLine(n("number"))
Next
Next
End Sub
Result:
Numbers with a remainder of 0 when divided by 5:
5
0
Numbers with a remainder of 4 when divided by 5:
4
9
Numbers with a remainder of 1 when divided by 5:
1
6
Numbers with a remainder of 3 when divided by 5:
3
8
Numbers with a remainder of 2 when divided by 5:
7
2
GroupBy - Simple 2
This sample uses group by to partition a list of words by their first letter.
Public Sub DataSetLinq41()
Dim words4 = TestDS.Tables("Words4").AsEnumerable()
Dim wordGroups = From w In words4 _
Group w By FirstLetter = w.Field(Of String)("word")(0) Into Group _
Select FirstLetter, Words = Group
For Each g In wordGroups
Console.WriteLine("Words that start with the letter '{0}':", g.FirstLetter)
For Each w In g.Words
Console.WriteLine(w("word"))
Next
Next
End Sub
Result:
Words that start with the letter 'b':
blueberry
banana
Words that start with the letter 'c':
chimpanzee
cheese
Words that start with the letter 'a':
abacus
apple
GroupBy - Simple 3
This sample uses group by to partition a list of products by category.
Public Sub DataSetLinq42()
Dim products = TestDS.Tables("Products").AsEnumerable
Dim productGroups = From p In products _
Group p By Category = p.Field(Of String)("Category") Into Group _
Select Category, ProductGroup = Group
For Each g In productGroups
Console.WriteLine("Category: {0}", g.Category)
For Each w In g.ProductGroup
Console.WriteLine(vbTab & w("ProductName"))
Next
Next
End Sub
Result:
Category: Beverages
Chai
Chang
Guaraná Fantástica
Sasquatch Ale
Steeleye Stout
Côte de Blaye
Chartreuse verte
Ipoh Coffee
Laughing Lumberjack Lager
Outback Lager
Rhönbräu Klosterbier
Lakkalikööri
Category: Condiments
Aniseed Syrup
Chef Anton's Cajun Seasoning
Chef Anton's Gumbo Mix
Grandma's Boysenberry Spread
Northwoods Cranberry Sauce
Genen Shouyu
Gula Malacca
Sirop d'érable
Vegie-spread
Louisiana Fiery Hot Pepper Sauce
Louisiana Hot Spiced Okra
Original Frankfurter grüne Soße
Category: Produce
Uncle Bob's Organic Dried Pears
Tofu
Rössle Sauerkraut
Manjimup Dried Apples
Longlife Tofu
Category: Meat/Poultry
Mishi Kobe Niku
Alice Mutton
Thüringer Rostbratwurst
Perth Pasties
Tourtière
Pâté chinois
Category: Seafood
Ikura
Konbu
Carnarvon Tigers
Nord-Ost Matjeshering
Inlagd Sill
Gravad lax
Boston Crab Meat
Jack's New England Clam Chowder
Rogede sild
Spegesild
Escargots de Bourgogne
Röd Kaviar
Category: Dairy Products
Queso Cabrales
Queso Manchego La Pastora
Gorgonzola Telino
Mascarpone Fabioli
Geitost
Raclette Courdavault
Camembert Pierrot
Gudbrandsdalsost
Flotemysost
Mozzarella di Giovanni
Category: Confections
Pavlova
Teatime Chocolate Biscuits
Sir Rodney's Marmalade
Sir Rodney's Scones
NuNuCa Nuß-Nougat-Creme
Gumbär Gummibärchen
Schoggi Schokolade
Zaanse koeken
Chocolade
Maxilaku
Valkoinen suklaa
Tarte au sucre
Scottish Longbreads
Category: Grains/Cereals
Gustaf's Knäckebröd
Tunnbröd
Singaporean Hokkien Fried Mee
Filo Mix
Gnocchi di nonna Alice
Ravioli Angelo
Wimmers gute Semmelknödel
GroupBy - Nested
This sample uses group by to partition a list of each customer's orders, first by year, and then by month.
Public Sub DataSetLinq43()
Dim customers = TestDS.Tables("Customers").AsEnumerable
Dim custOrdersGroups = From c In customers _
Select CompanyName = c!CompanyName, _
YearGroups = From o In c.GetChildRows("CustomersOrders") _
Group o By Key = o.Field(Of DateTime)("OrderDate").Year Into Group _
Select Year = Key, _
MonthGroups = From o In Group _
Group o By MonthKey = o.Field(Of DateTime)("OrderDate").Month Into MonthGroup = Group _
Select Month = MonthKey, Orders = MonthGroup
For Each cog In custOrdersGroups
Console.WriteLine("CompanyName= {0}", cog.CompanyName)
For Each yg In cog.YearGroups
Console.WriteLine(vbTab & " Year= {0}", yg.Year)
For Each mg In yg.MonthGroups
Console.WriteLine(vbTab & vbTab & " Month= {0}", mg.Month)
For Each order In mg.Orders
Console.WriteLine(vbTab & vbTab & vbTab & " OrderID= {0} ", order("OrderID"))
Console.WriteLine(vbTab & vbTab & vbTab & " OrderDate= {0} ", order("OrderDate"))
Next
Next
Next
Next
End Sub
Result:
CompanyName= Alfreds Futterkiste
Year= 1997
Month= 8
OrderID= 10643
OrderDate= 8/25/1997 12:00:00 AM
Month= 10
OrderID= 10692
OrderDate= 10/3/1997 12:00:00 AM
OrderID= 10702
OrderDate= 10/13/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10835
OrderDate= 1/15/1998 12:00:00 AM
Month= 3
OrderID= 10952
OrderDate= 3/16/1998 12:00:00 AM
Month= 4
OrderID= 11011
OrderDate= 4/9/1998 12:00:00 AM
CompanyName= Ana Trujillo Emparedados y helados
Year= 1996
Month= 9
OrderID= 10308
OrderDate= 9/18/1996 12:00:00 AM
Year= 1997
Month= 8
OrderID= 10625
OrderDate= 8/8/1997 12:00:00 AM
Month= 11
OrderID= 10759
OrderDate= 11/28/1997 12:00:00 AM
Year= 1998
Month= 3
OrderID= 10926
OrderDate= 3/4/1998 12:00:00 AM
CompanyName= Antonio Moreno Taquería
Year= 1996
Month= 11
OrderID= 10365
OrderDate= 11/27/1996 12:00:00 AM
Year= 1997
Month= 4
OrderID= 10507
OrderDate= 4/15/1997 12:00:00 AM
Month= 5
OrderID= 10535
OrderDate= 5/13/1997 12:00:00 AM
Month= 6
OrderID= 10573
OrderDate= 6/19/1997 12:00:00 AM
Month= 9
OrderID= 10677
OrderDate= 9/22/1997 12:00:00 AM
OrderID= 10682
OrderDate= 9/25/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10856
OrderDate= 1/28/1998 12:00:00 AM
CompanyName= Around the Horn
Year= 1996
Month= 11
OrderID= 10355
OrderDate= 11/15/1996 12:00:00 AM
Month= 12
OrderID= 10383
OrderDate= 12/16/1996 12:00:00 AM
Year= 1997
Month= 2
OrderID= 10453
OrderDate= 2/21/1997 12:00:00 AM
Month= 6
OrderID= 10558
OrderDate= 6/4/1997 12:00:00 AM
Month= 10
OrderID= 10707
OrderDate= 10/16/1997 12:00:00 AM
Month= 11
OrderID= 10741
OrderDate= 11/14/1997 12:00:00 AM
OrderID= 10743
OrderDate= 11/17/1997 12:00:00 AM
Month= 12
OrderID= 10768
OrderDate= 12/8/1997 12:00:00 AM
OrderID= 10793
OrderDate= 12/24/1997 12:00:00 AM
Year= 1998
Month= 2
OrderID= 10864
OrderDate= 2/2/1998 12:00:00 AM
Month= 3
OrderID= 10920
OrderDate= 3/3/1998 12:00:00 AM
OrderID= 10953
OrderDate= 3/16/1998 12:00:00 AM
Month= 4
OrderID= 11016
OrderDate= 4/10/1998 12:00:00 AM
CompanyName= Berglunds snabbköp
Year= 1996
Month= 8
OrderID= 10278
OrderDate= 8/12/1996 12:00:00 AM
OrderID= 10280
OrderDate= 8/14/1996 12:00:00 AM
Month= 12
OrderID= 10384
OrderDate= 12/16/1996 12:00:00 AM
Year= 1997
Month= 2
OrderID= 10444
OrderDate= 2/12/1997 12:00:00 AM
OrderID= 10445
OrderDate= 2/13/1997 12:00:00 AM
Month= 5
OrderID= 10524
OrderDate= 5/1/1997 12:00:00 AM
Month= 6
OrderID= 10572
OrderDate= 6/18/1997 12:00:00 AM
Month= 8
OrderID= 10626
OrderDate= 8/11/1997 12:00:00 AM
Month= 9
OrderID= 10654
OrderDate= 9/2/1997 12:00:00 AM
OrderID= 10672
OrderDate= 9/17/1997 12:00:00 AM
Month= 10
OrderID= 10689
OrderDate= 10/1/1997 12:00:00 AM
Month= 11
OrderID= 10733
OrderDate= 11/7/1997 12:00:00 AM
Month= 12
OrderID= 10778
OrderDate= 12/16/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10837
OrderDate= 1/16/1998 12:00:00 AM
OrderID= 10857
OrderDate= 1/28/1998 12:00:00 AM
Month= 2
OrderID= 10866
OrderDate= 2/3/1998 12:00:00 AM
OrderID= 10875
OrderDate= 2/6/1998 12:00:00 AM
Month= 3
OrderID= 10924
OrderDate= 3/4/1998 12:00:00 AM
CompanyName= Blauer See Delikatessen
Year= 1997
Month= 4
OrderID= 10501
OrderDate= 4/9/1997 12:00:00 AM
OrderID= 10509
OrderDate= 4/17/1997 12:00:00 AM
Month= 6
OrderID= 10582
OrderDate= 6/27/1997 12:00:00 AM
Month= 7
OrderID= 10614
OrderDate= 7/29/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10853
OrderDate= 1/27/1998 12:00:00 AM
Month= 3
OrderID= 10956
OrderDate= 3/17/1998 12:00:00 AM
Month= 4
OrderID= 11058
OrderDate= 4/29/1998 12:00:00 AM
CompanyName= Blondel père et fils
Year= 1996
Month= 7
OrderID= 10265
OrderDate= 7/25/1996 12:00:00 AM
Month= 9
OrderID= 10297
OrderDate= 9/4/1996 12:00:00 AM
Month= 11
OrderID= 10360
OrderDate= 11/22/1996 12:00:00 AM
Year= 1997
Month= 2
OrderID= 10436
OrderDate= 2/5/1997 12:00:00 AM
OrderID= 10449
OrderDate= 2/18/1997 12:00:00 AM
Month= 6
OrderID= 10559
OrderDate= 6/5/1997 12:00:00 AM
OrderID= 10566
OrderDate= 6/12/1997 12:00:00 AM
OrderID= 10584
OrderDate= 6/30/1997 12:00:00 AM
Month= 8
OrderID= 10628
OrderDate= 8/12/1997 12:00:00 AM
Month= 9
OrderID= 10679
OrderDate= 9/23/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10826
OrderDate= 1/12/1998 12:00:00 AM
CompanyName= Bólido Comidas preparadas
Year= 1996
Month= 10
OrderID= 10326
OrderDate= 10/10/1996 12:00:00 AM
Year= 1997
Month= 12
OrderID= 10801
OrderDate= 12/29/1997 12:00:00 AM
Year= 1998
Month= 3
OrderID= 10970
OrderDate= 3/24/1998 12:00:00 AM
CompanyName= Bon app'
Year= 1996
Month= 10
OrderID= 10331
OrderDate= 10/16/1996 12:00:00 AM
OrderID= 10340
OrderDate= 10/29/1996 12:00:00 AM
Month= 11
OrderID= 10362
OrderDate= 11/25/1996 12:00:00 AM
Year= 1997
Month= 3
OrderID= 10470
OrderDate= 3/11/1997 12:00:00 AM
Month= 4
OrderID= 10511
OrderDate= 4/18/1997 12:00:00 AM
Month= 5
OrderID= 10525
OrderDate= 5/2/1997 12:00:00 AM
Month= 9
OrderID= 10663
OrderDate= 9/10/1997 12:00:00 AM
Month= 10
OrderID= 10715
OrderDate= 10/23/1997 12:00:00 AM
Month= 11
OrderID= 10730
OrderDate= 11/5/1997 12:00:00 AM
OrderID= 10732
OrderDate= 11/6/1997 12:00:00 AM
OrderID= 10755
OrderDate= 11/26/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10827
OrderDate= 1/12/1998 12:00:00 AM
Month= 2
OrderID= 10871
OrderDate= 2/5/1998 12:00:00 AM
OrderID= 10876
OrderDate= 2/9/1998 12:00:00 AM
Month= 3
OrderID= 10932
OrderDate= 3/6/1998 12:00:00 AM
OrderID= 10940
OrderDate= 3/11/1998 12:00:00 AM
Month= 5
OrderID= 11076
OrderDate= 5/6/1998 12:00:00 AM
CompanyName= Bottom-Dollar Markets
Year= 1996
Month= 12
OrderID= 10389
OrderDate= 12/20/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10410
OrderDate= 1/10/1997 12:00:00 AM
OrderID= 10411
OrderDate= 1/10/1997 12:00:00 AM
OrderID= 10431
OrderDate= 1/30/1997 12:00:00 AM
Month= 4
OrderID= 10492
OrderDate= 4/1/1997 12:00:00 AM
Month= 11
OrderID= 10742
OrderDate= 11/14/1997 12:00:00 AM
Year= 1998
Month= 3
OrderID= 10918
OrderDate= 3/2/1998 12:00:00 AM
OrderID= 10944
OrderDate= 3/12/1998 12:00:00 AM
OrderID= 10949
OrderDate= 3/13/1998 12:00:00 AM
OrderID= 10975
OrderDate= 3/25/1998 12:00:00 AM
OrderID= 10982
OrderDate= 3/27/1998 12:00:00 AM
Month= 4
OrderID= 11027
OrderDate= 4/16/1998 12:00:00 AM
OrderID= 11045
OrderDate= 4/23/1998 12:00:00 AM
OrderID= 11048
OrderDate= 4/24/1998 12:00:00 AM
CompanyName= B's Beverages
Year= 1996
Month= 8
OrderID= 10289
OrderDate= 8/26/1996 12:00:00 AM
Year= 1997
Month= 3
OrderID= 10471
OrderDate= 3/11/1997 12:00:00 AM
OrderID= 10484
OrderDate= 3/24/1997 12:00:00 AM
Month= 5
OrderID= 10538
OrderDate= 5/15/1997 12:00:00 AM
OrderID= 10539
OrderDate= 5/16/1997 12:00:00 AM
Month= 6
OrderID= 10578
OrderDate= 6/24/1997 12:00:00 AM
Month= 7
OrderID= 10599
OrderDate= 7/15/1997 12:00:00 AM
Year= 1998
Month= 3
OrderID= 10943
OrderDate= 3/11/1998 12:00:00 AM
OrderID= 10947
OrderDate= 3/13/1998 12:00:00 AM
Month= 4
OrderID= 11023
OrderDate= 4/14/1998 12:00:00 AM
CompanyName= Cactus Comidas para llevar
Year= 1997
Month= 4
OrderID= 10521
OrderDate= 4/29/1997 12:00:00 AM
Month= 12
OrderID= 10782
OrderDate= 12/17/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10819
OrderDate= 1/7/1998 12:00:00 AM
Month= 2
OrderID= 10881
OrderDate= 2/11/1998 12:00:00 AM
Month= 3
OrderID= 10937
OrderDate= 3/10/1998 12:00:00 AM
Month= 4
OrderID= 11054
OrderDate= 4/28/1998 12:00:00 AM
CompanyName= Centro comercial Moctezuma
Year= 1996
Month= 7
OrderID= 10259
OrderDate= 7/18/1996 12:00:00 AM
CompanyName= Chop-suey Chinese
Year= 1996
Month= 7
OrderID= 10254
OrderDate= 7/11/1996 12:00:00 AM
Month= 12
OrderID= 10370
OrderDate= 12/3/1996 12:00:00 AM
Year= 1997
Month= 4
OrderID= 10519
OrderDate= 4/28/1997 12:00:00 AM
Month= 11
OrderID= 10731
OrderDate= 11/6/1997 12:00:00 AM
OrderID= 10746
OrderDate= 11/19/1997 12:00:00 AM
Year= 1998
Month= 3
OrderID= 10966
OrderDate= 3/20/1998 12:00:00 AM
Month= 4
OrderID= 11029
OrderDate= 4/16/1998 12:00:00 AM
OrderID= 11041
OrderDate= 4/22/1998 12:00:00 AM
CompanyName= Comércio Mineiro
Year= 1996
Month= 8
OrderID= 10290
OrderDate= 8/27/1996 12:00:00 AM
Year= 1997
Month= 3
OrderID= 10466
OrderDate= 3/6/1997 12:00:00 AM
Month= 4
OrderID= 10494
OrderDate= 4/2/1997 12:00:00 AM
Year= 1998
Month= 3
OrderID= 10969
OrderDate= 3/23/1998 12:00:00 AM
Month= 4
OrderID= 11042
OrderDate= 4/22/1998 12:00:00 AM
CompanyName= Consolidated Holdings
Year= 1997
Month= 2
OrderID= 10435
OrderDate= 2/4/1997 12:00:00 AM
Month= 3
OrderID= 10462
OrderDate= 3/3/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10848
OrderDate= 1/23/1998 12:00:00 AM
CompanyName= Drachenblut Delikatessen
Year= 1996
Month= 11
OrderID= 10363
OrderDate= 11/26/1996 12:00:00 AM
Month= 12
OrderID= 10391
OrderDate= 12/23/1996 12:00:00 AM
Year= 1997
Month= 12
OrderID= 10797
OrderDate= 12/25/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10825
OrderDate= 1/9/1998 12:00:00 AM
Month= 4
OrderID= 11036
OrderDate= 4/20/1998 12:00:00 AM
Month= 5
OrderID= 11067
OrderDate= 5/4/1998 12:00:00 AM
CompanyName= Du monde entier
Year= 1996
Month= 9
OrderID= 10311
OrderDate= 9/20/1996 12:00:00 AM
Year= 1997
Month= 7
OrderID= 10609
OrderDate= 7/24/1997 12:00:00 AM
Month= 9
OrderID= 10683
OrderDate= 9/26/1997 12:00:00 AM
Year= 1998
Month= 2
OrderID= 10890
OrderDate= 2/16/1998 12:00:00 AM
CompanyName= Eastern Connection
Year= 1996
Month= 11
OrderID= 10364
OrderDate= 11/26/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10400
OrderDate= 1/1/1997 12:00:00 AM
Month= 5
OrderID= 10532
OrderDate= 5/9/1997 12:00:00 AM
Month= 11
OrderID= 10726
OrderDate= 11/3/1997 12:00:00 AM
Year= 1998
Month= 3
OrderID= 10987
OrderDate= 3/31/1998 12:00:00 AM
Month= 4
OrderID= 11024
OrderDate= 4/15/1998 12:00:00 AM
OrderID= 11047
OrderDate= 4/24/1998 12:00:00 AM
OrderID= 11056
OrderDate= 4/28/1998 12:00:00 AM
CompanyName= Ernst Handel
Year= 1996
Month= 7
OrderID= 10258
OrderDate= 7/17/1996 12:00:00 AM
OrderID= 10263
OrderDate= 7/23/1996 12:00:00 AM
Month= 11
OrderID= 10351
OrderDate= 11/11/1996 12:00:00 AM
OrderID= 10368
OrderDate= 11/29/1996 12:00:00 AM
Month= 12
OrderID= 10382
OrderDate= 12/13/1996 12:00:00 AM
OrderID= 10390
OrderDate= 12/23/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10402
OrderDate= 1/2/1997 12:00:00 AM
OrderID= 10403
OrderDate= 1/3/1997 12:00:00 AM
OrderID= 10430
OrderDate= 1/30/1997 12:00:00 AM
Month= 2
OrderID= 10442
OrderDate= 2/11/1997 12:00:00 AM
Month= 4
OrderID= 10514
OrderDate= 4/22/1997 12:00:00 AM
Month= 6
OrderID= 10571
OrderDate= 6/17/1997 12:00:00 AM
Month= 7
OrderID= 10595
OrderDate= 7/10/1997 12:00:00 AM
Month= 8
OrderID= 10633
OrderDate= 8/15/1997 12:00:00 AM
Month= 9
OrderID= 10667
OrderDate= 9/12/1997 12:00:00 AM
Month= 10
OrderID= 10698
OrderDate= 10/9/1997 12:00:00 AM
Month= 12
OrderID= 10764
OrderDate= 12/3/1997 12:00:00 AM
OrderID= 10771
OrderDate= 12/10/1997 12:00:00 AM
OrderID= 10773
OrderDate= 12/11/1997 12:00:00 AM
OrderID= 10776
OrderDate= 12/15/1997 12:00:00 AM
OrderID= 10795
OrderDate= 12/24/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10836
OrderDate= 1/16/1998 12:00:00 AM
OrderID= 10854
OrderDate= 1/27/1998 12:00:00 AM
Month= 2
OrderID= 10895
OrderDate= 2/18/1998 12:00:00 AM
Month= 3
OrderID= 10968
OrderDate= 3/23/1998 12:00:00 AM
OrderID= 10979
OrderDate= 3/26/1998 12:00:00 AM
Month= 4
OrderID= 10990
OrderDate= 4/1/1998 12:00:00 AM
OrderID= 11008
OrderDate= 4/8/1998 12:00:00 AM
OrderID= 11017
OrderDate= 4/13/1998 12:00:00 AM
Month= 5
OrderID= 11072
OrderDate= 5/5/1998 12:00:00 AM
CompanyName= Familia Arquibaldo
Year= 1996
Month= 11
OrderID= 10347
OrderDate= 11/6/1996 12:00:00 AM
Month= 12
OrderID= 10386
OrderDate= 12/18/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10414
OrderDate= 1/14/1997 12:00:00 AM
Month= 4
OrderID= 10512
OrderDate= 4/21/1997 12:00:00 AM
Month= 6
OrderID= 10581
OrderDate= 6/26/1997 12:00:00 AM
Month= 8
OrderID= 10650
OrderDate= 8/29/1997 12:00:00 AM
Month= 10
OrderID= 10725
OrderDate= 10/31/1997 12:00:00 AM
CompanyName= FISSA Fabrica Inter. Salchichas S.A.
CompanyName= Folies gourmandes
Year= 1997
Month= 1
OrderID= 10408
OrderDate= 1/8/1997 12:00:00 AM
Month= 3
OrderID= 10480
OrderDate= 3/20/1997 12:00:00 AM
Month= 8
OrderID= 10634
OrderDate= 8/15/1997 12:00:00 AM
Month= 12
OrderID= 10763
OrderDate= 12/3/1997 12:00:00 AM
OrderID= 10789
OrderDate= 12/22/1997 12:00:00 AM
CompanyName= Folk och fä HB
Year= 1996
Month= 7
OrderID= 10264
OrderDate= 7/24/1996 12:00:00 AM
Month= 10
OrderID= 10327
OrderDate= 10/11/1996 12:00:00 AM
Month= 12
OrderID= 10378
OrderDate= 12/10/1996 12:00:00 AM
Year= 1997
Month= 2
OrderID= 10434
OrderDate= 2/3/1997 12:00:00 AM
OrderID= 10460
OrderDate= 2/28/1997 12:00:00 AM
Month= 5
OrderID= 10533
OrderDate= 5/12/1997 12:00:00 AM
Month= 6
OrderID= 10561
OrderDate= 6/6/1997 12:00:00 AM
Month= 10
OrderID= 10703
OrderDate= 10/14/1997 12:00:00 AM
Month= 12
OrderID= 10762
OrderDate= 12/2/1997 12:00:00 AM
OrderID= 10774
OrderDate= 12/11/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10824
OrderDate= 1/9/1998 12:00:00 AM
Month= 2
OrderID= 10880
OrderDate= 2/10/1998 12:00:00 AM
OrderID= 10902
OrderDate= 2/23/1998 12:00:00 AM
Month= 3
OrderID= 10955
OrderDate= 3/17/1998 12:00:00 AM
OrderID= 10977
OrderDate= 3/26/1998 12:00:00 AM
OrderID= 10980
OrderDate= 3/27/1998 12:00:00 AM
Month= 4
OrderID= 10993
OrderDate= 4/1/1998 12:00:00 AM
OrderID= 11001
OrderDate= 4/6/1998 12:00:00 AM
OrderID= 11050
OrderDate= 4/27/1998 12:00:00 AM
CompanyName= Frankenversand
Year= 1996
Month= 7
OrderID= 10267
OrderDate= 7/29/1996 12:00:00 AM
Month= 10
OrderID= 10337
OrderDate= 10/24/1996 12:00:00 AM
OrderID= 10342
OrderDate= 10/30/1996 12:00:00 AM
Month= 12
OrderID= 10396
OrderDate= 12/27/1996 12:00:00 AM
Year= 1997
Month= 3
OrderID= 10488
OrderDate= 3/27/1997 12:00:00 AM
Month= 6
OrderID= 10560
OrderDate= 6/6/1997 12:00:00 AM
Month= 8
OrderID= 10623
OrderDate= 8/7/1997 12:00:00 AM
Month= 9
OrderID= 10653
OrderDate= 9/2/1997 12:00:00 AM
OrderID= 10670
OrderDate= 9/16/1997 12:00:00 AM
OrderID= 10675
OrderDate= 9/19/1997 12:00:00 AM
Month= 10
OrderID= 10717
OrderDate= 10/24/1997 12:00:00 AM
Month= 12
OrderID= 10791
OrderDate= 12/23/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10859
OrderDate= 1/29/1998 12:00:00 AM
Month= 3
OrderID= 10929
OrderDate= 3/5/1998 12:00:00 AM
Month= 4
OrderID= 11012
OrderDate= 4/9/1998 12:00:00 AM
CompanyName= France restauration
Year= 1997
Month= 9
OrderID= 10671
OrderDate= 9/17/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10860
OrderDate= 1/29/1998 12:00:00 AM
Month= 3
OrderID= 10971
OrderDate= 3/24/1998 12:00:00 AM
CompanyName= Franchi S.p.A.
Year= 1997
Month= 1
OrderID= 10422
OrderDate= 1/22/1997 12:00:00 AM
Month= 10
OrderID= 10710
OrderDate= 10/20/1997 12:00:00 AM
Month= 11
OrderID= 10753
OrderDate= 11/25/1997 12:00:00 AM
Month= 12
OrderID= 10807
OrderDate= 12/31/1997 12:00:00 AM
Year= 1998
Month= 4
OrderID= 11026
OrderDate= 4/15/1998 12:00:00 AM
OrderID= 11060
OrderDate= 4/30/1998 12:00:00 AM
CompanyName= Furia Bacalhau e Frutos do Mar
Year= 1996
Month= 10
OrderID= 10328
OrderDate= 10/14/1996 12:00:00 AM
Month= 11
OrderID= 10352
OrderDate= 11/12/1996 12:00:00 AM
Year= 1997
Month= 3
OrderID= 10464
OrderDate= 3/4/1997 12:00:00 AM
OrderID= 10491
OrderDate= 3/31/1997 12:00:00 AM
Month= 5
OrderID= 10551
OrderDate= 5/28/1997 12:00:00 AM
Month= 7
OrderID= 10604
OrderDate= 7/18/1997 12:00:00 AM
Month= 9
OrderID= 10664
OrderDate= 9/10/1997 12:00:00 AM
Year= 1998
Month= 3
OrderID= 10963
OrderDate= 3/19/1998 12:00:00 AM
CompanyName= Galería del gastrónomo
Year= 1996
Month= 11
OrderID= 10366
OrderDate= 11/28/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10426
OrderDate= 1/27/1997 12:00:00 AM
Month= 6
OrderID= 10568
OrderDate= 6/13/1997 12:00:00 AM
Year= 1998
Month= 2
OrderID= 10887
OrderDate= 2/13/1998 12:00:00 AM
Month= 3
OrderID= 10928
OrderDate= 3/5/1998 12:00:00 AM
CompanyName= Godos Cocina Típica
Year= 1996
Month= 9
OrderID= 10303
OrderDate= 9/11/1996 12:00:00 AM
Year= 1997
Month= 5
OrderID= 10550
OrderDate= 5/28/1997 12:00:00 AM
Month= 8
OrderID= 10629
OrderDate= 8/12/1997 12:00:00 AM
Year= 1998
Month= 2
OrderID= 10872
OrderDate= 2/5/1998 12:00:00 AM
OrderID= 10874
OrderDate= 2/6/1998 12:00:00 AM
OrderID= 10888
OrderDate= 2/16/1998 12:00:00 AM
OrderID= 10911
OrderDate= 2/26/1998 12:00:00 AM
Month= 3
OrderID= 10948
OrderDate= 3/13/1998 12:00:00 AM
Month= 4
OrderID= 11009
OrderDate= 4/8/1998 12:00:00 AM
OrderID= 11037
OrderDate= 4/21/1998 12:00:00 AM
CompanyName= Gourmet Lanchonetes
Year= 1997
Month= 1
OrderID= 10423
OrderDate= 1/23/1997 12:00:00 AM
Month= 9
OrderID= 10652
OrderDate= 9/1/1997 12:00:00 AM
OrderID= 10685
OrderDate= 9/29/1997 12:00:00 AM
Month= 10
OrderID= 10709
OrderDate= 10/17/1997 12:00:00 AM
Month= 11
OrderID= 10734
OrderDate= 11/7/1997 12:00:00 AM
Month= 12
OrderID= 10777
OrderDate= 12/15/1997 12:00:00 AM
OrderID= 10790
OrderDate= 12/22/1997 12:00:00 AM
Year= 1998
Month= 3
OrderID= 10959
OrderDate= 3/18/1998 12:00:00 AM
Month= 4
OrderID= 11049
OrderDate= 4/24/1998 12:00:00 AM
CompanyName= Great Lakes Food Market
Year= 1997
Month= 5
OrderID= 10528
OrderDate= 5/6/1997 12:00:00 AM
Month= 7
OrderID= 10589
OrderDate= 7/4/1997 12:00:00 AM
OrderID= 10616
OrderDate= 7/31/1997 12:00:00 AM
OrderID= 10617
OrderDate= 7/31/1997 12:00:00 AM
Month= 9
OrderID= 10656
OrderDate= 9/4/1997 12:00:00 AM
OrderID= 10681
OrderDate= 9/25/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10816
OrderDate= 1/6/1998 12:00:00 AM
Month= 3
OrderID= 10936
OrderDate= 3/9/1998 12:00:00 AM
Month= 4
OrderID= 11006
OrderDate= 4/7/1998 12:00:00 AM
OrderID= 11040
OrderDate= 4/22/1998 12:00:00 AM
OrderID= 11061
OrderDate= 4/30/1998 12:00:00 AM
CompanyName= GROSELLA-Restaurante
Year= 1996
Month= 7
OrderID= 10268
OrderDate= 7/30/1996 12:00:00 AM
Year= 1997
Month= 12
OrderID= 10785
OrderDate= 12/18/1997 12:00:00 AM
CompanyName= Hanari Carnes
Year= 1996
Month= 7
OrderID= 10250
OrderDate= 7/8/1996 12:00:00 AM
OrderID= 10253
OrderDate= 7/10/1996 12:00:00 AM
Year= 1997
Month= 5
OrderID= 10541
OrderDate= 5/19/1997 12:00:00 AM
Month= 8
OrderID= 10645
OrderDate= 8/26/1997 12:00:00 AM
Month= 10
OrderID= 10690
OrderDate= 10/2/1997 12:00:00 AM
Month= 12
OrderID= 10770
OrderDate= 12/9/1997 12:00:00 AM
OrderID= 10783
OrderDate= 12/18/1997 12:00:00 AM
Year= 1998
Month= 2
OrderID= 10886
OrderDate= 2/13/1998 12:00:00 AM
OrderID= 10903
OrderDate= 2/24/1998 12:00:00 AM
Month= 3
OrderID= 10922
OrderDate= 3/3/1998 12:00:00 AM
OrderID= 10925
OrderDate= 3/4/1998 12:00:00 AM
OrderID= 10981
OrderDate= 3/27/1998 12:00:00 AM
Month= 4
OrderID= 11022
OrderDate= 4/14/1998 12:00:00 AM
OrderID= 11052
OrderDate= 4/27/1998 12:00:00 AM
CompanyName= HILARIÓN-Abastos
Year= 1996
Month= 7
OrderID= 10257
OrderDate= 7/16/1996 12:00:00 AM
Month= 12
OrderID= 10395
OrderDate= 12/26/1996 12:00:00 AM
Year= 1997
Month= 3
OrderID= 10476
OrderDate= 3/17/1997 12:00:00 AM
OrderID= 10486
OrderDate= 3/26/1997 12:00:00 AM
OrderID= 10490
OrderDate= 3/31/1997 12:00:00 AM
Month= 4
OrderID= 10498
OrderDate= 4/7/1997 12:00:00 AM
Month= 5
OrderID= 10552
OrderDate= 5/29/1997 12:00:00 AM
Month= 7
OrderID= 10601
OrderDate= 7/16/1997 12:00:00 AM
OrderID= 10613
OrderDate= 7/29/1997 12:00:00 AM
Month= 8
OrderID= 10641
OrderDate= 8/22/1997 12:00:00 AM
Month= 10
OrderID= 10705
OrderDate= 10/15/1997 12:00:00 AM
Month= 12
OrderID= 10796
OrderDate= 12/25/1997 12:00:00 AM
Year= 1998
Month= 2
OrderID= 10863
OrderDate= 2/2/1998 12:00:00 AM
OrderID= 10901
OrderDate= 2/23/1998 12:00:00 AM
Month= 3
OrderID= 10957
OrderDate= 3/18/1998 12:00:00 AM
OrderID= 10960
OrderDate= 3/19/1998 12:00:00 AM
OrderID= 10976
OrderDate= 3/25/1998 12:00:00 AM
Month= 4
OrderID= 11055
OrderDate= 4/28/1998 12:00:00 AM
CompanyName= Hungry Coyote Import Store
Year= 1996
Month= 12
OrderID= 10375
OrderDate= 12/6/1996 12:00:00 AM
OrderID= 10394
OrderDate= 12/25/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10415
OrderDate= 1/15/1997 12:00:00 AM
Month= 7
OrderID= 10600
OrderDate= 7/16/1997 12:00:00 AM
Month= 9
OrderID= 10660
OrderDate= 9/8/1997 12:00:00 AM
CompanyName= Hungry Owl All-Night Grocers
Year= 1996
Month= 9
OrderID= 10298
OrderDate= 9/5/1996 12:00:00 AM
OrderID= 10309
OrderDate= 9/19/1996 12:00:00 AM
Month= 10
OrderID= 10335
OrderDate= 10/22/1996 12:00:00 AM
Month= 12
OrderID= 10373
OrderDate= 12/5/1996 12:00:00 AM
OrderID= 10380
OrderDate= 12/12/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10429
OrderDate= 1/29/1997 12:00:00 AM
Month= 4
OrderID= 10503
OrderDate= 4/11/1997 12:00:00 AM
OrderID= 10516
OrderDate= 4/24/1997 12:00:00 AM
Month= 6
OrderID= 10567
OrderDate= 6/12/1997 12:00:00 AM
Month= 8
OrderID= 10646
OrderDate= 8/27/1997 12:00:00 AM
Month= 9
OrderID= 10661
OrderDate= 9/9/1997 12:00:00 AM
OrderID= 10687
OrderDate= 9/30/1997 12:00:00 AM
Month= 10
OrderID= 10701
OrderDate= 10/13/1997 12:00:00 AM
OrderID= 10712
OrderDate= 10/21/1997 12:00:00 AM
Month= 11
OrderID= 10736
OrderDate= 11/11/1997 12:00:00 AM
Year= 1998
Month= 2
OrderID= 10897
OrderDate= 2/19/1998 12:00:00 AM
OrderID= 10912
OrderDate= 2/26/1998 12:00:00 AM
Month= 3
OrderID= 10985
OrderDate= 3/30/1998 12:00:00 AM
Month= 4
OrderID= 11063
OrderDate= 4/30/1998 12:00:00 AM
CompanyName= Island Trading
Year= 1996
Month= 9
OrderID= 10315
OrderDate= 9/26/1996 12:00:00 AM
Month= 10
OrderID= 10318
OrderDate= 10/1/1996 12:00:00 AM
OrderID= 10321
OrderDate= 10/3/1996 12:00:00 AM
Year= 1997
Month= 3
OrderID= 10473
OrderDate= 3/13/1997 12:00:00 AM
Month= 8
OrderID= 10621
OrderDate= 8/5/1997 12:00:00 AM
Month= 9
OrderID= 10674
OrderDate= 9/18/1997 12:00:00 AM
Month= 11
OrderID= 10749
OrderDate= 11/20/1997 12:00:00 AM
Month= 12
OrderID= 10798
OrderDate= 12/26/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10829
OrderDate= 1/13/1998 12:00:00 AM
Month= 3
OrderID= 10933
OrderDate= 3/6/1998 12:00:00 AM
CompanyName= Königlich Essen
Year= 1996
Month= 10
OrderID= 10323
OrderDate= 10/7/1996 12:00:00 AM
OrderID= 10325
OrderDate= 10/9/1996 12:00:00 AM
Year= 1997
Month= 2
OrderID= 10456
OrderDate= 2/25/1997 12:00:00 AM
OrderID= 10457
OrderDate= 2/25/1997 12:00:00 AM
Month= 3
OrderID= 10468
OrderDate= 3/7/1997 12:00:00 AM
Month= 4
OrderID= 10506
OrderDate= 4/15/1997 12:00:00 AM
Month= 5
OrderID= 10542
OrderDate= 5/20/1997 12:00:00 AM
Month= 8
OrderID= 10630
OrderDate= 8/13/1997 12:00:00 AM
Month= 10
OrderID= 10718
OrderDate= 10/27/1997 12:00:00 AM
Month= 12
OrderID= 10799
OrderDate= 12/26/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10817
OrderDate= 1/6/1998 12:00:00 AM
OrderID= 10849
OrderDate= 1/23/1998 12:00:00 AM
Month= 2
OrderID= 10893
OrderDate= 2/18/1998 12:00:00 AM
Month= 4
OrderID= 11028
OrderDate= 4/16/1998 12:00:00 AM
CompanyName= La corne d'abondance
Year= 1998
Month= 1
OrderID= 10858
OrderDate= 1/29/1998 12:00:00 AM
Month= 3
OrderID= 10927
OrderDate= 3/5/1998 12:00:00 AM
OrderID= 10972
OrderDate= 3/24/1998 12:00:00 AM
OrderID= 10973
OrderDate= 3/24/1998 12:00:00 AM
CompanyName= La maison d'Asie
Year= 1996
Month= 11
OrderID= 10350
OrderDate= 11/11/1996 12:00:00 AM
OrderID= 10358
OrderDate= 11/20/1996 12:00:00 AM
Month= 12
OrderID= 10371
OrderDate= 12/3/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10413
OrderDate= 1/14/1997 12:00:00 AM
OrderID= 10425
OrderDate= 1/24/1997 12:00:00 AM
Month= 2
OrderID= 10454
OrderDate= 2/21/1997 12:00:00 AM
Month= 4
OrderID= 10493
OrderDate= 4/2/1997 12:00:00 AM
OrderID= 10500
OrderDate= 4/9/1997 12:00:00 AM
Month= 7
OrderID= 10610
OrderDate= 7/25/1997 12:00:00 AM
Month= 8
OrderID= 10631
OrderDate= 8/14/1997 12:00:00 AM
Month= 12
OrderID= 10787
OrderDate= 12/19/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10832
OrderDate= 1/14/1998 12:00:00 AM
Month= 3
OrderID= 10923
OrderDate= 3/3/1998 12:00:00 AM
Month= 4
OrderID= 11051
OrderDate= 4/27/1998 12:00:00 AM
CompanyName= Laughing Bacchus Wine Cellars
Year= 1997
Month= 4
OrderID= 10495
OrderDate= 4/3/1997 12:00:00 AM
Month= 8
OrderID= 10620
OrderDate= 8/5/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10810
OrderDate= 1/1/1998 12:00:00 AM
CompanyName= Lazy K Kountry Store
Year= 1997
Month= 3
OrderID= 10482
OrderDate= 3/21/1997 12:00:00 AM
Month= 5
OrderID= 10545
OrderDate= 5/22/1997 12:00:00 AM
CompanyName= Lehmanns Marktstand
Year= 1996
Month= 8
OrderID= 10279
OrderDate= 8/13/1996 12:00:00 AM
OrderID= 10284
OrderDate= 8/19/1996 12:00:00 AM
Month= 10
OrderID= 10343
OrderDate= 10/31/1996 12:00:00 AM
Year= 1997
Month= 4
OrderID= 10497
OrderDate= 4/4/1997 12:00:00 AM
OrderID= 10522
OrderDate= 4/30/1997 12:00:00 AM
Month= 5
OrderID= 10534
OrderDate= 5/12/1997 12:00:00 AM
OrderID= 10536
OrderDate= 5/14/1997 12:00:00 AM
Month= 6
OrderID= 10557
OrderDate= 6/3/1997 12:00:00 AM
Month= 7
OrderID= 10592
OrderDate= 7/8/1997 12:00:00 AM
OrderID= 10593
OrderDate= 7/9/1997 12:00:00 AM
Month= 12
OrderID= 10772
OrderDate= 12/10/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10862
OrderDate= 1/30/1998 12:00:00 AM
Month= 2
OrderID= 10891
OrderDate= 2/17/1998 12:00:00 AM
Month= 3
OrderID= 10934
OrderDate= 3/9/1998 12:00:00 AM
Month= 5
OrderID= 11070
OrderDate= 5/5/1998 12:00:00 AM
CompanyName= Let's Stop N Shop
Year= 1997
Month= 6
OrderID= 10579
OrderDate= 6/25/1997 12:00:00 AM
Month= 10
OrderID= 10719
OrderDate= 10/27/1997 12:00:00 AM
Month= 11
OrderID= 10735
OrderDate= 11/10/1997 12:00:00 AM
Year= 1998
Month= 2
OrderID= 10884
OrderDate= 2/12/1998 12:00:00 AM
CompanyName= LILA-Supermercado
Year= 1996
Month= 8
OrderID= 10283
OrderDate= 8/16/1996 12:00:00 AM
Month= 9
OrderID= 10296
OrderDate= 9/3/1996 12:00:00 AM
Month= 10
OrderID= 10330
OrderDate= 10/16/1996 12:00:00 AM
Month= 11
OrderID= 10357
OrderDate= 11/19/1996 12:00:00 AM
Month= 12
OrderID= 10381
OrderDate= 12/12/1996 12:00:00 AM
Year= 1997
Month= 2
OrderID= 10461
OrderDate= 2/28/1997 12:00:00 AM
Month= 4
OrderID= 10499
OrderDate= 4/8/1997 12:00:00 AM
Month= 5
OrderID= 10543
OrderDate= 5/21/1997 12:00:00 AM
Month= 12
OrderID= 10780
OrderDate= 12/16/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10823
OrderDate= 1/9/1998 12:00:00 AM
Month= 2
OrderID= 10899
OrderDate= 2/20/1998 12:00:00 AM
Month= 4
OrderID= 10997
OrderDate= 4/3/1998 12:00:00 AM
Month= 5
OrderID= 11065
OrderDate= 5/1/1998 12:00:00 AM
OrderID= 11071
OrderDate= 5/5/1998 12:00:00 AM
CompanyName= LINO-Delicateses
Year= 1997
Month= 1
OrderID= 10405
OrderDate= 1/6/1997 12:00:00 AM
Month= 3
OrderID= 10485
OrderDate= 3/25/1997 12:00:00 AM
Month= 8
OrderID= 10638
OrderDate= 8/20/1997 12:00:00 AM
Month= 10
OrderID= 10697
OrderDate= 10/8/1997 12:00:00 AM
Month= 11
OrderID= 10729
OrderDate= 11/4/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10811
OrderDate= 1/2/1998 12:00:00 AM
OrderID= 10838
OrderDate= 1/19/1998 12:00:00 AM
OrderID= 10840
OrderDate= 1/19/1998 12:00:00 AM
Month= 3
OrderID= 10919
OrderDate= 3/2/1998 12:00:00 AM
OrderID= 10954
OrderDate= 3/17/1998 12:00:00 AM
Month= 4
OrderID= 11014
OrderDate= 4/10/1998 12:00:00 AM
OrderID= 11039
OrderDate= 4/21/1998 12:00:00 AM
CompanyName= Lonesome Pine Restaurant
Year= 1996
Month= 9
OrderID= 10307
OrderDate= 9/17/1996 12:00:00 AM
OrderID= 10317
OrderDate= 9/30/1996 12:00:00 AM
Year= 1997
Month= 5
OrderID= 10544
OrderDate= 5/21/1997 12:00:00 AM
Month= 9
OrderID= 10662
OrderDate= 9/9/1997 12:00:00 AM
OrderID= 10665
OrderDate= 9/11/1997 12:00:00 AM
Year= 1998
Month= 2
OrderID= 10867
OrderDate= 2/3/1998 12:00:00 AM
OrderID= 10883
OrderDate= 2/12/1998 12:00:00 AM
Month= 4
OrderID= 11018
OrderDate= 4/13/1998 12:00:00 AM
CompanyName= Magazzini Alimentari Riuniti
Year= 1996
Month= 8
OrderID= 10275
OrderDate= 8/7/1996 12:00:00 AM
Month= 9
OrderID= 10300
OrderDate= 9/9/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10404
OrderDate= 1/3/1997 12:00:00 AM
Month= 3
OrderID= 10467
OrderDate= 3/6/1997 12:00:00 AM
Month= 8
OrderID= 10635
OrderDate= 8/18/1997 12:00:00 AM
Month= 11
OrderID= 10754
OrderDate= 11/25/1997 12:00:00 AM
Month= 12
OrderID= 10784
OrderDate= 12/18/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10818
OrderDate= 1/7/1998 12:00:00 AM
Month= 3
OrderID= 10939
OrderDate= 3/10/1998 12:00:00 AM
OrderID= 10950
OrderDate= 3/16/1998 12:00:00 AM
CompanyName= Maison Dewey
Year= 1997
Month= 5
OrderID= 10529
OrderDate= 5/7/1997 12:00:00 AM
Month= 8
OrderID= 10649
OrderDate= 8/28/1997 12:00:00 AM
Month= 12
OrderID= 10760
OrderDate= 12/1/1997 12:00:00 AM
Year= 1998
Month= 2
OrderID= 10892
OrderDate= 2/17/1998 12:00:00 AM
OrderID= 10896
OrderDate= 2/19/1998 12:00:00 AM
Month= 3
OrderID= 10978
OrderDate= 3/26/1998 12:00:00 AM
Month= 4
OrderID= 11004
OrderDate= 4/7/1998 12:00:00 AM
CompanyName= Mère Paillarde
Year= 1996
Month= 10
OrderID= 10332
OrderDate= 10/17/1996 12:00:00 AM
OrderID= 10339
OrderDate= 10/28/1996 12:00:00 AM
Month= 12
OrderID= 10376
OrderDate= 12/9/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10424
OrderDate= 1/23/1997 12:00:00 AM
Month= 2
OrderID= 10439
OrderDate= 2/7/1997 12:00:00 AM
Month= 4
OrderID= 10505
OrderDate= 4/14/1997 12:00:00 AM
Month= 6
OrderID= 10565
OrderDate= 6/11/1997 12:00:00 AM
OrderID= 10570
OrderDate= 6/17/1997 12:00:00 AM
Month= 7
OrderID= 10590
OrderDate= 7/7/1997 12:00:00 AM
OrderID= 10605
OrderDate= 7/21/1997 12:00:00 AM
Month= 8
OrderID= 10618
OrderDate= 8/1/1997 12:00:00 AM
OrderID= 10619
OrderDate= 8/4/1997 12:00:00 AM
Month= 10
OrderID= 10724
OrderDate= 10/30/1997 12:00:00 AM
CompanyName= Morgenstern Gesundkost
Year= 1996
Month= 8
OrderID= 10277
OrderDate= 8/9/1996 12:00:00 AM
Year= 1997
Month= 6
OrderID= 10575
OrderDate= 6/20/1997 12:00:00 AM
Month= 10
OrderID= 10699
OrderDate= 10/9/1997 12:00:00 AM
Month= 12
OrderID= 10779
OrderDate= 12/16/1997 12:00:00 AM
Year= 1998
Month= 3
OrderID= 10945
OrderDate= 3/12/1998 12:00:00 AM
CompanyName= North/South
Year= 1997
Month= 4
OrderID= 10517
OrderDate= 4/24/1997 12:00:00 AM
Month= 11
OrderID= 10752
OrderDate= 11/24/1997 12:00:00 AM
Year= 1998
Month= 4
OrderID= 11057
OrderDate= 4/29/1998 12:00:00 AM
CompanyName= Océano Atlántico Ltda.
Year= 1997
Month= 1
OrderID= 10409
OrderDate= 1/9/1997 12:00:00 AM
Month= 5
OrderID= 10531
OrderDate= 5/8/1997 12:00:00 AM
Year= 1998
Month= 2
OrderID= 10898
OrderDate= 2/20/1998 12:00:00 AM
Month= 3
OrderID= 10958
OrderDate= 3/18/1998 12:00:00 AM
OrderID= 10986
OrderDate= 3/30/1998 12:00:00 AM
CompanyName= Old World Delicatessen
Year= 1996
Month= 7
OrderID= 10260
OrderDate= 7/19/1996 12:00:00 AM
Month= 9
OrderID= 10305
OrderDate= 9/13/1996 12:00:00 AM
Month= 10
OrderID= 10338
OrderDate= 10/25/1996 12:00:00 AM
Year= 1997
Month= 2
OrderID= 10441
OrderDate= 2/10/1997 12:00:00 AM
Month= 7
OrderID= 10594
OrderDate= 7/9/1997 12:00:00 AM
Month= 9
OrderID= 10680
OrderDate= 9/24/1997 12:00:00 AM
Month= 10
OrderID= 10706
OrderDate= 10/16/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10855
OrderDate= 1/27/1998 12:00:00 AM
Month= 3
OrderID= 10965
OrderDate= 3/20/1998 12:00:00 AM
Month= 4
OrderID= 11034
OrderDate= 4/20/1998 12:00:00 AM
CompanyName= Ottilies Käseladen
Year= 1997
Month= 1
OrderID= 10407
OrderDate= 1/7/1997 12:00:00 AM
Month= 4
OrderID= 10508
OrderDate= 4/16/1997 12:00:00 AM
Month= 5
OrderID= 10554
OrderDate= 5/30/1997 12:00:00 AM
Month= 6
OrderID= 10580
OrderDate= 6/26/1997 12:00:00 AM
Month= 9
OrderID= 10684
OrderDate= 9/26/1997 12:00:00 AM
Month= 12
OrderID= 10766
OrderDate= 12/5/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10833
OrderDate= 1/15/1998 12:00:00 AM
Month= 4
OrderID= 10999
OrderDate= 4/3/1998 12:00:00 AM
OrderID= 11020
OrderDate= 4/14/1998 12:00:00 AM
CompanyName= Paris spécialités
CompanyName= Pericles Comidas clásicas
Year= 1996
Month= 10
OrderID= 10322
OrderDate= 10/4/1996 12:00:00 AM
Month= 11
OrderID= 10354
OrderDate= 11/14/1996 12:00:00 AM
Year= 1997
Month= 3
OrderID= 10474
OrderDate= 3/13/1997 12:00:00 AM
Month= 4
OrderID= 10502
OrderDate= 4/10/1997 12:00:00 AM
Year= 1998
Month= 4
OrderID= 10995
OrderDate= 4/2/1998 12:00:00 AM
Month= 5
OrderID= 11073
OrderDate= 5/5/1998 12:00:00 AM
CompanyName= Piccolo und mehr
Year= 1996
Month= 11
OrderID= 10353
OrderDate= 11/13/1996 12:00:00 AM
Month= 12
OrderID= 10392
OrderDate= 12/24/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10427
OrderDate= 1/27/1997 12:00:00 AM
Month= 3
OrderID= 10489
OrderDate= 3/28/1997 12:00:00 AM
Month= 5
OrderID= 10530
OrderDate= 5/8/1997 12:00:00 AM
Month= 7
OrderID= 10597
OrderDate= 7/11/1997 12:00:00 AM
Month= 9
OrderID= 10686
OrderDate= 9/30/1997 12:00:00 AM
Month= 11
OrderID= 10747
OrderDate= 11/19/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10844
OrderDate= 1/21/1998 12:00:00 AM
Month= 4
OrderID= 11053
OrderDate= 4/27/1998 12:00:00 AM
CompanyName= Princesa Isabel Vinhos
Year= 1996
Month= 10
OrderID= 10336
OrderDate= 10/23/1996 12:00:00 AM
Month= 12
OrderID= 10397
OrderDate= 12/27/1996 12:00:00 AM
Year= 1997
Month= 2
OrderID= 10433
OrderDate= 2/3/1997 12:00:00 AM
Month= 3
OrderID= 10477
OrderDate= 3/17/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10808
OrderDate= 1/1/1998 12:00:00 AM
Month= 4
OrderID= 11007
OrderDate= 4/8/1998 12:00:00 AM
CompanyName= Que Delícia
Year= 1996
Month= 7
OrderID= 10261
OrderDate= 7/19/1996 12:00:00 AM
Month= 8
OrderID= 10291
OrderDate= 8/27/1996 12:00:00 AM
Month= 12
OrderID= 10379
OrderDate= 12/11/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10421
OrderDate= 1/21/1997 12:00:00 AM
Month= 7
OrderID= 10587
OrderDate= 7/2/1997 12:00:00 AM
Month= 8
OrderID= 10647
OrderDate= 8/27/1997 12:00:00 AM
Month= 10
OrderID= 10720
OrderDate= 10/28/1997 12:00:00 AM
Month= 12
OrderID= 10794
OrderDate= 12/24/1997 12:00:00 AM
Year= 1998
Month= 3
OrderID= 10989
OrderDate= 3/31/1998 12:00:00 AM
CompanyName= Queen Cozinha
Year= 1996
Month= 12
OrderID= 10372
OrderDate= 12/4/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10406
OrderDate= 1/7/1997 12:00:00 AM
Month= 3
OrderID= 10487
OrderDate= 3/26/1997 12:00:00 AM
Month= 8
OrderID= 10637
OrderDate= 8/19/1997 12:00:00 AM
Month= 9
OrderID= 10659
OrderDate= 9/5/1997 12:00:00 AM
Month= 10
OrderID= 10704
OrderDate= 10/14/1997 12:00:00 AM
Month= 11
OrderID= 10728
OrderDate= 11/4/1997 12:00:00 AM
Month= 12
OrderID= 10786
OrderDate= 12/19/1997 12:00:00 AM
Year= 1998
Month= 2
OrderID= 10868
OrderDate= 2/4/1998 12:00:00 AM
OrderID= 10913
OrderDate= 2/26/1998 12:00:00 AM
OrderID= 10914
OrderDate= 2/27/1998 12:00:00 AM
Month= 3
OrderID= 10961
OrderDate= 3/19/1998 12:00:00 AM
Month= 5
OrderID= 11068
OrderDate= 5/4/1998 12:00:00 AM
CompanyName= QUICK-Stop
Year= 1996
Month= 8
OrderID= 10273
OrderDate= 8/5/1996 12:00:00 AM
OrderID= 10285
OrderDate= 8/20/1996 12:00:00 AM
OrderID= 10286
OrderDate= 8/21/1996 12:00:00 AM
Month= 9
OrderID= 10313
OrderDate= 9/24/1996 12:00:00 AM
Month= 11
OrderID= 10345
OrderDate= 11/4/1996 12:00:00 AM
OrderID= 10361
OrderDate= 11/22/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10418
OrderDate= 1/17/1997 12:00:00 AM
Month= 2
OrderID= 10451
OrderDate= 2/19/1997 12:00:00 AM
Month= 4
OrderID= 10515
OrderDate= 4/23/1997 12:00:00 AM
Month= 5
OrderID= 10527
OrderDate= 5/5/1997 12:00:00 AM
OrderID= 10540
OrderDate= 5/19/1997 12:00:00 AM
OrderID= 10549
OrderDate= 5/27/1997 12:00:00 AM
Month= 7
OrderID= 10588
OrderDate= 7/3/1997 12:00:00 AM
Month= 9
OrderID= 10658
OrderDate= 9/5/1997 12:00:00 AM
Month= 10
OrderID= 10691
OrderDate= 10/3/1997 12:00:00 AM
OrderID= 10694
OrderDate= 10/6/1997 12:00:00 AM
OrderID= 10721
OrderDate= 10/29/1997 12:00:00 AM
Month= 11
OrderID= 10745
OrderDate= 11/18/1997 12:00:00 AM
Month= 12
OrderID= 10765
OrderDate= 12/4/1997 12:00:00 AM
OrderID= 10788
OrderDate= 12/22/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10845
OrderDate= 1/21/1998 12:00:00 AM
Month= 2
OrderID= 10865
OrderDate= 2/2/1998 12:00:00 AM
OrderID= 10878
OrderDate= 2/10/1998 12:00:00 AM
Month= 3
OrderID= 10938
OrderDate= 3/10/1998 12:00:00 AM
OrderID= 10962
OrderDate= 3/19/1998 12:00:00 AM
Month= 4
OrderID= 10991
OrderDate= 4/1/1998 12:00:00 AM
OrderID= 10996
OrderDate= 4/2/1998 12:00:00 AM
OrderID= 11021
OrderDate= 4/14/1998 12:00:00 AM
CompanyName= Rancho grande
Year= 1997
Month= 2
OrderID= 10448
OrderDate= 2/17/1997 12:00:00 AM
Month= 10
OrderID= 10716
OrderDate= 10/24/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10828
OrderDate= 1/13/1998 12:00:00 AM
Month= 2
OrderID= 10916
OrderDate= 2/27/1998 12:00:00 AM
Month= 4
OrderID= 11019
OrderDate= 4/13/1998 12:00:00 AM
CompanyName= Rattlesnake Canyon Grocery
Year= 1996
Month= 7
OrderID= 10262
OrderDate= 7/22/1996 12:00:00 AM
Month= 8
OrderID= 10272
OrderDate= 8/2/1996 12:00:00 AM
OrderID= 10294
OrderDate= 8/30/1996 12:00:00 AM
Month= 9
OrderID= 10314
OrderDate= 9/25/1996 12:00:00 AM
OrderID= 10316
OrderDate= 9/27/1996 12:00:00 AM
Month= 11
OrderID= 10346
OrderDate= 11/5/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10401
OrderDate= 1/1/1997 12:00:00 AM
Month= 3
OrderID= 10479
OrderDate= 3/19/1997 12:00:00 AM
Month= 6
OrderID= 10564
OrderDate= 6/10/1997 12:00:00 AM
OrderID= 10569
OrderDate= 6/16/1997 12:00:00 AM
Month= 7
OrderID= 10598
OrderDate= 7/14/1997 12:00:00 AM
Month= 12
OrderID= 10761
OrderDate= 12/2/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10820
OrderDate= 1/7/1998 12:00:00 AM
OrderID= 10852
OrderDate= 1/26/1998 12:00:00 AM
Month= 2
OrderID= 10889
OrderDate= 2/16/1998 12:00:00 AM
Month= 3
OrderID= 10988
OrderDate= 3/31/1998 12:00:00 AM
Month= 4
OrderID= 11000
OrderDate= 4/6/1998 12:00:00 AM
Month= 5
OrderID= 11077
OrderDate= 5/6/1998 12:00:00 AM
CompanyName= Reggiani Caseifici
Year= 1996
Month= 8
OrderID= 10288
OrderDate= 8/23/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10428
OrderDate= 1/28/1997 12:00:00 AM
Month= 2
OrderID= 10443
OrderDate= 2/12/1997 12:00:00 AM
Month= 6
OrderID= 10562
OrderDate= 6/9/1997 12:00:00 AM
Month= 7
OrderID= 10586
OrderDate= 7/2/1997 12:00:00 AM
Month= 9
OrderID= 10655
OrderDate= 9/3/1997 12:00:00 AM
Month= 11
OrderID= 10727
OrderDate= 11/3/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10812
OrderDate= 1/2/1998 12:00:00 AM
Month= 2
OrderID= 10908
OrderDate= 2/26/1998 12:00:00 AM
Month= 3
OrderID= 10942
OrderDate= 3/11/1998 12:00:00 AM
Month= 4
OrderID= 11010
OrderDate= 4/9/1998 12:00:00 AM
OrderID= 11062
OrderDate= 4/30/1998 12:00:00 AM
CompanyName= Ricardo Adocicados
Year= 1996
Month= 8
OrderID= 10287
OrderDate= 8/22/1996 12:00:00 AM
Month= 9
OrderID= 10299
OrderDate= 9/6/1996 12:00:00 AM
Year= 1997
Month= 2
OrderID= 10447
OrderDate= 2/14/1997 12:00:00 AM
Month= 3
OrderID= 10481
OrderDate= 3/20/1997 12:00:00 AM
Month= 6
OrderID= 10563
OrderDate= 6/10/1997 12:00:00 AM
Month= 8
OrderID= 10622
OrderDate= 8/6/1997 12:00:00 AM
OrderID= 10648
OrderDate= 8/28/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10813
OrderDate= 1/5/1998 12:00:00 AM
OrderID= 10851
OrderDate= 1/26/1998 12:00:00 AM
Month= 2
OrderID= 10877
OrderDate= 2/9/1998 12:00:00 AM
Month= 4
OrderID= 11059
OrderDate= 4/29/1998 12:00:00 AM
CompanyName= Richter Supermarkt
Year= 1996
Month= 7
OrderID= 10255
OrderDate= 7/12/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10419
OrderDate= 1/20/1997 12:00:00 AM
Month= 5
OrderID= 10537
OrderDate= 5/14/1997 12:00:00 AM
Month= 9
OrderID= 10666
OrderDate= 9/12/1997 12:00:00 AM
Month= 11
OrderID= 10751
OrderDate= 11/24/1997 12:00:00 AM
OrderID= 10758
OrderDate= 11/28/1997 12:00:00 AM
Year= 1998
Month= 3
OrderID= 10931
OrderDate= 3/6/1998 12:00:00 AM
OrderID= 10951
OrderDate= 3/16/1998 12:00:00 AM
Month= 4
OrderID= 11033
OrderDate= 4/17/1998 12:00:00 AM
Month= 5
OrderID= 11075
OrderDate= 5/6/1998 12:00:00 AM
CompanyName= Romero y tomillo
Year= 1996
Month= 8
OrderID= 10281
OrderDate= 8/14/1996 12:00:00 AM
OrderID= 10282
OrderDate= 8/15/1996 12:00:00 AM
Month= 9
OrderID= 10306
OrderDate= 9/16/1996 12:00:00 AM
Year= 1998
Month= 3
OrderID= 10917
OrderDate= 3/2/1998 12:00:00 AM
Month= 4
OrderID= 11013
OrderDate= 4/9/1998 12:00:00 AM
CompanyName= Santé Gourmet
Year= 1996
Month= 12
OrderID= 10387
OrderDate= 12/18/1996 12:00:00 AM
Year= 1997
Month= 4
OrderID= 10520
OrderDate= 4/29/1997 12:00:00 AM
Month= 8
OrderID= 10639
OrderDate= 8/20/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10831
OrderDate= 1/14/1998 12:00:00 AM
Month= 2
OrderID= 10909
OrderDate= 2/26/1998 12:00:00 AM
Month= 4
OrderID= 11015
OrderDate= 4/10/1998 12:00:00 AM
CompanyName= Save-a-lot Markets
Year= 1996
Month= 10
OrderID= 10324
OrderDate= 10/8/1996 12:00:00 AM
Month= 12
OrderID= 10393
OrderDate= 12/25/1996 12:00:00 AM
OrderID= 10398
OrderDate= 12/30/1996 12:00:00 AM
Year= 1997
Month= 2
OrderID= 10440
OrderDate= 2/10/1997 12:00:00 AM
OrderID= 10452
OrderDate= 2/20/1997 12:00:00 AM
Month= 4
OrderID= 10510
OrderDate= 4/18/1997 12:00:00 AM
Month= 6
OrderID= 10555
OrderDate= 6/2/1997 12:00:00 AM
Month= 7
OrderID= 10603
OrderDate= 7/18/1997 12:00:00 AM
OrderID= 10607
OrderDate= 7/22/1997 12:00:00 AM
OrderID= 10612
OrderDate= 7/28/1997 12:00:00 AM
Month= 8
OrderID= 10627
OrderDate= 8/11/1997 12:00:00 AM
Month= 9
OrderID= 10657
OrderDate= 9/4/1997 12:00:00 AM
OrderID= 10678
OrderDate= 9/23/1997 12:00:00 AM
Month= 10
OrderID= 10700
OrderDate= 10/10/1997 12:00:00 AM
OrderID= 10711
OrderDate= 10/21/1997 12:00:00 AM
OrderID= 10713
OrderDate= 10/22/1997 12:00:00 AM
OrderID= 10714
OrderDate= 10/22/1997 12:00:00 AM
OrderID= 10722
OrderDate= 10/29/1997 12:00:00 AM
Month= 11
OrderID= 10748
OrderDate= 11/20/1997 12:00:00 AM
OrderID= 10757
OrderDate= 11/27/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10815
OrderDate= 1/5/1998 12:00:00 AM
OrderID= 10847
OrderDate= 1/22/1998 12:00:00 AM
Month= 2
OrderID= 10882
OrderDate= 2/11/1998 12:00:00 AM
OrderID= 10894
OrderDate= 2/18/1998 12:00:00 AM
Month= 3
OrderID= 10941
OrderDate= 3/11/1998 12:00:00 AM
OrderID= 10983
OrderDate= 3/27/1998 12:00:00 AM
OrderID= 10984
OrderDate= 3/30/1998 12:00:00 AM
Month= 4
OrderID= 11002
OrderDate= 4/6/1998 12:00:00 AM
OrderID= 11030
OrderDate= 4/17/1998 12:00:00 AM
OrderID= 11031
OrderDate= 4/17/1998 12:00:00 AM
Month= 5
OrderID= 11064
OrderDate= 5/1/1998 12:00:00 AM
CompanyName= Seven Seas Imports
Year= 1996
Month= 11
OrderID= 10359
OrderDate= 11/21/1996 12:00:00 AM
Month= 12
OrderID= 10377
OrderDate= 12/9/1996 12:00:00 AM
OrderID= 10388
OrderDate= 12/19/1996 12:00:00 AM
Year= 1997
Month= 3
OrderID= 10472
OrderDate= 3/12/1997 12:00:00 AM
Month= 5
OrderID= 10523
OrderDate= 5/1/1997 12:00:00 AM
OrderID= 10547
OrderDate= 5/23/1997 12:00:00 AM
Month= 12
OrderID= 10800
OrderDate= 12/26/1997 12:00:00 AM
OrderID= 10804
OrderDate= 12/30/1997 12:00:00 AM
Year= 1998
Month= 2
OrderID= 10869
OrderDate= 2/4/1998 12:00:00 AM
CompanyName= Simons bistro
Year= 1996
Month= 10
OrderID= 10341
OrderDate= 10/29/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10417
OrderDate= 1/16/1997 12:00:00 AM
Month= 6
OrderID= 10556
OrderDate= 6/3/1997 12:00:00 AM
Month= 8
OrderID= 10642
OrderDate= 8/22/1997 12:00:00 AM
Month= 9
OrderID= 10669
OrderDate= 9/15/1997 12:00:00 AM
Month= 12
OrderID= 10802
OrderDate= 12/29/1997 12:00:00 AM
Year= 1998
Month= 5
OrderID= 11074
OrderDate= 5/6/1998 12:00:00 AM
CompanyName= Spécialités du monde
Year= 1997
Month= 11
OrderID= 10738
OrderDate= 11/12/1997 12:00:00 AM
Year= 1998
Month= 2
OrderID= 10907
OrderDate= 2/25/1998 12:00:00 AM
Month= 3
OrderID= 10964
OrderDate= 3/20/1998 12:00:00 AM
Month= 4
OrderID= 11043
OrderDate= 4/22/1998 12:00:00 AM
CompanyName= Split Rail Beer & Ale
Year= 1996
Month= 8
OrderID= 10271
OrderDate= 8/1/1996 12:00:00 AM
Month= 10
OrderID= 10329
OrderDate= 10/15/1996 12:00:00 AM
Month= 11
OrderID= 10349
OrderDate= 11/8/1996 12:00:00 AM
Month= 12
OrderID= 10369
OrderDate= 12/2/1996 12:00:00 AM
OrderID= 10385
OrderDate= 12/17/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10432
OrderDate= 1/31/1997 12:00:00 AM
Month= 11
OrderID= 10756
OrderDate= 11/27/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10821
OrderDate= 1/8/1998 12:00:00 AM
Month= 3
OrderID= 10974
OrderDate= 3/25/1998 12:00:00 AM
CompanyName= Suprêmes délices
Year= 1996
Month= 7
OrderID= 10252
OrderDate= 7/9/1996 12:00:00 AM
Month= 9
OrderID= 10302
OrderDate= 9/10/1996 12:00:00 AM
Year= 1997
Month= 2
OrderID= 10458
OrderDate= 2/26/1997 12:00:00 AM
Month= 3
OrderID= 10463
OrderDate= 3/4/1997 12:00:00 AM
OrderID= 10475
OrderDate= 3/14/1997 12:00:00 AM
Month= 12
OrderID= 10767
OrderDate= 12/5/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10841
OrderDate= 1/20/1998 12:00:00 AM
OrderID= 10846
OrderDate= 1/22/1998 12:00:00 AM
Month= 2
OrderID= 10885
OrderDate= 2/12/1998 12:00:00 AM
Month= 3
OrderID= 10930
OrderDate= 3/6/1998 12:00:00 AM
Month= 4
OrderID= 11035
OrderDate= 4/20/1998 12:00:00 AM
OrderID= 11038
OrderDate= 4/21/1998 12:00:00 AM
CompanyName= The Big Cheese
Year= 1996
Month= 9
OrderID= 10310
OrderDate= 9/20/1996 12:00:00 AM
Year= 1997
Month= 10
OrderID= 10708
OrderDate= 10/17/1997 12:00:00 AM
Month= 12
OrderID= 10805
OrderDate= 12/30/1997 12:00:00 AM
Year= 1998
Month= 4
OrderID= 10992
OrderDate= 4/1/1998 12:00:00 AM
CompanyName= The Cracker Box
Year= 1997
Month= 8
OrderID= 10624
OrderDate= 8/7/1997 12:00:00 AM
Month= 12
OrderID= 10775
OrderDate= 12/12/1997 12:00:00 AM
Year= 1998
Month= 4
OrderID= 11003
OrderDate= 4/6/1998 12:00:00 AM
CompanyName= Toms Spezialitäten
Year= 1997
Month= 2
OrderID= 10438
OrderDate= 2/6/1997 12:00:00 AM
OrderID= 10446
OrderDate= 2/14/1997 12:00:00 AM
Month= 5
OrderID= 10548
OrderDate= 5/26/1997 12:00:00 AM
Month= 7
OrderID= 10608
OrderDate= 7/23/1997 12:00:00 AM
Year= 1998
Month= 3
OrderID= 10967
OrderDate= 3/23/1998 12:00:00 AM
CompanyName= Tortuga Restaurante
Year= 1996
Month= 8
OrderID= 10276
OrderDate= 8/8/1996 12:00:00 AM
OrderID= 10293
OrderDate= 8/29/1996 12:00:00 AM
Month= 9
OrderID= 10304
OrderDate= 9/12/1996 12:00:00 AM
Month= 10
OrderID= 10319
OrderDate= 10/2/1996 12:00:00 AM
Year= 1997
Month= 4
OrderID= 10518
OrderDate= 4/25/1997 12:00:00 AM
Month= 6
OrderID= 10576
OrderDate= 6/23/1997 12:00:00 AM
Month= 9
OrderID= 10676
OrderDate= 9/22/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10842
OrderDate= 1/20/1998 12:00:00 AM
Month= 2
OrderID= 10915
OrderDate= 2/27/1998 12:00:00 AM
Month= 5
OrderID= 11069
OrderDate= 5/4/1998 12:00:00 AM
CompanyName= Tradição Hipermercados
Year= 1996
Month= 7
OrderID= 10249
OrderDate= 7/5/1996 12:00:00 AM
Month= 8
OrderID= 10292
OrderDate= 8/28/1996 12:00:00 AM
Year= 1997
Month= 4
OrderID= 10496
OrderDate= 4/4/1997 12:00:00 AM
Month= 7
OrderID= 10606
OrderDate= 7/22/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10830
OrderDate= 1/13/1998 12:00:00 AM
OrderID= 10834
OrderDate= 1/15/1998 12:00:00 AM
OrderID= 10839
OrderDate= 1/19/1998 12:00:00 AM
CompanyName= Trail's Head Gourmet Provisioners
Year= 1997
Month= 6
OrderID= 10574
OrderDate= 6/19/1997 12:00:00 AM
OrderID= 10577
OrderDate= 6/23/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10822
OrderDate= 1/8/1998 12:00:00 AM
CompanyName= Vaffeljernet
Year= 1996
Month= 11
OrderID= 10367
OrderDate= 11/28/1996 12:00:00 AM
Month= 12
OrderID= 10399
OrderDate= 12/31/1996 12:00:00 AM
Year= 1997
Month= 3
OrderID= 10465
OrderDate= 3/5/1997 12:00:00 AM
Month= 7
OrderID= 10591
OrderDate= 7/7/1997 12:00:00 AM
OrderID= 10602
OrderDate= 7/17/1997 12:00:00 AM
Month= 10
OrderID= 10688
OrderDate= 10/1/1997 12:00:00 AM
Month= 11
OrderID= 10744
OrderDate= 11/17/1997 12:00:00 AM
Month= 12
OrderID= 10769
OrderDate= 12/8/1997 12:00:00 AM
Year= 1998
Month= 3
OrderID= 10921
OrderDate= 3/3/1998 12:00:00 AM
OrderID= 10946
OrderDate= 3/12/1998 12:00:00 AM
Month= 4
OrderID= 10994
OrderDate= 4/2/1998 12:00:00 AM
CompanyName= Victuailles en stock
Year= 1996
Month= 7
OrderID= 10251
OrderDate= 7/8/1996 12:00:00 AM
Month= 10
OrderID= 10334
OrderDate= 10/21/1996 12:00:00 AM
Year= 1997
Month= 2
OrderID= 10450
OrderDate= 2/19/1997 12:00:00 AM
OrderID= 10459
OrderDate= 2/27/1997 12:00:00 AM
Month= 3
OrderID= 10478
OrderDate= 3/18/1997 12:00:00 AM
Month= 5
OrderID= 10546
OrderDate= 5/23/1997 12:00:00 AM
Month= 12
OrderID= 10806
OrderDate= 12/31/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10814
OrderDate= 1/5/1998 12:00:00 AM
OrderID= 10843
OrderDate= 1/21/1998 12:00:00 AM
OrderID= 10850
OrderDate= 1/23/1998 12:00:00 AM
CompanyName= Vins et alcools Chevalier
Year= 1996
Month= 8
OrderID= 10274
OrderDate= 8/6/1996 12:00:00 AM
Month= 9
OrderID= 10295
OrderDate= 9/2/1996 12:00:00 AM
Year= 1997
Month= 11
OrderID= 10737
OrderDate= 11/11/1997 12:00:00 AM
OrderID= 10739
OrderDate= 11/12/1997 12:00:00 AM
CompanyName= Die Wandernde Kuh
Year= 1996
Month= 9
OrderID= 10301
OrderDate= 9/9/1996 12:00:00 AM
OrderID= 10312
OrderDate= 9/23/1996 12:00:00 AM
Month= 11
OrderID= 10348
OrderDate= 11/7/1996 12:00:00 AM
OrderID= 10356
OrderDate= 11/18/1996 12:00:00 AM
Year= 1997
Month= 4
OrderID= 10513
OrderDate= 4/22/1997 12:00:00 AM
Month= 8
OrderID= 10632
OrderDate= 8/14/1997 12:00:00 AM
OrderID= 10640
OrderDate= 8/21/1997 12:00:00 AM
Month= 9
OrderID= 10651
OrderDate= 9/1/1997 12:00:00 AM
OrderID= 10668
OrderDate= 9/15/1997 12:00:00 AM
Year= 1998
Month= 4
OrderID= 11046
OrderDate= 4/23/1998 12:00:00 AM
CompanyName= Wartian Herkku
Year= 1996
Month= 7
OrderID= 10266
OrderDate= 7/26/1996 12:00:00 AM
Month= 8
OrderID= 10270
OrderDate= 8/1/1996 12:00:00 AM
Month= 10
OrderID= 10320
OrderDate= 10/3/1996 12:00:00 AM
OrderID= 10333
OrderDate= 10/18/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10412
OrderDate= 1/13/1997 12:00:00 AM
OrderID= 10416
OrderDate= 1/16/1997 12:00:00 AM
Month= 2
OrderID= 10437
OrderDate= 2/5/1997 12:00:00 AM
OrderID= 10455
OrderDate= 2/24/1997 12:00:00 AM
Month= 5
OrderID= 10526
OrderDate= 5/5/1997 12:00:00 AM
OrderID= 10553
OrderDate= 5/30/1997 12:00:00 AM
Month= 6
OrderID= 10583
OrderDate= 6/30/1997 12:00:00 AM
Month= 8
OrderID= 10636
OrderDate= 8/19/1997 12:00:00 AM
Month= 11
OrderID= 10750
OrderDate= 11/21/1997 12:00:00 AM
Month= 12
OrderID= 10781
OrderDate= 12/17/1997 12:00:00 AM
Year= 1998
Month= 4
OrderID= 11025
OrderDate= 4/15/1998 12:00:00 AM
CompanyName= Wellington Importadora
Year= 1996
Month= 7
OrderID= 10256
OrderDate= 7/15/1996 12:00:00 AM
Year= 1997
Month= 1
OrderID= 10420
OrderDate= 1/21/1997 12:00:00 AM
Month= 7
OrderID= 10585
OrderDate= 7/1/1997 12:00:00 AM
Month= 8
OrderID= 10644
OrderDate= 8/25/1997 12:00:00 AM
Month= 12
OrderID= 10803
OrderDate= 12/30/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10809
OrderDate= 1/1/1998 12:00:00 AM
Month= 2
OrderID= 10900
OrderDate= 2/20/1998 12:00:00 AM
OrderID= 10905
OrderDate= 2/24/1998 12:00:00 AM
Month= 3
OrderID= 10935
OrderDate= 3/9/1998 12:00:00 AM
CompanyName= White Clover Markets
Year= 1996
Month= 7
OrderID= 10269
OrderDate= 7/31/1996 12:00:00 AM
Month= 11
OrderID= 10344
OrderDate= 11/1/1996 12:00:00 AM
Year= 1997
Month= 3
OrderID= 10469
OrderDate= 3/10/1997 12:00:00 AM
OrderID= 10483
OrderDate= 3/24/1997 12:00:00 AM
Month= 4
OrderID= 10504
OrderDate= 4/11/1997 12:00:00 AM
Month= 7
OrderID= 10596
OrderDate= 7/11/1997 12:00:00 AM
Month= 10
OrderID= 10693
OrderDate= 10/6/1997 12:00:00 AM
OrderID= 10696
OrderDate= 10/8/1997 12:00:00 AM
OrderID= 10723
OrderDate= 10/30/1997 12:00:00 AM
Month= 11
OrderID= 10740
OrderDate= 11/13/1997 12:00:00 AM
Year= 1998
Month= 1
OrderID= 10861
OrderDate= 1/30/1998 12:00:00 AM
Month= 2
OrderID= 10904
OrderDate= 2/24/1998 12:00:00 AM
Month= 4
OrderID= 11032
OrderDate= 4/17/1998 12:00:00 AM
Month= 5
OrderID= 11066
OrderDate= 5/1/1998 12:00:00 AM
CompanyName= Wilman Kala
Year= 1996
Month= 7
OrderID= 10248
OrderDate= 7/4/1996 12:00:00 AM
Year= 1997
Month= 7
OrderID= 10615
OrderDate= 7/30/1997 12:00:00 AM
Month= 9
OrderID= 10673
OrderDate= 9/18/1997 12:00:00 AM
Month= 10
OrderID= 10695
OrderDate= 10/7/1997 12:00:00 AM
Year= 1998
Month= 2
OrderID= 10873
OrderDate= 2/6/1998 12:00:00 AM
OrderID= 10879
OrderDate= 2/10/1998 12:00:00 AM
OrderID= 10910
OrderDate= 2/26/1998 12:00:00 AM
Month= 4
OrderID= 11005
OrderDate= 4/7/1998 12:00:00 AM
CompanyName= Wolski Zajazd
Year= 1996
Month= 12
OrderID= 10374
OrderDate= 12/5/1996 12:00:00 AM
Year= 1997
Month= 7
OrderID= 10611
OrderDate= 7/25/1997 12:00:00 AM
Month= 12
OrderID= 10792
OrderDate= 12/23/1997 12:00:00 AM
Year= 1998
Month= 2
OrderID= 10870
OrderDate= 2/4/1998 12:00:00 AM
OrderID= 10906
OrderDate= 2/25/1998 12:00:00 AM
Month= 4
OrderID= 10998
OrderDate= 4/3/1998 12:00:00 AM
OrderID= 11044
OrderDate= 4/23/1998 12:00:00 AM
GroupBy - Comparer
This sample uses GroupBy to partition trimmed elements of an array using a custom comparer that matches words that are anagrams of each other.
Public Sub DataSetLinq44()
Dim anagrams = TestDS.Tables("Anagrams").AsEnumerable()
Dim orderGroups = anagrams.GroupBy(Function(w) w.Field(Of String)("anagram").Trim(), _
New AnagramEqualityComparer())
For Each g In orderGroups
Console.WriteLine("Key: {0}", g.Key)
For Each w In g
Console.WriteLine(vbTab & w("anagram"))
Next
Next
End Sub
Result:
Key: from
from
form
Key: salt
salt
last
Key: earn
earn
near
GroupBy - Comparer, Mapped
This sample uses GroupBy to partition trimmed elements of an array using a custom comparer that matches words that are anagrams of each other, and then converts the results to uppercase.
Public Sub DataSetLinq45()
Dim anagrams = TestDS.Tables("Anagrams").AsEnumerable()
Dim orderGroups = anagrams.GroupBy(Function(w) w("anagram").Trim(), _
Function(a) a("anagram").ToUpper(), _
New AnagramEqualityComparer())
For Each g In orderGroups
Console.WriteLine("Key: {0}", g.Key)
For Each w In g
Console.WriteLine(vbTab & w)
Next
Next
End Sub
Result:
Key: from
FROM
FORM
Key: salt
SALT
LAST
Key: earn
EARN
NEAR
