1. Learn
    2. /
  2. Courses
    3. /
  3. Hierarchical and Recursive Queries in SQL Server

Exercise

Calculate the sum of potencies

In this exercise, you will calculate the sum of potencies recursively. This mathematical series is defined as:

  • result=1 for step = 1
  • result + step^step for step > 1

The numbers in this series are getting large very quickly and the series does not converge. The task of this exercise is to calculate the sum of potencies for step = 9.

Instructions

100 XP
  • Define the CTE calculate_potencies with the fields step and result.
  • Initialize step and result using the definition of the mathematical series as a guide.
  • Add the next step to POWER(step + 1.. and add to result.