I need help on getting another query to wrap the results from this query. The actual data has more columns (fields) than I have shown here.
How can I come up with one ticket number per row and each column could fill the value of 'Yes' or 'N/A' in the appropriate columns?
The end result should be one ticket # per row.
SELECT number
, Mandatory = MAX(Mandatory)
, Valid = MAX(Valid)
, ....
FROM ...
GROUP BY number