String Delimiting in sql server taking Input from a Table

Question

I'm using Delimiting Strings, in sql server

I have a function like

select * from fnSplit('1,22,333,444,,5555,666')

Which splits the string into a table. But now I need to take the input from a table. I have 10 Rows which contain the Limited Strings separated by comma like 1,22,333. I need to take every row and use the function fnSplit on it and return all the values in a single table. How can I do this ???

- show us the code for your function

Preet Sangha
– Preet Sangha

2013-05-24 07:09:30 +00:00
Commented May 24, 2013 at 7:09 — Preet Sangha
– Preet Sangha, Commented May 24, 2013 at 7:09

Preet Sangha · Accepted Answer · 2013-05-24 07:05:19Z

4

try this

Select 
   distinct y.*
from
   mytable x 
   full outer join dbo.fnSplit(x.mycolumn) y ON 1=1

But I think this is very inefficient - show us the code for your function.

answered May 24, 2013 at 7:05

Preet Sangha

65.7k20 gold badges152 silver badges227 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Devart · Accepted Answer · 2013-05-24 07:07:21Z

2

Try this one -

SELECT * 
FROM dbo.mytable t
OUTER APPLY (
    SELECT * 
    FROM dbo.fnSplit(t.mycolumn) y
) y

answered May 24, 2013 at 7:07

Devart

120k23 gold badges172 silver badges189 bronze badges

Collectives™ on Stack Overflow

String Delimiting in sql server taking Input from a Table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related