This challenge involves writing a logic to change the column position of values in the output based on the presence and absence of other values on each output row.
An application that manages the work hours of employees needs to send payroll information to an external application for processing. At the end of each payroll period, the application need to generate a file which contains the number of hours each employee worked. Work hours are categorized into regular hours, over time hours, holiday hours etc.
Click the link below for sample data and to enter the challenge.
TSQL Challenge 42 - Transform rows to columns with dynamic positioning
