how to get a one each type tuple from grouped values
===

    select 
      source_of_data,
      convert(varchar(10),a.DATECREATED,101),
      COUNT(*)
    from some_table a
    group by source_of_data, 
    convert(varchar(10),a.DATECREATED,101)
    order by 
      source_of_data, convert(varchar(10),a.DATECREATED,101)

Output data looks like

mainframe 4/5/11  22

mainframe 4/6/11  45

... records deleted

mainframeN n/n/nn followed by

sqlserver 4/5/11  44

sqlserver 4/6/11  67

... records deleted

sqlserverN n/n/nn nn


I want the output to look like

    mainframe 4/5/11  22

    sqlserver 4/5/11  44

    mainframe 4/6/11  45

    sqlserver 4/6/11  67

    ...records deleted 

    mainframe n/n/nn  nn

    sqlserver n/n/nn  nn


This way I can easily verify (visually) if a grouped entry for any particular date is missing. (say for some day we got mainframe data but sqlserver data was missing). Can someone please help modify the query so I don't have to resort to writing a stored proc to achieve my objective ?

thank you
