carlosaamaral (3/21/2013)
Sean Lange (3/21/2013)
carlosaamaral (3/21/2013)
Logic ?
MID=(CASE WHEN ID-100=0 THEN NULL
ELSE ID-100 END
)
That would work on the example data but I doubt the real situation is that straight forward. The code that Jeff and I posted makes it dynamic.
ok ... but sometimes the simple, we do not see ... Without data, it really is very, very complicated ...
Exactly - which is why most of my answers to questions don't involved code. We don't see the logic (business or otherwise) behind the question - only the desire to see the result.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx