I have the result of a query that returns something like:

(int)   (mvarchar(50))        (nvarchar(255))
 ID        Location              Detail
  1      Los Angeles, CA      This is a detail
  3      Los Angeles, CA      Contact was not there
  2      Los Angeles, CA      This is ugly
  .            .                   .
  .            .                   . 

The data has already been sorted according to requirements. My sp needs to return a set like this:

(int)   (mvarchar(50))        (nvarchar(255))       (int)   (mvarchar(50))        (nvarchar(255))
 ID1        Location1              Detail1           ID2        Location2              Detail2
  1      Los Angeles, CA      This is a detail        3      Los Angeles, CA      Contact was not there
  2      Los Angeles, CA      This is ugly           NULL        NULL                    NULL

Basically ordering accross then down. If there is a solution that does not take into account the order, that will be fine, since I can at least see what suggestions you can come up with.

Thank you in advance,