AngelEyes on .Net

Tips, tricks and WTFs about Asp .Net, SQL Server and the likes.
posts - 54 , comments - 235 , trackbacks - 6

My Links

News

Tag Cloud

Article Categories

Archives

3rd party

Official ASP .NET

Useful info

SQL Server split function

This is used to "use list as a table", i.e. take a list of comma-separated values, and run queries on it.
Credits due: look at the second post on http://searchvb.techtarget.com/tip/0,289483,sid8_gci932171,00.html
 
CREATE FUNCTION dbo.fnSplit(
@sInputList VARCHAR(8000) -- List of delimited items
, @sDelimiter VARCHAR(8000) = ',' -- delimiter that separates items
) RETURNS @List TABLE (item VARCHAR(8000))

BEGIN
DECLARE @sItem VARCHAR(8000)
WHILE CHARINDEX(@sDelimiter,@sInputList,0) <> 0
BEGIN
SELECT
@sItem=RTRIM(LTRIM(SUBSTRING(@sInputList,1,CHARINDEX(@sDelimiter,@sInputList,0)-1))),
@sInputList=RTRIM(LTRIM(SUBSTRING(@sInputList,CHARINDEX(@sDelimiter,@sInputList,0)+LEN(@sDelimiter),LEN(@sInputList))))

IF LEN(@sItem) > 0
INSERT INTO @List SELECT @sItem
END

IF LEN(@sInputList) > 0
INSERT INTO @List SELECT @sInputList -- Put the last item in
RETURN
END
GO
--Test
select * from fnSplit('1,22,333,444,,5555,666', ',')
select * from fnSplit('1##22#333##444','##') --note second item has embedded #
select * from fnSplit('1 22 333 444 5555 666', ' ')

Print | posted on Thursday, April 12, 2007 6:54 AM |

Feedback

Gravatar

# re: SQL Server split function

Thanks, this is very useful.
/Daniel
1/16/2008 4:15 PM | Daniel
Gravatar

# re: SQL Server split function

Thanks, Daniel.
1/16/2008 4:32 PM | Angel Eyes
Gravatar

# re: SQL Server split function

thanks

5/7/2008 10:48 PM | bylove
Gravatar

# re: SQL Server split function

Thanks a lot
6/13/2008 9:14 AM | Rachana
Gravatar

# re: SQL Server split function

Thanks a lot. Its very useful.
7/15/2008 8:46 PM | falguni
Gravatar

# to falguni

Glad to have helped :-)
7/15/2008 8:59 PM | angel eyes
Gravatar

# re: SQL Server split function

Sure thing.
7/26/2008 10:04 AM | angel eyes
Gravatar

# re: SQL Server split function

This is great! :)

If I then want to get back only the nth row from the resulting table how would I get it? I would presume there is some sort of rownum function that we can use?
7/29/2008 2:47 PM | Andrew McGimpsey
Gravatar

# re: get back only the nth row from the resulting table

Assuming you want to keep the resulting table, you can add RowNumber(), like this:
select ROW_NUMBER() over (order by item) as RowNum, * from fnSplit('1,22,333,444,,5555,666', ',')

And then get the 4th row like this:
select * from
(select ROW_NUMBER() over (order by item) as RowNum, * from fnSplit('1,22,333,444,,5555,666', ',')) tt
where RowNum = 4
7/29/2008 5:16 PM | angel eyes
Gravatar

# re: SQL Server split function

Good f(x)
8/1/2008 6:51 AM | gsd
Gravatar

# re: SQL Server split function

Hi
I was write this sp :

UPDATE TBLMessages
SET Location = @Location, FolderID = @FolderID
WHERE (dbo.TBLMessages.MsgID in (SELECT item FROM dbo.FnSplit(MsgID,',')))

But It Updates All Records !!!
9/17/2008 7:37 AM | Ali
Gravatar

# re: Ali

Ali, your query doesn't make much sense. what were you trying to do, and what does the MsgID field contain?
9/17/2008 9:03 AM | angel eyes
Gravatar

# re: SQL Server split function

If I were trying to use this to split a column that I select, how would I do that?

For example, say we have some customer numbers that are set up in a special fashion like 000-xxx-xxx, and others that are set up like normal numbers areacode-prefix-number, and I want to throw that into a case when and pull a list of how many users we have set up like that, kind of like this:

SELECT SUM(CASE WHEN (SELECT item FROM (SELECT ROW_NUMBER() OVER (ORDER BY item) AS RowNum, * FROM fnSplit(SELECT dbo.CUSTOMER.PHONE_NUM FROM dbo.CUSTOMER WHERE CUSTOMER.CUST_ID=1234, '-')) drvTbl WHERE RowNum = 1) THEN 1 ELSE 0 END) AS IRREGULAR_COUNT FROM dbo.CUSTOMER

The fnSplit function doesn't allow me to throw a select statement in it (or maybe I'm just missing something here).

Any ideas?
9/26/2008 6:55 PM | Matt
Gravatar

# re: SQL Server split function

Yea, I figured that out after banging my head against the wall for an hour or so. I have a tendancy to overthink things sometimes, haha.

Thanks for the reply, and the great blog.
9/30/2008 12:59 AM | Matt
Gravatar

# re: SQL Server split function

Is there a way to use fnsplit on a column that is selected?

For example:
select * from dbo.fnsplit(select prov_title from provider where prov_title > ' ')

This doesn't work.
10/15/2008 4:12 PM | Marcie
Gravatar

# Marcie

Hey Marcie.
To my knowledge, you cannot use the function like that, in a query.
You can use a cursor to do the same thing, but of course you'll have to watch the performance.
10/15/2008 8:24 PM | angel eyes
Gravatar

# re: SQL Server split function

Thanks!
It's very useful to me.

11/11/2008 9:33 AM | fatty0860
Gravatar

# re: SQL Server split function

Thanks a Lot.
12/29/2008 11:52 AM | Baljeet Singh
Gravatar

# To: fatty0860 and Baljeet Singh

Sure, glad to be of help.
12/29/2008 8:17 PM | Angel Eyes
Gravatar

# re: SQL Server split function

Hello,

how can I use this function with a cursor?

I want to use this function like this example:
select * from dbo.fnsplit(select prov_title from provider where prov_title > ' ')
3/5/2009 4:01 PM | Devil
Gravatar

# re: club penguin

Thanks, Club Penguin, it means a lot!
3/26/2009 12:15 PM | Angel Eyes
Gravatar

# re: SQL Server split function

Thanks!
It's very useful to me.
3/26/2009 1:41 PM | porno izle
Gravatar

# Turkey Tourism

Thanks for writing.but please letters be more big.:)
3/26/2009 4:28 PM | tourist book
Gravatar

# re: SQL Server split function

Thanks you
3/26/2009 6:04 PM | Diyarbakir
Gravatar

# re: SQL Server split function

thanks you
3/26/2009 6:20 PM | pornoizle
Gravatar

# re: SQL Server split function

Thank you very useful information.
3/26/2009 7:23 PM | oyun indir
Gravatar

# re: SQL Server split function

thanks a lot..
3/26/2009 7:58 PM | türk porno izle
Gravatar

# re: SQL Server split function

Very thanks.
3/26/2009 9:07 PM | ali veli
Gravatar

# re: SQL Server split function

Very nice, thanks.....
3/26/2009 9:29 PM | Downloadic
Gravatar

# re: SQL Server split function

Hı :) Thank you post...

SMF Destek

3/26/2009 10:25 PM | SMF Destek
Gravatar

# re: SQL Server split function

Thanks for articles.
3/26/2009 10:31 PM | Porno Sikiş
Gravatar

# re: SQL Server split function

Sorry my english firstly, i read well but i cant write :), So its useful post for me and i bookmarked your blog.

wordpress themes

web tasarım
3/26/2009 10:56 PM | free wordpress themes
Gravatar

# re: tourist book

I'll change the fonts, or the whole theme :-)
3/27/2009 12:16 PM | Angel Eyes
Gravatar

# re: SQL Server split function

Thank you for information.
3/27/2009 1:59 PM | worldmp3
Gravatar

# re: SQL Server split function

useful article, many thanks.


Daily Linux News
web hosting
3/28/2009 12:19 PM | Sezer DEGE
Gravatar

# re: SQL Server split function

i have modified to return item at specified index:

ALTER FUNCTION [dbo].[split](@sInputList VARCHAR(8000),@sDelimiter VARCHAR(8000) = ',',@Index INT)
RETURNS NVARCHAR(4000)
BEGIN
DECLARE @sItem VARCHAR(8000)
DECLARE @retval NVARCHAR(4000)
DECLARE @tempIndex INT
DECLARE @List TABLE(item VARCHAR(8000))
SET @tempIndex = 0
WHILE Charindex(@sDelimiter,@sInputList,0) <> 0
BEGIN
SELECT @sItem = Rtrim(Ltrim(Substring(@sInputList,1,Charindex(@sDelimiter,@sInputList,0) - 1))),
@sInputList = Rtrim(Ltrim(Substring(@sInputList,Charindex(@sDelimiter,@sInputList,0) + Len(@sDelimiter),
Len(@sInputList))))
IF Len(@sItem) > 0
INSERT INTO @List
SELECT @sItem
IF (@tempIndex = @Index)
SET @retval = @sItem
SET @tempIndex = @tempIndex + 1
END
IF Len(@sInputList) > 0
INSERT INTO @List
SELECT @sInputList -- Put the last item in
IF (@tempIndex = @Index)
SET @retval = @sItem
RETURN @retval
END
GO
4/10/2009 12:23 AM | francisco
Gravatar

# re: SQL Server split function

Way to go, Fransisco, Thanks for letting us know about it!
4/10/2009 11:09 AM | re: francisco
Gravatar

# re: SQL Server split function

This doesn't work if space is your actual separator. ie there should be a NULL item, ala the first test, in the third test. As written extra spaces are discarded.
4/22/2009 6:46 PM | Tobar
Gravatar

# re: SQL Server split function

By "this" I was referring to the original post.

Here is a fix. Why in the world MS thought it smart to not count a space in the len() function is beyond me.

drop function dbo.fnSplit

go

CREATE FUNCTION dbo.fnSplit(
@sInputList VARCHAR(8000) -- List of delimited items
, @sDelimiter VARCHAR(8000) = ',' -- delimiter that separates items
) RETURNS @List TABLE (item VARCHAR(8000))

BEGIN
DECLARE @sItem VARCHAR(8000)
WHILE CHARINDEX(@sDelimiter,@sInputList,0) <> 0
BEGIN
SELECT
@sItem=SUBSTRING(@sInputList,1,CHARINDEX(@sDelimiter,@sInputList,0)-1),
@sInputList=SUBSTRING(@sInputList,CHARINDEX(@sDelimiter,@sInputList,0)+DATALENGTH(@sDelimiter),DATALENGTH(@sInputList))

IF LEN(@sItem) > 0
INSERT INTO @List SELECT @sItem
ELSE IF LEN(@sItem) = 0
INSERT INTO @List SELECT NULL
END

IF LEN(@sInputList) > 0
INSERT INTO @List SELECT @sInputList -- Put the last item in
RETURN
END
GO
--Test
select * from fnSplit('1,22,333,444,,5555,666', ',')
select * from fnSplit('1##22#333##444','##') --note second item has embedded #
select * from fnSplit('1 22 333 444 5555 666', ' ')
4/22/2009 8:55 PM | Tobar
Gravatar

# re: SQL Server split function

Thanks ,for articles.
5/8/2009 6:44 PM | Ali
Gravatar

# EMİRCAN OTO KİRALAMA ANKARA

Thank you

6/22/2009 8:34 AM | Cihan
Gravatar

# LÜKS OTO KİRALAMA ANKARA EMİRCAN

mersi şekerim
6/22/2009 8:39 AM | Ciko
Gravatar

# re: SQL Server split function

Nice work. Was just about to write this myself then thought I should see if somebody else had already posted a solution before I reinvented the wheel. Now that's the proper meaning of resuable code.
7/8/2009 7:21 AM | Sunshine Coast Web Designer
Gravatar

# re: SQL Server split function

thanks admins very nicess
7/8/2009 2:25 PM | güncel blog
Gravatar

# re: SQL Server split function

thanks you goods
7/8/2009 2:27 PM | video seyret
Gravatar

# re: SQL Server split function

Good on your
7/18/2009 9:52 AM | Lida
Gravatar

# re: SQL Server split function

THanks a lot
7/18/2009 9:54 AM | Lida
Gravatar

# re: SQL Server split function

Lot name a
7/18/2009 9:54 AM | Lida
Gravatar

# prefabrik fiyatları

Thanks for the reply, and the great blog.
8/7/2009 12:35 PM | prefabrik fiyatlari
Gravatar

# re: SQL Server split function

Thanks for the reply, and the great blog.
8/12/2009 10:10 PM | Diyarbakir
Gravatar

# re: SQL Server split function

Good on your
8/12/2009 10:10 PM | Urls
Gravatar

# re: SQL Server split function

very useful command.thanks for that
9/9/2009 12:17 PM | evden eve nakliyat
Gravatar

# re: SQL Server split function

THanks a lot
10/5/2009 2:34 PM | invention of lying online
Gravatar

# re: SQL Server split function

thanks admins very nicess
11/15/2009 8:32 PM | Forum
Gravatar

# re: SQL Server split function

It's very help full to me thanks
12/24/2009 10:56 AM | Sunil Kumar Sharma
Gravatar

# re: SQL Server split function

very nice htanks
12/30/2009 1:53 PM | koçluk
Gravatar

# re: SQL Server split function

Well worth the read. Thanks for sharing this information. I got a chance to know about this.
1/23/2010 2:18 PM | Clasamente Fotbal
Gravatar

# re: SQL Server split function

love you
2/20/2010 9:18 AM | usama
Gravatar

# re: SQL Server split function

thanks adminss good very nicess
2/28/2010 12:49 PM | adult videolar
Gravatar

# re: SQL Server split function

hi its very useful but how can i use the split function to search a full name with 3 type of names(first,middle,last) name?

Plz its urgent Reply needed
3/19/2010 10:36 AM | SSdevi
Gravatar

# re: SSdevi

I'm sorry, I didn't understand your question.
3/19/2010 12:17 PM | Angel Eyes
Gravatar

# re:SQL Server split function

thanks adminss good very nicess
5/23/2010 3:12 AM | evden eve nakliyat
Gravatar

# esya

The first priority of the site administrator for your comments right know, thank you. Really very good information-sharing gives you.
Thanks in knowledge
5/23/2010 3:19 PM | chris
Gravatar

# re: SQL Server split function

thanks for this article
6/1/2010 3:01 PM | Meksika biberi zayıflama hapı
Gravatar

# re: SQL Server split function

It is good that you share this informations whit us.
6/22/2010 7:04 PM | rca ieftin 2011
Gravatar

# re: SQL Server split function

thank you man
8/4/2010 1:45 PM | web tasarım
Gravatar

# re: SQL Server split function

thanks for this article .
8/16/2010 2:30 AM | ucuz web tasarım
Gravatar

# re: SQL Server split function

Sending interactive content (changeable text, changeable images, forms, etc) to other users, websites and other applications. Like: if i want
8/26/2010 3:35 PM | prefabricated
Gravatar

# re: SQL Server split function

thanks for this article .
9/14/2010 11:45 AM | havuz
Gravatar

# re: SQL Server split function

thanks very much for sharing
9/14/2010 11:49 AM | peruk
Gravatar

# re: SQL Server split function

thanks very much
Gravatar

# re: SQL Server split function

thank you best regards. Goods rapids.
9/16/2010 2:53 AM | Resim Paylas
Gravatar

# re: SQL Server split function

great, thanks.
10/5/2010 2:01 PM | sa
Gravatar

# re: SQL Server split function

Thanks for article. Everytime watch blog like to read you
10/6/2010 9:35 PM | php görsel eğitim
Gravatar

# çocuk montu

thank you best regards. Goods rapids.
10/14/2010 12:23 PM | zafer
Gravatar

# çocukmont

thanks very much by man
10/14/2010 5:29 PM | zafer
Gravatar

# re: SQL Server split function

very good! thanks..
10/20/2010 1:40 PM | fotoğrafçı
Gravatar

# re: SQL Server split function

well done man. very good sharing..
10/21/2010 9:37 AM | havuz
Gravatar

# re: SQL Server split function

thank you. very interesting
10/21/2010 9:38 AM | peruk
Gravatar

# re: SQL Server split function

very well. thanks man
10/22/2010 9:20 PM | toptan takım elbise
Gravatar

# re: SQL Server split function

Super ...
10/27/2010 9:33 AM | Suresh
Gravatar

# re: SQL Server split function

Thank you admin good article
10/28/2010 9:04 PM | web tasarım
Gravatar

# ozaygroup

verytime watch blog like to read you
11/7/2010 5:35 PM | toptan takım elbise
Gravatar

# elestirel haber

Thanks for article.
11/7/2010 5:37 PM | maç özeti ve golleri
Gravatar

# re: SQL Server split function

It would be great if I could just say "movie Batman" and it would search Batman on IMDB, or "google firefox" and etc. In fact, my Eee PC has this functionality, so it stands to reason that Firefox could to. Anyway, those are just some of my thoughts off the top of my head. I'm sure that with some more thought a really well-built voice command extension could be built.

http://www.karmod.eu
11/12/2010 9:50 AM | prefabricated
Gravatar

# re: SQL Server split function

Thanks... I found it really useful
11/19/2010 11:52 AM | Rinkal
Gravatar

# re: SQL Server split function


I'm afraid it's all a fraud. Unfortunately, almost a decade only everything revolves around money. People who until recently had an enviable character fall prey to these temptations. Unfortunately, society as a whole began to decline and only fault I see greed. We humans would be to think that there are many other things more important than money. And maybe we will be able to change something in our thinking.
12/1/2010 1:03 PM | auto hibride
Gravatar

# re: SQL Server split function

Thanks Admin ,for articles.
12/11/2010 2:50 PM | Memocix
Gravatar

# Business Letters

As a business owner and sales professionals, I am sure we share many of the same problems. I am always have to write letters. I have to write a follow up letter, sales letter, thank you letter, welcome letter, and other legal and professional letters.

I have found a great Letter Template Tool that i would like to share with all business owners and Sales agents, reps, and professionals...

It has helped me save time and money...Check it out, and give it a try...
12/13/2010 4:50 AM | Sales Letters Template
Gravatar

# re: SQL Server split function

Greate article, congratulations !
12/17/2010 11:10 AM | Cel mai ieftin RCA
Gravatar

# re: SQL Server split function

clean and crisp solution..
http://www.a2zmenu.com/MySql/SQL-Split-Function.aspx
12/19/2010 11:59 AM | experts comment
Gravatar

# re: SQL Server split function

expression was very nice thank you Waiting for More
12/20/2010 2:49 PM | forex
Gravatar

# re: SQL Server split function

Unfortunately, society as a whole began to decline and only fault I see greed.
12/31/2010 2:59 PM | çilingir
Gravatar

# re: SQL Server split function

thanks for blogg..
1/10/2011 2:52 AM | resimler
Gravatar

# re: SQL Server split function

nice good job.
1/11/2011 6:20 PM | web tasarım
Gravatar

# re: SQL Server split function

thank you very much
1/18/2011 11:41 AM | fotoğraf çekimi
Gravatar

# re: SQL Server split function

Gravatar
Thanks a lot
1/23/2011 1:03 PM | samsun
Gravatar

# re: SQL Server split function

Thank you admin good article. Good job

web tasarım
1/28/2011 9:52 AM | web tasarımı
Gravatar

# re: SQL Server split function

Thank you admin good article. Good job

http://www.celilcan.com
1/28/2011 9:53 AM | web tasarımı
Gravatar

# re: SQL Server split function

Thank you admin
1/28/2011 9:56 AM | Webmaster Blog
Gravatar

# re: SQL Server split function

Thank you admin good article. Good job
1/29/2011 8:22 PM | umre kayıtları
Gravatar

# re: SQL Server split function

More Waiting for you to continually write articles I am following a very successfull
2/1/2011 5:44 PM | gelinlikler
Gravatar

# re: SQL Server split function

FYI:
If you use cross / outer apply you can join it to a table row by row without a cursor

http://www.mssqltips.com/tip.asp?tip=1958

select * from CF1 cf cross apply fnSplit(value_text,'$,$')
where value_text like '%$,$%'
2/2/2011 11:16 PM | Ed
Gravatar

# re: SQL Server split function

Thanks you very much! Wonderful comments, i am reading this blog and very happy now!

Thanks again!

2/7/2011 12:45 PM | çiçek sipasi gönder
Gravatar

# re: SQL Server split function

Thanks!
It's very useful to me.
2/8/2011 4:46 PM | sanalcadı
Gravatar

# re: SQL Server split function

As someone who is learning about SQL Server, the code listed is useful.
2/9/2011 1:10 AM | mini fridge
Gravatar

# re: SQL Server split function

thank you for sharing post
2/11/2011 11:55 PM | web tasarım ankara
Gravatar

# re: SQL Server split function

otel, otel rehberi, otel fiyatları, bayilikler, ucuz otel, tatil, tatil yerleri, konaklama, otel rezervasyon, afton otel, erzurum otel, sivas otal, oteller, otel turları, otel ajansları, istanbul oteller, türkiye oteller, rezervasyon, giriş işlemleri, otel rehberleri, anlaşmalı oteller, otel rehberi
2/12/2011 11:42 AM | mermer lavabo
Gravatar

# re: SQL Server split function

thank you nice post tercüme hizmetleri
2/16/2011 6:15 PM | tercüme
Gravatar

# re: SQL Server split function

Thanks for the given informations. These are really good and very useful informations. Everybody has to see that. So I will share this link with all my friends. Thanks
2/17/2011 1:40 PM | kocluk-egitimi
Gravatar

# re: SQL Server split function

When human life is indispensable to the settlement with the location of developing practical solutions, has left the right. Housing at the beginning of creating practical solutions that are ready-mixed concrete. Ready Mixed Concrete our time sine qua non of the construction sector.
2/17/2011 5:53 PM | hazır beton
Gravatar

# re: SQL Server split function

Fotograf sanatçısı Sami Aker İstanbul da Modacı Fransız bir anneden doğdu ve şehrin moda merkezi nişantaşında yetişti, ilk orta ve liseyi Şişli Terakki Lisesinde tamamladıktan sonra İstanbul Üniversitesinden ve Marmara Universitesinden pazarlama ve image konusunda master derecesi ile mezun oldu.
2/17/2011 5:55 PM | fotoğraf çekimi
Gravatar

# re: SQL Server split function

Thanks for the given informations. These are really good and very useful informations. Everybody has to see that. So I will share this link with all my friends. Thanks
2/19/2011 4:22 PM | otobüs firmaları
Gravatar

# re: SQL Server split function

Thanks you very much! Wonderful comments, i am reading this blog and very happy now!
2/19/2011 4:24 PM | peruk
Gravatar

# re: SQL Server split function

A great article written with great hard work...i must say....Thanks for posting this article. I am definitely tired of struggling to find relevant and intelligent commentary on this subject. Everyone nowadays seem to go to extremes to either drive home their viewpoint or suggest that everybody else in the globe is wrong. Thanks for your concise and relevant insight a great work of your which shows...
2/21/2011 11:57 AM | cheap replica watches
Gravatar

# re: SQL Server split function

I just love your blog.Thanks for posting it.i have something that someone comeback again….there is a lot of useful information a person can get from here…I must say,well done...i visited it daily,what a colourful blog it is....colours attracted me a lot....i visited it daily,what a colourful blog it is.... a very decent and nice blog...i like it so very much...
2/21/2011 11:58 AM | Go Seeq Search Engine
Gravatar

# re: SQL Server split function

thanks for sharing...
2/23/2011 1:49 PM | web tasarım ankara
Gravatar

# re: SQL Server split function

Thanks for article. Everytime watch blog like to read youİzmir reiki<br />
2/25/2011 6:22 PM | izmir-reiki
Gravatar

# re: SQL Server split function

If I were trying to use this to split a column that I select, how would I do that?

For example, say we have some customer numbers that are set up in a special fashion like 000-xxx-xxx, and others that are set up like normal numbers areacode-prefix-number, and I want to throw that into a case when and pull a list of how many users we have set up like that, kind of like this:

SELECT SUM(CASE WHEN (SELECT item FROM (SELECT ROW_NUMBER() OVER (ORDER BY item) AS RowNum, * FROM fnSplit(SELECT dbo.CUSTOMER.PHONE_NUM FROM dbo.CUSTOMER WHERE CUSTOMER.CUST_ID=1234, '-')) drvTbl WHERE RowNum = 1) THEN 1 ELSE 0 END) AS IRREGULAR_COUNT FROM dbo.CUSTOMER

The fnSplit function doesn't allow me to throw a select statement in it (or maybe I'm just missing something here).

Any ideas? İzmir kişisel gelişim merkezi
2/25/2011 6:26 PM | izmir-kisisel-gelisim-merkezi
Gravatar

# re: SQL Server split function

This is great! :)

If I then want to get back only the nth row from the resulting table how would I get it? I would presume there is some sort of rownum function that we can use? İzmir öğrenci koçluğu
2/25/2011 6:29 PM | izmir-öğrenci-koçluğu
Gravatar

# re: SQL Server split function

thanks very nicess good code
3/6/2011 8:27 PM | ev mobilya
Gravatar

# re: SQL Server split function

thanks adminss good
3/10/2011 9:34 PM | hair styles
Gravatar

# re: SQL Server split function

I want to throw that into a case when and pull a list of how many users we have set up like that, kind of like this:
3/12/2011 10:54 AM | devlet hastane
Gravatar

# re: SQL Server split function

Thank you. great working
3/12/2011 11:51 AM | Fx15
Comments have been closed on this topic.

Powered by: