If you are trying to split a comma delimited string there are number of option to do that. One of the easiest ways is to……
Source: http://www.midnightdba.com/Jen/2010/10/tip-over-and-partition-by/ Here’s a quick summary of OVER and PARTITION BY (new in SQL 2005), for the uninitiated or forgetful… OVER OVER allows you to……