Hi, Flo. Nice to "see" you again. Hope all is well with you.

Since a join shows all combinations of the joined tables in the result set, whether or not those columns are displayed, you must be getting unexpected combinations. Select...

I hope you are also asking this question in an ORACLE forum.

Hey Jeff,

If you can spare a minute, would you mind revisiting this topic and double-checking me? I improved on the performance, but something doesn't feel right.

I don't know why everything in the code above is showing up in red. Maybe the PRINT statement?

Lynn, I'm sending you a can of halo polish for Christmas.

You must use it constantly and in large quantities.

Gugan and Peter,

I rewrote the CTE solution to account for strings that have no '1's. It now shows a zero to represent such strings. In...

Upon reflection, I must concede that where work (such as taking a count) can be done on a web application prior to calling a procedure, it takes the load off...

Yes, I understand that it is an example. But it is inconsistent to hard code a set of values and then to say that a count of those...

Nice work, Peter! I totally missed thinking about the issue of same values. Good catch.

I should go back and test my old code with a...

Barry: Want me to send you a good book or two? The real, old-fashioned kind made out of paper?

Oh yeah.... I tend to forget about the purpose of all this. I just play for love of the game.

Guess what happens when you print @@error? It resets to 0 because the PRINT statement executed successfully. Try commenting that out.

Best practice...

( I'd say you're welcome, but I thought you wanted to have the last word.)

If you are going to hard code the WHERE clause to be (1,2,4,8), why don't you just go ahead and say = 4?

What if someone makes a typo and has...