markpringle (4/19/2015)
Thanks. Is it possible to put this into a function? Or how would I use that within a select statement?
Sure. I'd make sure that it was an "Inline Table Valued Function" for performance but there's no reason why this couldn't be encapsulated for reuse in such a manner.
--Jeff Moden
Change is inevitable... Change for the better is not.