I've stumbled accross this post today that explains the Rozenshtein method of pivoting data.
It's quite interesting. I haven't seen the SIGN() function being used at all in SQL server in practice yet so this is kind of cool if you ask me :)
Print | posted on Wednesday, June 14, 2006 11:20 AM
Powered by:
Copyright © Mladen Prajdić