Jeff Moden (3/21/2013)
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 ...
Absolutely agreed. It's just that some of us have been doing this so long that we've learned to anticipate various data "possibilites" and to bulletproof the code a bit.
But this is not bad ... SQLSERVERCENTRAL Makes a great source of information, this is the most important .... Sometimes used truck engine in small cars, or kill the fly with large guns :w00t:, but this is a detail ... Congratulations to all!!