select highest and lowest figures in a group for %ge growth

• Nuts

  SSCrazy

  Points: 2547

  More actions

  January 21, 2010 at 9:01 pm

  #209355

  Hi Guys

  Here is my sample data...

  GPName Year Qtr Total_Doses

  XYZ 2008 1 20

  XYZ 2008 2 300

  .

  .

  XYZ 2009 4 500

  BNG 2007 2 440

  BNG 2007 3 1000

  BNG 2009 4 50

  .

  .

  .

  I want to calculate the percentage growth of total_doses for each doctor

  For ex the %ge growth for XYZ is 96% (((500 - 20)/500)*100

  There are about 300,000 rows in my table.

  Could you pls help guys??

  Thanks

• arun.sas

  SSChampion

  Points: 11831

  More actions

  January 21, 2010 at 9:26 pm

  #1107070

  Repeated post, discussion already started in

  http://www.sqlservercentral.com/Forums/Topic851707-392-1.aspx?Update=1