What’s the Difference Between PERCENT_RANK and CUME_DIST?

• Kathi Kellenberger

  SSChasing Mays

  Points: 601

  More actions

  June 27, 2019 at 12:00 am

  #3652124

  Comments posted to this topic are about the item What’s the Difference Between PERCENT_RANK and CUME_DIST?

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  June 28, 2019 at 12:10 am

  #3658319

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• John Esraelo-498130

  SSCertifiable

  Points: 5916

  More actions

  October 23, 2020 at 6:11 am

  #3800335

  Some minor fix is required.

  Originally, the AvgHighTempC is set to "not null", by default.

  To make the "update table" work, the table constructor needs the "null" for the said column.

  CREATE TABLE #MonthlyTempsStl(MNo Int,

  MName varchar(15),

  AvgHighTempF INT,

  AvgHighTempC DECIMAL(4,2) null )

  I like your posting. Well put together and easy to follow.  Well done!

   

   

   

  • This reply was modified 4 years, 2 months ago by  John Esraelo-498130. Reason: adding more comment

  Cheers,
  John Esraelo