CASE WHEN ColX IS NOT NULL THEN ColX

WHEN ColY IS NOT NULL THEN ColY

...

There is no "SQL command". You code with views as if they were tables. So the tools you have to work with are the standard JOINS,...

Errrrr... ummmm... ahhhh....

Glad to, Riz 🙂 On my machine, the loop is taking 29-30 milliseconds, on the average, to run. A couple of times it dropped to 16,...

Congratulations, Roy !! Keep up the good work.

It would be helpful to see the full WHERE clause.

Given the 'A999A' pattern, I assume it contains something like this?

WHERE someCol like '[A-Z][0-9][0-9][0-9][0-9][A-Z]'

Hey Seth 🙂

You inspired me to convert my CTE solution to an inline table valued function (at the bottom). Use it with a cross apply and it's not...

select '4*2,4*4,6'

Might as well make some more assumptions. 😉

A straightforward procedural solution, but it really needs to be tested against other patterns. Unless the OP (original poster) tells us otherwise, we can't assume that there will...

As time moves along, you would expect to see a change in the pattern / methodology that a person posts. If there is no change in pattern, then I...

TRAVEL (ItemID = 'TR')

--------

1) SO Type of Relocation, because it hasn't been mapped to this part yet, and there are still combinations available.

2) Time Log Install, because it hasn't been...

You all do realize that in some cases SSC is the automatic transmission compared to the manual-shift F1 key? All the volunteers enable (some) people to multitask. ...

Chris, I'm looking at your sample data right now. What would really help me is for you to give me sample inputs and outputs. Draw...

I have to agree that coalesce is better overall in that it can handle more than two.

One additional comment:

If you are ever working with FLOAT datatypes you can't use the modulo (%) operator. In that case, you can use ROUND with...