I was daydreaming about some SQL code the other day, and wrote a note to myself to investigate.
I’ve always been interested in writing loops to output sequential data. I don’t know why, I just do.
So, here is some SQL that will generate some binary.
DECLARE @b TABLE (c VARCHAR(1)) INSERT INTO @b VALUES (0) INSERT INTO @b VALUES (1) SELECT b1.c + b2.c + b3.c + b4.c + b5.c + b6.c + b7.c + b8.c FROM @b b1, @b b2, @b b3, @b b4, @b b5, @b b6, @b b7, @b b8 ORDER BY 1