Dohsan (5/27/2015)
Ed Wagner (5/27/2015)
Dohsan (5/27/2015)
This seems fairly similar to your previous question (Possibly even identical!), are you not able to use the method suggested by Chris? If you need further explanation, perhaps better to continue on the original post.http://www.sqlservercentral.com/Forums/Topic1685872-392-1.aspx
Good catch, Dohsan. I'll post a function that might help on the original thread.
I only remembered it because of the simplicity of Chris's answer! One of those you remember if a similar scenario ever pops up.
Yeah, I know exactly what you mean. I've struggled with puzzles before and then suddenly see some blinding flash of the obvious in math that makes it so simple I feel out-to-lunch for not seeing it before.