3 bit counter

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259135 More actions · Answer 1

Here you go: all possible 3-bit values in one simple query:

SELECT '000'

UNION

SELECT '001'

UNION

SELECT '010'

UNION

SELECT '011'

UNION

SELECT '100'

UNION

SELECT '101'

UNION

SELECT '110'

UNION

SELECT '111';

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Paul White SSC Guru Points: 150468 More actions · Answer 2

elham_azizi_62 (5/22/2012)
I need to 3 bit counter with T-Sql that give this result

Why?