This document contains two real world examples which show how to use SET based SQL and common table expressions, to split input rows, into multiple output rows, unconditionally, or conditionally.
There are many reasons to shift many types of work to SET based SQL, but improved performance is at the top of the list.
Enjoy!
SET based SQL Tip - Splitting rows using common table expressions.pdf
Mike
There are many reasons to shift many types of work to SET based SQL, but improved performance is at the top of the list.
Enjoy!
SET based SQL Tip - Splitting rows using common table expressions.pdf
Mike