Great question, but explanation could be improved.

Easy one, thanks.

Easy one, thanks.

Nice question, thanks.

Thanks for the question.

Interesting question, thanks.

Nice question, thanks.

So much reading

Excellent question, thanks.

Thanks for the question.

Somehow completely missed that the data type was bit.

Moar caffeine needed!

Nice question, thanks.

Thanks for the question.

Nice question, thanks.

CONCATENATE just pastes two strings (or columns together).

CONCATENATEX is an iterator which goes over an entire...

And that's why we don't let SQL Server use the defaults