Dinakar Nethi Blog

Dinakar Nethi

Parse delimited string in a Stored procedure

Sometimes we need to pass an array to the Stored Procrdure and split the array inside the stored proc. For example, lets say there is a datagrid displaying sales orders, each sales order associated with an orderid (PK in the Sales table). If the user needs to delete a bunch of sales orders ( say 10-15 etc)..it would be easier to concatenate all the orderid's into one string like 10-24-23-34-56-57-….etc and pass it to the sql server stored proc and inside the stored proc, split the string into individual ids and delete each sales order.

There can be plenty of other situations where passing a delimited string to the stored proc is faster than making n number of trips to the server.

CREATE PROCEDURE ParseArray (@Array VARCHAR(1000),@separator CHAR(1))
AS

BEGIN SET NOCOUNT ON

– @Array is the array we wish to parse – @Separator is the separator charactor such as a comma

    <span class="kwrd">DECLARE</span> @separator_position <span class="kwrd">INT</span> <span class="rem">-- This is used to locate each separator character</span>
    <span class="kwrd">DECLARE</span> @array_value <span class="kwrd">VARCHAR</span>(1000) <span class="rem">-- this holds each array value as it is returned</span>

– For my loop to work I need an extra separator at the end. I always look to the – left of the separator character for each array value

    <span class="kwrd">SET</span> @<span class="kwrd">array</span> = @<span class="kwrd">array</span> + @separator

– Loop through the string searching for separtor characters WHILE PATINDEX('%' + @separator + '%', @array) <> 0 BEGIN – patindex matches the a pattern against a string SELECT @separator_position = PATINDEX('%' + @separator + '%',@array) SELECT @array_value = LEFT(@array, @separator_position - 1) – This is where you process the values passed.

            <span class="rem">-- Replace this select statement with your processing</span>
            <span class="rem">-- @array_value holds the value of this element of the array</span>
            <span class="kwrd">SELECT</span>  Array_Value = @array_value
            <span class="rem">-- This replaces what we just processed with and empty string</span>
            <span class="kwrd">SELECT</span>  @<span class="kwrd">array</span> = STUFF(@<span class="kwrd">array</span>, 1, @separator_position, <span class="str">&#39;&#39;</span>)
        <span class="kwrd">END</span>

SET NOCOUNT OFF END

GO



Legacy Comments


Dave
2007-04-18
re: Parse delimited string in a Stored procedure
How timely! I was just looking for this example - thanks for posting it - saved me hours. I will recommend your site.

Shawn
2007-05-16
re: Parse delimited string in a Stored procedure
would love to see an example with the delimited text coming from a field in the database. In other words instead of passing the string in as arguments to the sp, have a select in the sp that selects a field in the db that has values that are comma delimited...and then parse through that.

Dinakar
2007-05-17
re: Parse delimited string in a Stored procedure
It is very easy to convert the above SP to a UDF, keeping the same logic. Create a UDF that returns a table variable, put the same logic inside. Then call the UDF from your sp as

SELECT * FROM dbp.ParseArray(col1, ',')

Shawn
2007-05-21
re: Parse delimited string in a Stored procedure
Thanks Dinakar...I've not worked with UDF's before and under a deadline...any chance you could post the udf code for that as well?

Dinakar
2007-05-23
re: Parse delimited string in a Stored procedure
Pretty simple as I said:
----------
CREATE FUNCTION dbo.fnParseArray (@Array VARCHAR(1000),@separator CHAR(1))
RETURNS @T Table (col1 varchar(50))
AS
BEGIN
--DECLARE @T Table (col1 varchar(50))
-- @Array is the array we wish to parse
-- @Separator is the separator charactor such as a comma
DECLARE @separator_position INT -- This is used to locate each separator character
DECLARE @array_value VARCHAR(1000) -- this holds each array value as it is returned
-- For my loop to work I need an extra separator at the end. I always look to the
-- left of the separator character for each array value

SET @array = @array + @separator

-- Loop through the string searching for separtor characters
WHILE PATINDEX('%' + @separator + '%', @array) <> 0
BEGIN
-- patindex matches the a pattern against a string
SELECT @separator_position = PATINDEX('%' + @separator + '%',@array)
SELECT @array_value = LEFT(@array, @separator_position - 1)
-- This is where you process the values passed.
INSERT into @T VALUES (@array_value)
-- Replace this select statement with your processing
-- @array_value holds the value of this element of the array
-- This replaces what we just processed with and empty string
SELECT @array = STUFF(@array, 1, @separator_position, '')
END
RETURN
END
----------

You can call the function as:

select * from dbo.fnParseArray('a,b,c,d,e,f', ',')

Shawn
2007-05-24
re: Parse delimited string in a Stored procedure
awesome! thank you so much!!

AC77
2007-08-28
re: Parse delimited string in a Stored procedure
Is it possible to do this with 2 input arrays and return a 2 column table?

Dinakar
2007-09-01
re: Parse delimited string in a Stored procedure
Function can only return one value.. You will have to call the function twice..

Helmut
2008-02-05
re: Parse delimited string in a Stored procedure
how would you use this passing it a field from a table... ie my table has a field (field1 varchar)
that has 1,2,3,4,56,78,999,87,65,4,32,1
how would I split that using this function??

Helmut
2008-02-05
re: Parse delimited string in a Stored procedure
I figured it out...
am posting for others to use:

declare @txtvar varchar(255)

select
@txtvar = field1
from
x

select *
from dbo.fnParseArray(@txtvar, ',')

Helmut
2008-02-05
re: Parse delimited string in a Stored procedure
well I thought I had it... that only works
with 1 row in your table...
how do i get it to work with multiple rows???





Josep
2008-08-27
re: Parse delimited string in a Stored procedure
Thanks very much for this great code !

Seed
2008-09-30
re: Parse delimited string in a Stored procedure
Hemut:

You can join the two something like this (untested):

select funcTable.*
from dbo.fnParseArray(table1.field1, ',') funcTable, x table1

Monster
2008-10-13
re: Parse delimited string in a Stored procedure
Thanks Dinakar..

Unisol
2008-10-14
re: Parse delimited string in a Stored procedure
Thanks fro the code

Mdot
2008-10-30
re: Parse delimited string in a Stored procedure
I need to do something just like Hemut posted above.
I tried:
select funcTable.*
from dbo.fnParseArray(table1.field1, ',') funcTable, x table1

I get an error like
The multi-part identifier "table1.field1" could not be bound.

Any suggestions?

Gov
2008-11-14
re: Parse delimited string in a Stored procedure
hi all
Such a nice Article.it will defenatily help other's as it's help me

rüya tabiri
2008-11-25
re: Parse delimited string in a Stored procedure
Thank you

Bhabna
2008-12-10
re: Parse delimited string in a Stored procedure
I wrote the same function to parse the field with : delimeter. But then I added 2 more lines.

Here is my code
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

ALTER FUNCTION IVR_ADMIN.fnParseArray (@Array VARCHAR(1000),@separator CHAR(1))
RETURNS varchar(8000)
AS
BEGIN
-- @Array is the array we wish to parse
-- @Separator is the separator charactor such as a comma
DECLARE @separator_position INT -- This is used to locate each separator character
DECLARE @array_value VARCHAR(1000) -- this holds each array value as it is returned
-- For my loop to work I need an extra separator at the end. I always look to the
-- left of the separator character for each array value
DECLARE @newArray VARCHAR(8000)
DECLARE @map_name VARCHAR(50)

SET @array = @array + @separator

-- Loop through the string searching for separtor characters
WHILE PATINDEX('%' + @separator + '%', @array) <> 0
BEGIN
-- patindex matches the a pattern against a string
SELECT @separator_position = PATINDEX('%' + @separator + '%',@array)
SELECT @array_value = LEFT(@array, @separator_position - 1)
-- This is where you process the values passed.
--INSERT into map_name
-- Replace this select statement with your processing
-- @array_value holds the value of this element of the array
-- This replaces what we just processed with and empty string
SELECT @map_name = MAP_NAME from IVR_ADMIN.IVR_MAPPING where MAP_ID = @array_value

SET @map_name = @map_name + @separator
SET @newArray = @newArray + @map_name
SELECT @array = STUFF(@array, 1, @separator_position, '')
END

RETURN @newArray
END








GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

I am using the parse value in MAPPING table to get MAP_NAME and then concanate all the values. But I am getting null for

SET @map_name = @map_name + @separator
SET @newArray = @newArray + @map_name

but if I use

SET @newArray = @map_name + @separator

I am getting the expected value for second statement but not the first one.

Can anybody help me as I am new to Microsoft SQL Server.

Sorry for asking this one.

-Bhabna

games secret
2008-12-22
re: Parse delimited string in a Stored procedure
thanks youu

chat
2009-01-04
re: Parse delimited string in a Stored procedure
thank you :)

Jeppe Andreasen
2009-01-25
re: Parse delimited string in a Stored procedure
You could probaly speed things up a bit by not calling the patIndex twice for each Iteration... like this

...

CREATE FUNCTION dbo.ParseArray (@Array varchar(2500), @separator char(1))
RETURNS @T Table (col1 varchar(50))
AS
BEGIN
--DECLARE @T Table (col1 varchar(50))
-- @Array is the array we wish to parse
-- @Separator is the separator charactor such as a comma
DECLARE @separator_position INT -- This is used to locate each separator character
DECLARE @array_value VARCHAR(1000) -- this holds each array value as it is returned
-- For my loop to work I need an extra separator at the end. I always look to the
-- left of the separator character for each array value

SET @array = @array + @separator
SELECT @separator_position = PATINDEX('%' + @separator + '%',@array)
-- Loop through the string searching for separtor characters
WHILE @separator_position <> 0
BEGIN
-- patindex matches the a pattern against a string
SELECT @array_value = LEFT(@array, @separator_position - 1)
-- This is where you process the values passed.
INSERT into @T VALUES (@array_value)
-- Replace this select statement with your processing
-- @array_value holds the value of this element of the array
-- This replaces what we just processed with and empty string
SELECT @array = STUFF(@array, 1, @separator_position, '')
SELECT @separator_position = PATINDEX('%' + @separator + '%',@array)
END
RETURN
END

Dave
2009-01-27
re: Parse delimited string in a Stored procedure
Great code, saved me a lot of time!

Jim
2009-01-28
re: Parse delimited string in a Stored procedure
Modified to accept a variable length delimeter:



set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[fnParseArray] (@Array VARCHAR(MAX),@separator VARCHAR(100))
RETURNS @T Table (col1 varchar(50))
AS
BEGIN
--DECLARE @T Table (col1 varchar(50))
-- @Array is the array we wish to parse
-- @Separator is the separator charactor such as a comma
DECLARE @separator_position INT -- This is used to locate each separator character
DECLARE @array_value VARCHAR(MAX) -- this holds each array value as it is returned
-- For my loop to work I need an extra separator at the end. I always look to the
-- left of the separator character for each array value

SET @array = @array + @separator

-- Loop through the string searching for separtor characters
WHILE PATINDEX('%' + @separator + '%', @array) <> 0
BEGIN
-- patindex matches the a pattern against a string
SELECT @separator_position = PATINDEX('%' + @separator + '%',@array)

SELECT @array_value = LEFT(@array, @separator_position - 1)
-- This is where you process the values passed.
INSERT into @T VALUES (@array_value)
-- Replace this select statement with your processing
-- @array_value holds the value of this element of the array
-- This replaces what we just processed with and empty string
SELECT @array = STUFF(@array, 1, @separator_position + (LEN(@separator)-1), '')
END
RETURN
END

sohbet odalari
2009-03-07
re: Parse delimited string in a Stored procedure
thank you very much .

Sohbet
2009-03-07
re: Parse delimited string in a Stored procedure
thankss

Mirc
2009-03-07
re: Parse delimited string in a Stored procedure
thnks

chat odaları
2009-04-28
re: Parse delimited string in a Stored procedure
thank

Harsh
2009-05-07
re: Parse delimited string in a Stored procedure
Good one..!!

Zorever
2009-05-21
re: Parse delimited string in a Stored procedure
I am Passing a String in a Stored Procedure for example
'1,2,3,4,5'
and inside the stored procedure i need to remove the single quotes on the both sides of the string and to store the rest string to a variable inside the Stored Procedure
Can i apply some operation to the string

Edencity Chat
2009-05-22
re: Parse delimited string in a Stored procedure
thank you admin

tolga
2009-07-01
re: Parse delimited string in a Stored procedure
Thank You Gavur

sXe
2009-07-01
re: Parse delimited string in a Stored procedure
Thank YOu Foorro

mp3 dinle
2009-07-10
re: Parse delimited string in a Stored procedure
Thank you very mush admin cok saol

en güzel oyunlar
2009-07-10
re: Parse delimited string in a Stored procedure
Thank YOu cok saol very Much

bosch servisi
2009-07-10
re: Parse delimited string in a Stored procedure
Thank You admin

wéBurak
2009-07-10
re: Parse delimited string in a Stored procedure
good post, thank you for an posting. Very good..

hikaye
2009-07-16
re: Parse delimited string in a Stored procedure
I am Passing a String in a Stored Procedure for example
'1,2,3,4,5'
and inside the stored procedure i need to remove the single quotes on the both sides of the string and to store the rest string to a variable inside the Stored Procedure
Can i apply some operation to the string

aşk
2009-07-17
re: Parse delimited string in a Stored procedure
I am grateful to you for this great content.

Hanna
2009-07-22
re: Parse delimited string in a Stored procedure
I need to send multiple items selected from listbox to a stored procedure where stored procedure can split it into values and on the basis of these values should return record.

Thanks.

Please help me out with this.


Venkitesh
2009-08-09
re: Parse delimited string in a Stored procedure
Can anybody help in this requirement?i can pass number of strings seperated by a delimiter (say #).i want to seperate these strings and search for the string in a particular table in a database and return the value of another column.
Table name can be hardcoded.

Eg: i will execute the query as

EXEC search_string bob#williams#pop#king,#

Arg1: Strings to be searched(which should be seperated and searched one by one)

Michael Robbins
2009-10-07
re: Parse delimited string in a Stored procedure
This is great thanks really needed this.

remaps
2009-10-10
re: Parse delimited string in a Stored procedure
thank you i really need it

Domatessuyu
2009-10-31
re: Parse delimited string in a Stored procedure
CREATE PROCEDURE ParseArray (@Array VARCHAR(1000),@separator CHAR(1))

where i put ? pls help

Breast Lift Philadelphia
2009-11-19
re: Parse delimited string in a Stored procedure
Honestly, I have not been into this Parse delimited String or something. But I got interested in this thing. I will make some research regarding this perhaps this idea can be beneficial in my part. Thanks for posting in!

burning calories
2009-11-22
re: Parse delimited string in a Stored procedure
nice site thanks !!

Karim Kenawy
2009-12-21
re: Parse delimited string in a Stored procedure
Thanks, it worked fine.

sxe
2010-01-09
re: Parse delimited string in a Stored procedure
Thanks man

worked fine

Stejan
2010-01-28
re: Parse delimited string in a Stored procedure
Thank . Nice post

gagner au jeu de poker
2010-02-17
re: Parse delimited string in a Stored procedure
This information is mostly helpful in debugging the code, but it is useless after that. By setting SET NOCOUNT ON, we can disable the feature of returning this extra information. For stored procedures that contain several statements or contain Transact-SQL loops, setting SET NOCOUNT to ON can provide a significant performance boost because network traffic is greatly reduced.

oyunlar
2010-02-24
re: Parse delimited string in a Stored procedure
I like the 8:00 weekday starts much better than the 7:00. I think you'll see attendance number rise a bit for these weekday games.

Gangster Fancy Dress
2010-04-07
re: Parse delimited string in a Stored procedure
Dinakar you are an absolute gem! Excellent stuff as always. Have a great week.:D

RSA Online
2010-04-29
re: Parse delimited string in a Stored procedure
Thank you, this split function was exactly what I needed. Can't believe that such a function is not built-in.

Uk Chip Tuning
2010-05-09
re: Parse delimited string in a Stored procedure
Thank your for this very usefull

Tune My Engine
2010-05-09
re: Parse delimited string in a Stored procedure
great job

Uk Chip Tuning
2010-05-09
re: Parse delimited string in a Stored procedure
nice job thanks

syd
2010-05-11
re: Parse delimited string in a Stored procedure
This saved me today - thank you!!

sudoko
2010-05-12
re: Parse delimited string in a Stored procedure
yes nicely done

resimleri
2010-05-15
re: Parse delimited string in a Stored procedure
merci admin

Koncentrix
2010-06-11
re: Parse delimited string in a Stored procedure
Very usefull... works like a charm.

canada online
2010-06-16
re: Parse delimited string in a Stored procedure
done
I like it

CHAT
2010-06-20
re: Parse delimited string in a Stored procedure
Thank your yes nicely done

Diego
2010-06-25
re: Parse delimited string in a Stored procedure
Great! Tank you... it was so useful to me! :)

Canlı chat
2010-07-05
re: Parse delimited string in a Stored procedure
very good superr thank you adminn

sking tags
2010-07-16
re: Parse delimited string in a Stored procedure
It really works good job.

bosch servis
2010-07-20
re: Parse delimited string in a Stored procedure
thanks youu very much ...

subhre
2010-08-19
re: Parse delimited string in a Stored procedure
I have the same requirement as Helmut and MDOT and can't figure out what to do.

I'm trying something like:

line 1: select a.*
line 2: from dbo.fnParseArray(x.field1, ';') a, table1 x;

where field1 is a field in table1.

I'm getting [Incorrect syntax near '.'.] error at line 2.

Any help from anyone would be hugely appreciated. Thanks guys!

xat sohbet
2010-08-28
re: Parse delimited string in a Stored procedure
thnx for post very nice informations.

rüya tabirleri
2010-08-30
re: Parse delimited string in a Stored procedure
Thank you Comments

Bonus casino di Internet
2010-09-02
re: Parse delimited string in a Stored procedure
If Stored Procedure is transactional then, it should roll back complete transactions when it encounters any errors. Well, that does not happen in this case, which proves that Stored Procedure does not only provide just the transactional feature to a batch of T-SQL.

miniclip games
2010-09-10
re: Parse delimited string in a Stored procedure
This is the first time I am visiting this post.I have gathered much of it.Really a interesting firm things. Thanks for sharing.

2011
2010-09-17
re: Parse delimited string in a Stored procedure
good sharing, thank you..

stroum
2010-09-22
re: Parse delimited string in a Stored procedure
nice article. ilike tis

smart
2010-10-01
re: Parse delimited string in a Stored procedure
nice sharing, thank you..

kayu
2010-11-16
re: Parse delimited string in a Stored procedure
thank you verry good.

Hiphop
2010-12-11
re: Parse delimited string in a Stored procedure
Thanks, nice sharing..
Good works.!

Honorarberatung Honorarberater
2010-12-21
re: Parse delimited string in a Stored procedure
Very helpfull post, Thanks guys!

Sagopa Kajmer
2011-01-20
re: Parse delimited string in a Stored procedure
thank you for post, nice sharing..

karthik
2011-01-24
re: Parse delimited string in a Stored procedure
hi,
i am new to sql. i want to create a procedure that splits the incoming string with respect to space and apply 'AND' between each of the word and retrive the ('%'like'%') rows from a table. can anyone help me.

Thanks

cantambenim
2011-01-28
re: Parse delimited string in a Stored procedure
thank you for post, nice sharing..

Köpenhamn
2011-03-17
re: Parse delimited string in a Stored procedure
Will have great appreciation as a engineer , so need to achieve many and many comments here . anyway thanks for share


chat
2011-04-09
re: Parse delimited string in a Stored procedure
visiting your site. It’s really a pleasure knowing a site like this packed with great information.Good bolg, thank you for sharing.

ypseph
2011-04-19
Stored procedure
hey guys i need some help.

i have a table here in my db in w/c has a Location Name of the world ,,now some of them have symbols,underscore and numbers..How could i make sure that all the users can see familiar Location name,,in other words i need to delete all that messed symbols,,and also i will add some hierarchy like cities,country...

please i need a script for that..hoping for your help..

Will
2011-05-08
re: Parse delimited string in a Stored procedure
Nice piece of code illustrating how to pass a delimited string. I'll save and document it in my file of code snippets.

stay younger.net
2011-05-22
re: Parse delimited string in a Stored procedure
There can be plenty of other situations where passing a delimited string to the stored proc is faster than making n number of trips to the server.

Blueprint RSA
2011-05-30
re: Parse delimited string in a Stored procedure
Thank you for this very informational blog. It's really help a lot in my work. Great Job man

cinselsohbetsitesi
2011-07-15
re: Parse delimited string in a Stored procedure
thx cinsel sohbet sitesi http://www.cinselsohbetsitesi.com

seo service company india
2011-07-18
re: Parse delimited string in a Stored procedure
Very well workstation for your blog.

David Bryan
2011-07-20
re: Parse delimited string in a Stored procedure
I have a similar need for a function but it is a little more complex. I have an EDI file that has a two dimensional array. The rows are delimited by '~' and fields are delimited by '*'. I'm stuck trying to write a function that returns more than a table with one field. I need to return a table that returns a row with up to 20 fields. Any ideas or pointers? I'm trying to modify your function to loop inside but I'm not having much success.

goldfish care
2011-08-05
re: Parse delimited string in a Stored procedure
these kind of posts are alwasy very helpful. thumbs up buddy!

Best LED TV
2011-08-08
re: Parse delimited string in a Stored procedure
Informative post! Thanks for sharing ^^

Aspen Rae
2011-08-14
re: Parse delimited string in a Stored procedure
Thanks on your marvelous posting! I really enjoyed reading it. I will be sure to bookmark your blog and will eventually come back at some point. I want to encourage you to definitely continue your writing, have a nice afternoon!Ultrasonography

spanx
2011-08-14
re: Parse delimited string in a Stored procedure
Thanks for this post because I'm searching for this information before many days and I'll get it in your post.

buy shake weight
2011-08-16
re: Parse delimited string in a Stored procedure
i don't understand the code much, but i think this is very intelligently done

streaming online
2011-08-17
re: Parse delimited string in a Stored procedure
very thanks

aanmelden bij google
2011-08-18
re: Parse delimited string in a Stored procedure
I'm also try to find this type of informational blogs and this one is so amazing.

MarieHoland99
2011-08-18
re: Parse delimited string in a Stored procedure
I like the valuable information you provide in your articles. I’ll bookmark your we blog and check again here frequently. I am quite sure I will learn many new stuff right here! Best of luck for the next!

webcam sexo
2011-08-21
re: Parse delimited string in a Stored procedure
Now I know how to improve my coding skills. Thanks for this one - really saved my day.

MarieHoland99
2011-08-22
re: Parse delimited string in a Stored procedure
Here I found your blog to be very worthwhile. I am quite excited with all the article content of your site. It would be my pleasure to gather some more strategies from your web-site and come up to offer people what I have benefited from you. dallas mortgage rates

candidiasis tratamiento
2011-08-23
re: Parse delimited string in a Stored procedure
This is such an amazing site! I really enjoyed reading the content. You've made it to the top. thanks for the well-organized content!

Telefon Sex Chat
2011-08-24
re: Parse delimited string in a Stored procedure
Good page - like it my friend. Looks very nice.

Seattle Furniture
2011-08-24
re: Parse delimited string in a Stored procedure
I am quite sure I will learn many new stuff right here! Best of luck for the next.

Cursos de ingles en el extranjer
2011-08-24
re: Parse delimited string in a Stored procedure
The means of transmission is undeniably the main successor of modernization. And this is what I discovered upon viewing and looking over this site.

Web Marketing
2011-08-25
re: Parse delimited string in a Stored procedure
I can’t think of anything wrong to say about your post. Good job!

tomcruise9991
2011-08-26
re: Parse delimited string in a Stored procedure
I search about these codes before many days and today I find them in your blog. I can’t forget this information in whole life

Hotel Bandungan
2011-08-27
re: Parse delimited string in a Stored procedure
Hi Webmaster, commenters and everybody else !!! The blog was absolutely fantastic! Lots of great information and inspiration, both of which we all need!Keep `em coming. you all do such a great job at such Concepts. can't tell you how much I, for one appreciate all you do!

alat kesehatan
2011-08-28
re: Parse delimited string in a Stored procedure
I Nebulizer siteas an model - very clean and great magnificent style and design, not to mention the content. You are an expert in this topic!alat kesehatan | medical equipment

hcg diet
2011-08-30
re: Parse delimited string in a Stored procedure
amazing, i am wondering how people could easily come up with a post like this.

verver
2011-09-04
re: Parse delimited string in a Stored procedure
Great, really helpful

Automated Money Machine
2011-09-06
re: Parse delimited string in a Stored procedure
Thanks for the incredible blog information, very visible in the search engines BTW

Russian Translation
2011-09-06
re: Parse delimited string in a Stored procedure
Great stuff, now lets see how long these links post on your page and how long they stick

speci
2011-09-06
re: Parse delimited string in a Stored procedure
Thank you for this very informational blog.
MyP2p


Fashion Wanita
2011-09-07
re: Parse delimited string in a Stored procedure
Hi Webmaster, commenters and everybody else !!! The blog was absolutely fantastic! Lots of great information and inspiration, both of which we all need!Keep `em coming. you all do such a great job at such Concepts. can't tell you how much I, for one appreciate all you do!

Grosir Baju | Baju Wanita

Promo video
2011-09-07
re: Parse delimited string in a Stored procedure
Inquisitive being - this author.

Taxeringskalender
2011-09-07
re: Parse delimited string in a Stored procedure
I absolutely take pleasure in just reading all of your weblogs. Simply wanted to inform you that you have folks like me who value your work

currency converter
2011-09-09
re: Parse delimited string in a Stored procedure
nice article, i just finished bookmarking it for future reference. i would love to read on future posts. how do i configure the rss again? thanks!
currency converter

personal injury lawyer
2011-09-10
re: Parse delimited string in a Stored procedure
I can see very well. Especially in terms of finding the best places we can find to do this kind of tourism and vacationing.

stream
2011-09-11
re: Parse delimited string in a Stored procedure
u have a good things here.tnx for sharing.
Streaming Film
MyP2p

Manchester napoli
2011-09-12
re: Parse delimited string in a Stored procedure
hello...very nice blog

Mancherster
2011-09-12
re: Parse delimited string in a Stored procedure
holla... i just finished bookmarking it for future reference. i would love to read on future posts.
Manchester City Napoli Streaming

Ultrasound tech
2011-09-14
re: Parse delimited string in a Stored procedure
After reading your post especially the examples, I know how to splic the array inside the stored proc. Thank you for sharing your knowledge with us!

Udinese Rennes Streaming
2011-09-14
re: Parse delimited string in a Stored procedure
A very good and informative article indeed.I am very much satisfied for the great technology is visible in this blog.Nice and informative website by the way.
Udinese Rennes Streaming

personal injury lawyer
2011-09-16
re: Parse delimited string in a Stored procedure
Sometimes we need to pass an array to the Stored Procrdure and split the array inside the stored proc.

Inter Roma Streaming Diretta
2011-09-17
re: Parse delimited string in a Stored procedure
After reading your post especially the examples

Inter Roma Streaming
2011-09-17
re: Parse delimited string in a Stored procedure

Your blog is important; the matter is something that not a lot of people are talking intelligently about. I’m really happy that I stumbled across this in my search for something relating to it. Thanks for it.



marketing winston salem nc
2011-09-18
re: Parse delimited string in a Stored procedure
I love the cool and great post comments!

ways to get taller
2011-09-20
re: Parse delimited string in a Stored procedure
That is this kind of an excellent resource that you are providing and also you give it away at no cost. I get pleasure from seeing web websites that understand the worth of supplying a prime useful resource at no cost.

symptoms of a dry socket
2011-09-20
re: Parse delimited string in a Stored procedure
It is great to achieve the opportunity to read a fantastic quality article with useful information on topics that plenty have an interest on.

Vicenza Livorno Streaming
2011-09-22
re: Parse delimited string in a Stored procedure
I love the cool and great post comments!!!!

husqvarna chainsaw reviews
2011-09-22
re: Parse delimited string in a Stored procedure
Many thanks a complete lot for talking about this make a difference. I concur along with your conclusions.The position which the data said are all original hand on real encounters even aid a great deal far more.

Bologna Inter Streaming
2011-09-23
re: Parse delimited string in a Stored procedure
holaa.!!

web seo services
2011-09-24
re: Parse delimited string in a Stored procedure
This is info is quit awesome and helpful. I hope you can keep up the good work and continue to provide more reliable and accurate information on the Internet. I will be coming back more often.

Calcio Serie A Streaming
2011-09-24
re: Parse delimited string in a Stored procedure
Really good info. thank you so much!!

calcio streaming
2011-09-26
re: Parse delimited string in a Stored procedure
Really good info.
Tnx very mutch

calcio streaming

Milan Viktoria Plzen Streaming
2011-09-27
re: Parse delimited string in a Stored procedure
Really good info.
Tnx very mutch!!za

Sporting Lazio Streaming Gratis
2011-09-28
re: Parse delimited string in a Stored procedure
welcoomee!!!

Candidiasis Tratamiento
2011-09-29
re: Parse delimited string in a Stored procedure
thanks a lot for sharing! those are big news!! :D

juventus milan streaming
2011-09-30
re: Parse delimited string in a Stored procedure
Nice post.
By juventus milan streaming

Streaming Megavideo Movies
2011-10-03
re: Parse delimited string in a Stored procedure
It is great to have the opportunity to read a good quality article with useful information on topics that plenty are interested on.
Streaming Megavideo Movies

omegle
2011-10-05
re: Parse delimited string in a Stored procedure
hello to everyone who has blog.first I congratulate the blog owner.he is got excellent blog.actually I read all your articles from weary and your writing very attractive waiting to continue thanks

Come fare soldi
2011-10-07
re: Parse delimited string in a Stored procedure
Really professional article many thanks Come fare soldi

Vampire Diaries Megavideo
2011-10-09
re: Parse delimited string in a Stored procedure
This procedure is really good. Thanks

projekty tanich domow
2011-10-12
re: Parse delimited string in a Stored procedure
Thanks for sharing!It is a great article!I hope this will help me.

eco friendly wedding invitation
2011-10-12
re: Parse delimited string in a Stored procedure
If you use to remotely connect to your servers, you've probably encountered a clipboard issue where copy/paste stops working.

Wireless alarm kit
2011-10-15
re: Parse delimited string in a Stored procedure
Everyday, I get to read and cruise around the web, and this day, I landed in your site, I was really entertained with the contents of your site.
Wireless alarm kit

tajer
2011-10-19
re: Parse delimited string in a Stored procedure
Thanks for sharing this to us. Chiropractic Adjustment Chiropractors Toronto

Virtual Credit Card Machine
2011-10-22
re: Parse delimited string in a Stored procedure
I read all your articles from weary and your writing very attractive waiting to continue thanks .

szkola policealna poznan
2011-10-22
re: Parse delimited string in a Stored procedure
hey, and it is something very special, and something so unique. life is built on greatness

costume wig
2011-10-24
re: Parse delimited string in a Stored procedure
hello there and thanks for your information - I've certainly picked up anything new from right here. I did on the other hand experience a few technical issues the usage of this web site, since I experienced to reload the site lots of times prior to I may get it to load correctly. I were brooding about if your web hosting is OK? No longer that I'm complaining, but sluggish loading circumstances times will very frequently impact your placement in google and can injury your quality score if ads and advertising with Adwords. Well I am adding this RSS to my e-mail and can glance out for much more of your respective fascinating content. Ensure that you replace this once more soon..

Video Belen
2011-10-25
re: Parse delimited string in a Stored procedure
thanks a lot for sharing! those are big news!! :D

sohbet
2011-10-25
re: Parse delimited string in a Stored procedure
No longer that I'm complaining, but sluggish loading thanks

arçelik servis servisi
2011-10-26
re: Parse delimited string in a Stored procedure
thank you so muuch

Download TV Show
2011-10-26
re: Parse delimited string in a Stored procedure
It’s hard to find knowledgeable people on this topic, but you sound like you know what you’re talking about!

Icey Tek Coolers
2011-10-26
re: Parse delimited string in a Stored procedure
Very difficult explanation and unreadable code. I do not understand it. Moreover, I don't understand what it need to do... Too complicated.

isatori
2011-10-28
re: Parse delimited string in a Stored procedure
Very difficult explanation and unreadable code. I do not understand it. Moreover, I don't understand what it need to do.

Escort
2011-10-29
re: Parse delimited string in a Stored procedure
I had a fun time reading the different information on this site. I will definitely view this great web page in the near future.

handbag dogs
2011-11-02
re: Parse delimited string in a Stored procedure
You have some truly useful code there!

cheap costume wigs
2011-11-03
re: Parse delimited string in a Stored procedure
Alright, that was an inspiration for me. I am thinking of my personal website

Best E-business and Marketing Si
2011-11-03
re: Parse delimited string in a Stored procedure
Men always like to have information on his/her subject of interest from the internet.So all the site should be arranged in a nice manner like this so that men can be highly helped by these sites.

iPhone4
2011-11-03
re: Parse delimited string in a Stored procedure
Do you mind if we use this piece of code in our own projects?

how to stop premature ejaculatio
2011-11-04
re: Parse delimited string in a Stored procedure
Is it possible to do this with 2 input arrays and return a 2 column table?

Sam
2011-11-06
re: Parse delimited string in a Stored procedure
How to do this in a php script ?

Top Listings
2011-11-08
re: Parse delimited string in a Stored procedure
I search about these codes before many days and today I find them in your blog. I can’t forget this information in whole life

kortingsbonnen
2011-11-09
re: Parse delimited string in a Stored procedure
Do you mind if we use this piece of code in our own projects?

Brij Sharma
2011-11-09
re: Parse delimited string in a Stored procedure
Thanks I have used the solution many times.
But now I am having an issue.
The items which I want to pass as string are themselves string and can contain any character as they is accepted from user. Even if I restrict a character like "#" and use it as a separator, I am doubting about the max size of varchar, as all the items once concatenated can become huge in size like 8000 to 10000 characters. Besides this performance issues might also come in.
Please help

electric range information
2011-11-10
re: Parse delimited string in a Stored procedure
It is quite hard to find a well written post in the net nowadays.

prepaid telefoons
2011-11-10
re: Parse delimited string in a Stored procedure
Thank you for this very informational blog. It's really help a lot in my work. Great Job man

Davis william
2011-11-11
re: Parse delimited string in a Stored procedure
Stored Procedures is the very powerful concept of Database. Thanx for posting such valuable topic. Atlanta bankruptcy lawyer

貸款
2011-11-11
re: Parse delimited string in a Stored procedure
I really agree with you. I am waiting for your furhter information. THank you.

Jungle Safari India
2011-11-12
re: Parse delimited string in a Stored procedure
Very nice explanation.

Internapolicity
2011-11-12
re: Parse delimited string in a Stored procedure
Hi, I'm so excited that I have found this your post because I have been searching for some information about it almost three hours. You helped me a lot indeed and reading this your article I have found many new and useful information about this subject. Thanks for sharing this!

frontline plus
2011-11-14
re: Parse delimited string in a Stored procedure
This post was very nicely written, and it also contains many useful facts. I enjoyed your distinguished way of writing this post.

best cyber monday deals 2011
2011-11-15
re: Parse delimited string in a Stored procedure
Very good article. I bookmarked it and I follow your future post.

aircraft insurance
2011-11-16
re: Parse delimited string in a Stored procedure
Thanks on your marvelous posting! I really enjoyed reading it. I will be sure to bookmark your blog and will eventually come back at some point. I want to encourage you to definitely continue your writing, have a nice afternoon!

mo
2011-11-16
re: Parse delimited string in a Stored procedure
very informative kep up the good work wholesale trade


Xbingo
2011-11-17
re: Parse delimited string in a Stored procedure
I am very much happy to read this excellent post, because it is my favorite subject in the world. I enjoy this site and I will come back again.

el buen fin
2011-11-18
re: Parse delimited string in a Stored procedure
Thank you for the work you have put into this post, it helps clear up some questions I had.I will bookmark your blog because your posts are very informative.We appreciate your posts and look forward to coming back..

how do you get your ex back
2011-11-18
re: Parse delimited string in a Stored procedure
how would you use this passing it a field from a table... ie my table has a field (field1 varchar)

mw3
2011-11-18
re: Parse delimited string in a Stored procedure
This is a spectacular article that I have really enjoyed. Hopefully I can learn more from your valuable experience. Thanks a lot for sharing this and please keep on posting more.

Online Business Directory
2011-11-19
re: Parse delimited string in a Stored procedure
I am very interested for this post.This site is so helpful. So i want some information for sharing this side with some of my friend. Thanks.

jobs on oil rigs
2011-11-20
re: Parse delimited string in a Stored procedure
Definitely an informative post. It is really great to find post which are very informative and well written like this.

shake weight results
2011-11-20
re: Parse delimited string in a Stored procedure
Thank you this code, I'll be using it with phone numbers

Malchow
2011-11-21
re: Parse delimited string in a Stored procedure
Another great tutorial!

cricket live streaming
2011-11-21
re: Parse delimited string in a Stored procedure
These are a good post. This post give genuinely quality information thank you very much

Napoli Manchester City Streaming
2011-11-21
re: Parse delimited string in a Stored procedure
good post

Premium Web Directory
2011-11-23
re: Parse delimited string in a Stored procedure
I revealed reading it. I require to read more on this topic...I am admiring the time and effort you put in your blog, because it is obviously one great place where I can find lot of functional info...

social networks mining
2011-11-23
re: Parse delimited string in a Stored procedure
Some may have a hard time understanding codes such these. Although it really conveyed useful information.

Nama Bayi
2011-11-24
re: Parse delimited string in a Stored procedure
I will try this coding
This really helped me
thank


Arti Nama
2011-11-28
re: Parse delimited string in a Stored procedure
coding is the same as in my college
This is very helpful. I'll learn here


Car Rental in Europe
2011-11-28
re: Parse delimited string in a Stored procedure
Thanx for a very interesting web site. Where else could I get that kind of info written in such an ideal approach? I have a undertaking that I'm just now working on, and I've been at the look out for such information.

scott carson med1onlin
2011-11-29
re: Parse delimited string in a Stored procedure
I appreciate your hard work on making this information available to us. Thank you very much.
scott carson med1online

usa vpn
2011-12-02
re: Parse delimited string in a Stored procedure
really very good tips thanks a lot for this

Online Shopping in BD
2011-12-02
re: Parse delimited string in a Stored procedure
Since I have been visiting this site I got some useful post full of necessary information. I often visit this site for being updated with such useful information.

Candidiasis Tratamiento
2011-12-02
re: Parse delimited string in a Stored procedure
wow, I love this kind of info you know, you can find very informative things such searching, take care.
candidiasis tratamiento

Business Directory
2011-12-06
re: Parse delimited string in a Stored procedure
Since I have been visiting this site I got some useful post full of necessary information. I often visit this site....

Kool Web Directory
2011-12-08
re: Parse delimited string in a Stored procedure
I have a undertaking that I'm just now working on, and I've been at the look out for such information.

Kool Web Directory

toko online jual sepatu murah
2011-12-08
re: Parse delimited string in a Stored procedure
Wow! This could be one of the most beneficial blogs we've ever come across on thesubject. Actually magnificent post! I am also an expert in this topic so I can understand your hard work.
grosir sepatu sandal kulit online

Business Directory
2011-12-10
re: Parse delimited string in a Stored procedure
These posts are really good and interesting.
Business Directory

Brainetics reviews
2011-12-10
re: Parse delimited string in a Stored procedure
This would help me and many other users to have a quick look at the documentation in any case. I’m bookmarking the page and would send this to my fellow friends who would be interested in this.

puspve
2011-12-10
re: Parse delimited string in a Stored procedure
Nonetheless since the development of the web majority of the stocks are traded via the net therefore bringing a new turn to OTC trading. This system is often known as Trading Software Platform.

Web Listings
2011-12-11
re: Parse delimited string in a Stored procedure
Your blog is good and sharing great informational. I read your other post as well, all were good. I really appreciate the author.

http://sciaticatreatment.me
2011-12-11
re: Parse delimited string in a Stored procedure
nicely formated post, very helpful thanks

Online Business Directory
2011-12-12
re: Parse delimited string in a Stored procedure
I am very interested for this post.This site is so helpful. So i want some information for sharing this side with some of my friend. Thanks......

film streaming ita megavideo
2011-12-12
re: Parse delimited string in a Stored procedure
clouds to join them in bewailing, and washing the nature with its sad rain drops. While the deceased faces, are sleeping gently, as fair jasmines, you can see the shiny drops of ruby, ki

Dig Marks
2011-12-13
re: Parse delimited string in a Stored procedure
Honestly, I have not been into this Parse delimited String or something. But I got interested in this thing. I will make some research regarding this perhaps this idea can be beneficial in my part. Thanks for posting in!

Business Directory
2011-12-13
re: Parse delimited string in a Stored procedure
Function can only return one value.. You will have to call the function twice..

smatedarren
2011-12-14
re: Parse delimited string in a Stored procedure
Terrific post, I’ve bookmarked this site so hopefully I will discover much more on this topic in the foreseeable future.

Smoke Deter

aed
2011-12-14
re: Parse delimited string in a Stored procedure
awesome! thank you so much!! Thanks.

car service to airport
2011-12-15
re: Parse delimited string in a Stored procedure
i've been looking for these codes and i really appreciate your act of sharing. very helpful for my project. thanks man!

www.Funcostumewigs.com
2011-12-20
re: Parse delimited string in a Stored procedure
Happen to be in search of this and discovered a lot more than anticipated here. Thanks.

PaintballToronto
2011-12-27
re: Parse delimited string in a Stored procedure
Unlimited information I found here. Thanks for sharing those helpful links guys.

Azithromycin uses
2011-12-28
re: Parse delimited string in a Stored procedure
I have not been into this Parse delimited String or something. But I got interested in this thing. I will make some research regarding this perhaps this idea can be beneficial in my part.Azithromycin uses

cacko
2012-01-03
re: Parse delimited string in a Stored procedure
Thanks for providing this good informative post and i got a good knowledge from your blog, i think most of the peoples are get good benefited from this information. Streaming Megaupload ITA

dotka
2012-01-05
re: Parse delimited string in a Stored procedure
I'm impressed. I don't think I've met anyone who knows as much about this subject as you do. You're truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. Film Streaming Ita Megavideo

sprei
2012-01-09
re: Parse delimited string in a Stored procedure
You're so cool! I don't think I've read anything like this before. So good to find somebody with some original thoughts on this subject.

garage remote control
2012-01-10
re: Parse delimited string in a Stored procedure
it would be easier to concatenate all the orderid's into one string like 10-24-23-34-56-57-....etc and pass it to the sql server stored proc and inside the stored proc, split the string into individual ids and delete each sales order.

sprei murah
2012-01-11
re: Parse delimited string in a Stored procedure
A stored procedure is a subroutine available to applications that access a relational database system. A stored procedure (sometimes called a proc, sproc, StoPro, StoredProc, or SP) is actually stored in the database data dictionary.

Film Streaming Megavideo Ita
2012-01-14
re: Parse delimited string in a Stored procedure
This is really nice of you to share such information with us, thumbs Up. I will keep coming back to recheck you blog.

Alper
2012-01-15
re: Parse delimited string in a Stored procedure
very useful information but should be in more detail

ECU Remapping
2012-01-20
re: Parse delimited string in a Stored procedure
Thankyou so much, finally. Been looking for this code.

Bolig indretning
2012-01-20
re: Parse delimited string in a Stored procedure
Great and an awesome post. Thanks for sharing.

Manhole
2012-01-20
re: Parse delimited string in a Stored procedure
But along with the factor of safety and performance there is an alternative SQL statement to be wrapped in a Stored procedure.

http://www.webyipee.com/
2012-01-26
re: Parse delimited string in a Stored procedure
You helped me a lot indeed and reading this your article I have found many new and useful information about this subject. Thanks for sharing this!

franchise history
2012-01-30
re: Parse delimited string in a Stored procedure
I see that now, it has become the thing that makes us more alert to what is happening. And this is very good for us. I believe it. Quite exciting for me. franchise history


business for sale sunshine coast
2012-01-31
re: Parse delimited string in a Stored procedure
I will be here to check more updates and topics thanks for the wonderful post. business for sale sunshine coast


Online Shopping in BD
2012-01-31
re: Parse delimited string in a Stored procedure
I have to admit that I have been searching for this information for a long time. Reading this wonderful publication I have known many new things about it which I have not known before. As I see all your articles are informative and full of valuable information so I will definitely bookmark your website and wait for more such great posts like this one. So huge thanks for publishing this article here, without you I would never known about such a thing ever.

tas impor
2012-02-09
re: Parse delimited string in a Stored procedure
so this is possible to do, thanks a lot for the code, maybe this what im looking for,i hope this gonna help me especially to my site

tøj til store kvinder
2012-02-14
re: Parse delimited string in a Stored procedure
Really great and excellent post. Thanks.

Premium Web Directory
2012-02-14
re: Parse delimited string in a Stored procedure
I really appreciate your way of presenting this post with a excellent suggestion.I want some more about this article. Since I am the frequent visitor to this web.

Business Directory
2012-02-21
re: Parse delimited string in a Stored procedure
Wonderful wordpress blog right here.. It is hard to locate top quality composing like yours today. I actually recognize folks like you !

best cupcake melbourne
2012-02-22
re: Parse delimited string in a Stored procedure
Procedure will read a data from “tmp” table and will split data by my_delimiter delimiter and generate a temporary table.

plus size clothing uk
2012-02-23
re: Parse delimited string in a Stored procedure
Its good resource to me and i love this blazon of stuff. Good and adorable advice I take from it. so you can actualize create more blog with good stuff.

mode für mollige damen
2012-02-29
re: Parse delimited string in a Stored procedure
I use this blog this is very informative and i like this blog.So thank you very much for sharing this information.

best light weight upright vacuum
2012-02-29
re: Parse delimited string in a Stored procedure
I assure this would be helpful for most of the people. thanks for sharing.This is certainly a content thats close to me so I am very pleased that you wrote about this. The aricle is very interesting. You are generally a very skilled writer.

miele vacuum accessories
2012-02-29
re: Parse delimited string in a Stored procedure
I just liked the article. It was Very refreshing post with attractive ideas.It was great to read your blog. The ideas are very well laid out and it was refreshing to read.

Salt Lake City Bankruptcy Lawyer
2012-03-15
re: Parse delimited string in a Stored procedure
You can find surely a lot of particulars like that to think about. All are great pints to ponder for. I now take into account the suggestions about as widespread inspiration.

Haarverlängerung München
2012-03-17
re: Parse delimited string in a Stored procedure
I fully appreciate the subject matter this blog contains, It's have been a good trick to have urban farming this and off course I would respect the view of Allen to who wants to need these gardens in every community, and at least in every park.

store størrelser
2012-03-26
re: Parse delimited string in a Stored procedure
It’s good to see this information in your post, I was looking the same but there was not any proper resource, thanx now I Thank to the post.I really loved reading your blog.It was very well authored and easy to understand.

Atlanta coach
2012-03-30
re: Parse delimited string in a Stored procedure
What a way to explain some thing technical in different style. I like your style. keep it up.

jaket motor
2012-04-12
re: Parse delimited string in a Stored procedure
I am often to blogging and i really respect your content. The article has really peaks my interest. I am going to bookmark your site and preserve checking for new information.

Jörg Weißbrodt
2012-04-26
re: Parse delimited string in a Stored procedure
Great and very excellent post.Thanks.

404 cut tree
2012-05-22
re: Parse delimited string in a Stored procedure
Thanks for the stuff on stored procedure. I think it is very useful for me so that i can try it.

beliani.ca
2012-05-25
re: Parse delimited string in a Stored procedure
Thanks buddy! visit my site and give your feed back. You can check it:-)

http://www.privatkreditsofort.ch
2012-06-21
re: Parse delimited string in a Stored procedure
The Culture Ministry accepted his song “A Hard Rain’s A-Gonna Fall,” perhaps because it’s often examined in the context of the Cuban Missile Crisis.

Atlanta transportation
2012-07-05
re: Parse delimited string in a Stored procedure
I will try it if everything is ok. But thanks for your effort. A great tips for me.

almtor
2012-08-13
re: Parse delimited string in a Stored procedure
Great site, very interesting for me.

torgutachter
2012-08-29
re: Parse delimited string in a Stored procedure
Interesting site. greetings from Germany

feminmoda
2012-09-01
re: Parse delimited string in a Stored procedure
Thanks for the code helpfull for us

haarpunkt
2012-09-07
re: Parse delimited string in a Stored procedure
Interesting site. Greetings from germany

PS Bookmarks
2012-09-08
re: Parse delimited string in a Stored procedure
I found lots of interesting information here.Great work. The post was professionally written and I feel like the author has extensive knowledge in this subject. Nice post.

susi kaos grosir
2012-09-14
re: Parse delimited string in a Stored procedure
Hi

Thank you very much

Bing Marks
2012-09-14
re: Parse delimited string in a Stored procedure
I will make some research regarding this perhaps this idea can be beneficial in my part. Thanks for posting in!

çet sohbet
2012-10-02
re: Parse delimited string in a Stored procedure
Thanks for your explanation was very good effort, while health information in your hand


fruy
2012-10-04
re: Parse delimited string in a Stored procedure
I am happy to found such useful and interesting post which is written in well maner.

tunhaies
2012-10-04
re: Parse delimited string in a Stored procedure
thank you nice admin