Just a day ago, we faced situation where one column in database contained two values which were separated by comma. We wanted to separate this two values in their own columns.
 
It was interesting that value of the column was variable and something dynamic needed to be written. Following is quick script which separates one [...]

Continue reading about T-SQL Script to Divide One Column Data into Two Columns