On Sat, 08 Mar 2008 11:32:28 -0800, Darren New <dne### [at] sanrrcom> wrote:

>I believe there's a way simpler way of doing it that doesn't use any 
>trinary operators or server-specific features.  It's brutally 
>inefficient, but that wasn't a criterion. :-)
>
>I'll go pull it out of the code I wrote to solve exactly this problem, 
>next time I'm in that partition.

I imagine there are several ways to skin that cat.  I'm sure I can write another
version by joining
a couple of subqueries on the table, but it would likely be quite inefficient, as you
stated.  I
don't know about it being simpler, though.

Post a reply to this message