We have worked with data coming from one function fed into another. We need to keep in mind that the process starts from the inside out.

    function_5(some_value5...
      function_4(some_value4...
        function_3(some_value3...
          function_2(some_value2...
            function_1(some_value1...
              ) -- output of function_1 into function_2
            ) -- output of function_2 into function_3
          ) -- output of function_3 into function_4
        ) -- output of function_4 into function_5
      ) -- output of function_5

We have seen functions that affect strings and numeric values including `FORMAT()` to change the look of dates and currencies. Doing the latter changes the value from a numeric value to a string by default in SQL Server to `NVARCHAR(n)`.

Download the class notes for day 5.

This entry is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International license.