Itai Goldstein - All Comments

re: T-SQL Split function

Lukeni2 — Thu, 12 Jan 2012 14:48:26 GMT

Very usefull function. It works fine. Thanks for that

re: How To: Implement HMAC Authentication On a RESTful WCF Service

nam vo — Thu, 05 Jan 2012 05:04:04 GMT

Hi,

could you please provide a sameple code and the way to use it with jquery jsonP to consume the service

re: T-SQL Split function

Beddel — Wed, 28 Dec 2011 10:30:36 GMT

Thank you very much!

Silverlight calibri | 360inconline

Silverlight calibri | 360inconline — Thu, 15 Dec 2011 06:45:11 GMT

Pingback from Silverlight calibri | 360inconline

re: T-SQL Split function

Pratik — Tue, 01 Nov 2011 07:02:20 GMT

I want to split values of string into multiple columns instead of rows ... anybody has any idea ?

SQL Stored Procedure – Search an array of strings in a field and display the count of occurrences

Fri, 30 Sep 2011 19:20:46 GMT

Pingback from SQL Stored Procedure – Search an array of strings in a field and display the count of occurrences

re: T-SQL Split function

Shahid — Thu, 15 Sep 2011 11:42:18 GMT

Thank you...

Transact-SQL: How do I tokenize a string? - Programmers Goodies

Transact-SQL: How do I tokenize a string? - Programmers Goodies — Sat, 20 Aug 2011 09:07:56 GMT

Pingback from Transact-SQL: How do I tokenize a string? - Programmers Goodies

TrackBack — Mon, 08 Aug 2011 03:03:06 GMT

Pingback from

re: T-SQL Split function

sqlqueen — Sun, 24 Apr 2011 15:18:42 GMT

I have string that has [Error] some error 1 [error] some error 2

and the datalenght is 1319433 and it only prints out 22 lines of errors and there are over 1800 errros to report.

Any ideas

re: T-SQL Split function

Marianne Daye — Thu, 14 Apr 2011 18:33:29 GMT

This is a really helpful solution for my purposes, and easy to implement. Thanks!

re: T-SQL Split function

Jeff Moden — Mon, 07 Mar 2011 04:32:55 GMT

The following code is about 3 times faster. Give it a try.

CREATE FUNCTION dbo.XmlDelimitedSplit

(

@String VARCHAR(MAX),

@Delimiter CHAR(1)

)

RETURNS @Return TABLE (ItemNumber INT, ItemValue VARCHAR(max))

BEGIN

DECLARE @Xml XML;

SELECT @Xml = '<r>' + replace(@text, @delimiter, '</r><r>') + '</r>'

;

INSERT INTO @Return

SELECT ItemNumber = ROW_NUMBER() OVER (ORDER BY (SELECT NULL)),

ItemValue = item.value('text()[1]', 'varchar(max)')

FROM @Xml.nodes('//r') R(item)

;

RETURN

;

END

;

--Jeff Moden

re: T-SQL Split function

M Dicken — Tue, 05 Oct 2010 14:57:21 GMT

Thankyou for the SQL Split Function ... it helped me out :-) ... cheer

re: T-SQL Split function

Dave Naismith — Thu, 30 Sep 2010 13:57:46 GMT

Thanks a lot. Great solution

re: T-SQL Split function

re: T-SQL Split function — Sun, 27 Jun 2010 01:41:54 GMT

golden