Dear All, I want to group the Min and MAx of date based on number of unit as below,please help
My current Data *DayDate* *NoOfUnit* *Type* 1-Apr-14 1 A 2-Apr-14 1 A 3-Apr-14 1 A 4-Apr-14 1 A 5-Apr-14 0 A 6-Apr-14 2 A 7-Apr-14 2 A 8-Apr-14 0 A 9-Apr-14 1 A 10-Apr-14 0 A 11-Apr-14 1 A 12-Apr-14 1 A 14-Apr-14 1 A Expected Result *From Date* *ToDate* *NoOfUnit* *Type* 1-Apr-14 4-Apr-14 1 A 6-Apr-14 7-Apr-14 2 A 9-Apr-14 9-Apr-14 1 A 11-Apr-14 14-Apr-14 1 A Thanks in advance.. -- "People who never make mistakes, never do anything." dEv -- -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to dotnetdevelopment@googlegroups.com To unsubscribe from this group, send email to dotnetdevelopment+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net --- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To unsubscribe from this group and stop receiving emails from it, send an email to dotnetdevelopment+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
