AGGREAGATE VALUES LIKE BETWEEN 1 TO 2 LIKE THAT

• patr

  SSC Eights!

  Points: 892

  More actions

  May 5, 2008 at 10:43 pm

  #206963

  HI

  HOW TO GENERATE A REPORT LIKE THIS

  QUARTER PEOPLE

  1-2 100

  3-4 500

  ------------------------------------------------------------

  THE ACTUAL VALUE IN THE DATABASE [TARGET TABLE] IS

  QUARTER PEOPLE

  1 50

  2 50

  3 0

  4 500

  ------------------------------------------------------------

• antonio.collins

  SSCrazy Eights

  Points: 9600

  More actions

  May 6, 2008 at 3:28 pm

  #811498

  select (quarter - 1) / 2 as half,

  cast(min(quarter) as char(1)) +'-'+ cast(max(quarter) as char(1)),

  sum(people)

  from your_table

  group by (quarter - 1) / 2)