PIVOTS with Unknown Values – Dynamic SQL
As promised, although it took 3 years, I’ll show you how to use PIVOTS with unknown values. This is a continuation of the other PIVOT post. If you haven’t already, it’s not a bad idea to read it first. (Create Employee Work Shift Schedule using PIVOTS) We’ll use the same code to start off. The prep code is the same. Last time we predefined the time values like the code below But instead of listing the times, let’s concatenate the…