SQL Server: How do I delimit this data?
Posted
by codingguy3000
on Stack Overflow
See other posts from Stack Overflow
or by codingguy3000
Published on 2010-04-27T19:38:08Z
Indexed on
2010/04/27
19:53 UTC
Read the original article
Hit count: 303
Filed under:
sql-server
|sql-server-2005
declare @mydata nvarchar(4000)
set @mydata = '36|0, 77|5, 132|61'
I have this data that I need to get into a table. So for Row1 columnA would be 36 and columnB would be 0. For Row2 columnA would be 77 and columnB would be 5 etc.
What is the best way to do this?
Thanks
© Stack Overflow or respective owner
