I need help with a T-SQL SELECT query.
Posted on 2014-04-11
Can anyone help me with a T-SQL query?
Using simplified column names, I have a SQL Server Table containing Stock Codes with up to 12 Colours the stock item is available in, eg
all the way down to
I would like to produce a T-SQL SELECT query that returns the Stock Code and the number of non-blank colour columns.
ie quickly seeing how many colours have been filled out for each stock item.
I cannot assume that the 12 "colour" values have been filled out without any gaps (ie colours 1, 2, 3 might be filled out, 4, 5, 6, 7 might be blank, but 8, 9, 10, 11, 12 might also contain values).
What syntax can I use to create a "count" of the non-blank colour columns for each record in the table?