AndrewSQLDBA (3/12/2013)

---

I was actually looking for something else. That really did not help.

Andrew SQLDBA

AndrewSQLDBA (3/12/2013)

---

I was actually looking for something else. That really did not help.

Andrew SQLDBA

AndrewSQLDBA (3/12/2013)

---

For one thing, I do not have a Tally table setup on the server in which I am working.

So, are there any other ways of doing this without a tally table. There are only about 100,000 rows, and this is a one time update. So I do not really care about performance. What I am most concerned with is the amount of time to have this completed.

Yes, I can select the data into a temp table, in separate columns there. That would be fine. I can perform the update and then do what I need.

Thanks in advance
Andrew SQLDBA

AndrewSQLDBA (3/12/2013)

---

Hello Everyone
I am working on some old data that should not be store this way, but it is.

My data is two values with pipe separators.

10.0||14.5
or
2||34
or
7.1||19
or
4||11.7

I need to query this column and get each value separately. I have no idea how to go about this. There are always double pipe in the middle. But as you can see, there may or may not be decimal values in each. I think that is what is throwing me off. When perhaps, it really may not matter about the actual values.

I appreciate any and all assistance, suggestions and comments

Andrew SQLDBA

SELECT LEFT(value,CHARINDEX('||',value)-1) as Part1,STUFF(value,1,CHARINDEX('||',value)+1,'') as Part2