Do you have a passion for technology? Do you enjoy helping the technical community you work in? Have you wanted to participate in a SQL Server beta program but don't know how to get involved? You can serve your passion and your community by...
EDITOR'S NOTE: Send your T-SQL questions to SQL Server MVP Itzik Ben-Gan at questions@tsqlsolutions.com.
Data in one of my tables is formatted in the ID and Name columns that Figure 1 shows. I need to write T-SQL code that separates the data i...