Hello cooljagadeesh,

Can you provide us with a little more detail please? What exactly are you trying to group?

If you're just looking for basic information on grouping, there's a nice article by Craig Freedman.

Link: http://blogs.msdn.com/b/craigfr/archive/2007/10/11/grouping-sets-in-sql-server-2008.aspx