<div>
if &quot;not filled&quot; means empty string, but not null:<br />
&nbsp;, case when Colour1 &nbsp;is null or rtrim(Colour1) = '' then 0 else 1 end
</div>


if "not filled" means empty string, but not null:
 , case when Colour1  is null or rtrim(Colour1) = '' then 0 else 1 end

<div>
Thanks for the super-fast solution.<br />
Works perfectly; and so simple when you know how and get into the correct frame of mind.<br />
Many thanks.
</div>


Thanks for the super-fast solution.
Works perfectly; and so simple when you know how and get into the correct frame of mind.
Many thanks.

<div>
<div class="content wysiwyg-content">
Can anyone help me with a T-SQL query?<br />
<br />
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<br />
<br />
StkCol_StockCode nvarchar(20),<br />
StkCol_Colour1 nvarchar(20),<br />
StkCol_Colour2 nvarchar(20),<br />
StkCol_Colour3 nvarchar(20),<br />
StkCol_Colour4 nvarchar(20), <br />
all the way down to<br />
StkCol_Colour12 nvarchar(20)<br />
<br />
I would like to produce a T-SQL SELECT query that returns the Stock Code and the number of non-blank colour columns.<br />
ie quickly seeing how many colours have been filled out for each stock item.<br />
<br />
I cannot assume that the 12 &quot;colour&quot; 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).<br />
<br />
What syntax can I use to create a &quot;count&quot; of &nbsp;the non-blank colour columns for each record in the table?<br />
<br />
Many thanks.
</div>
</div>


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

StkCol_StockCode nvarchar(20),
StkCol_Colour1 nvarchar(20),
StkCol_Colour2 nvarchar(20),
StkCol_Colour3 nvarchar(20),
StkCol_Colour4 nvarchar(20), 
all the way down to
StkCol_Colour12 nvarchar(20)

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?

Many thanks.

I need help with a T-SQL SELECT query.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.