Browsed by
Category: Uncategorized

PIVOTS with Unknown Values – Dynamic SQL

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…

Read More Read More