While solving a bug I was reminded again that, when UNPIVOTing, rows with NULL values are excluded. Fine. But it turns out we have the option to specify the INCLUDE NULLS with UNPIVOT, thus allowing us to keep those rows in the result set. Let's look...
datawise.dev1 min read
No responses yet.