Calculation in sql query ..

• getalok_akg

  Ten Centuries

  Points: 1006

  More actions

  December 23, 2013 at 1:01 am

  #301638

  Hi All,

  we are facing challege to Calculate percentage as highlighted cell in below mention SnapShot .

  Any help if we can calculate in sql query will be very helpful .

  A1A21224 36 48

  20105631619.35%722.58%

  20114536514%411.11%

  20125612216.66%325%

  20137812325.00%

  2351111614.41%1414.14%

  For 14.41% = 16/111

  For 14.14 % = 14/111-12 and So on further Column on 36, 48....

  Thanks,

  Alok

• ChrisM@Work

  SSC Guru

  Points: 186127

  More actions

  December 23, 2013 at 4:46 am

  #1675539

  Please post a sample data script as per this article [/url]- it's very difficult to tell what you are looking for.

  ^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

  For fast, accurate and documented assistance in answering your questions, please read this article.
  Understanding and using APPLY, (I) and (II) Paul White
  Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden