How to interpret this code?

• kjayani

  SSC Rookie

  Points: 43

  More actions

  February 24, 2016 at 10:36 pm

  #305026

  I'm a newbie and trying to understand what does this code do. The only information I have about this code is that it used to calculate values from year 2015 to 2001. I don't understand how this code works. Is there anyone can help me with interpreting the code?

  SET @MYYEAR = @FIRST_YEAR

  SET @QUERY = "UPDATE BACKWARD_PASS SET "

  WHILE (@MYYEAR <= @LAST_YEAR - 1)

  BEGIN

  IF (@MYYEAR <> @LAST_YEAR - 1)

  BEGIN

  SET @QUERY = @QUERY +

  "Calculate_Backward." + '[' + cast(right(@MYYEAR,2) as VARCHAR(10)) + ']' +

  " = cast(nullif(" + '[' + cast(@MYYEAR as VARCHAR(10)) + ']' + ",0) as float(1))/cast(nullif(" +

  '[' + cast(@MYYEAR+1 as VARCHAR(10)) + ']' + ",0) as float(1)),

  "

• Umer Akram

  SSC-Insane

  Points: 22209

  More actions

  February 24, 2016 at 10:54 pm

  #1860963

  Well this code is making a Dynamic Query based upon the parameter(s) value and if you want to check whats is making in the end. In the end of the code place the following :

  SELECT @QUERY

  this will give you the complete query copy the text and paste it in a t-sql and you will understand what its actually doing.