https://technet.microsoft.com/en-us/library/ms191485(v=sql.105).aspx

When you use bcp interactively and specify (newline) as the row terminator, bcp automatically prefixes it with a \r (carriage return) character, which results in a row...

You mean only MySQL has GROUP_CONCAT(). BOL has a SQLCLR version http://msdn.microsoft.com/en-us/library/ms131056(v=sql.105).aspx and there is an improved versoin in codeplex

If you have two delimiters you can change the code slightly:

DECLARE @pString varchar(8000) = '55555;4444,333,22,1';

DECLARE @pDelimiter1 char(1) = ',';

DECLARE @pDelimiter2 char(2) = ';';

WITH E1(N) AS (

...

I found similar failure to proceed on a physical server - a desktop running Vista 32 bit on an aging AMD processor. When I changed the script to select into...

I was thinking that there would be a separate version for ASCII which would avoid the conversions to and from UNICODE and probably make it even faster. The convenience...

Good point. The function should cast the output back to COLLATION DATABASE_DEFAULT. Another plus for CLR?

-mark

peter-757102 (9/11/2012)

---

The recent discussion has hit an interesting topic, namely that of collations. While...

Paul,

I didn't take offence. I was similarly concerned I was a bit abrupt writing in a hurry late at night.

Can you avoid the conversion to Unicode by casting to a...

Jeff,

Usman’s N1 splitter is in http://www.sqlservercentral.com/Forums/FindPost1303895.aspx

On the subject of benchmark frameworks, I have some sympathy for storing the output. Splitters are often used where you are going insert...

I agree that the CLR has additional and desirable features, but if we're comparing apples we need to make sure the functionality we are comparing is the same. My first...

Paul's CLR splitter has two features which mean it shouldn't be compared directly to DelimitedSplit8K based splitters.

The first is that it doesn't handle the trailing delimiter correctly. Using comma as...