Viewing 9 posts - 1 through 9 (of 9 total)
mister.magoo (2/22/2013)
WHERE SUBSTRING(@pString,t.N,1) COLLATE Latin1_General_BIN = @pDelimiter COLLATE Latin1_General_BIN
COLLATE only needs to be on one side of the expression. Either side will do. You don't have...
February 22, 2013 at 12:01 pm
The compatibility level can be changed back, if needed. When you change this, there is nothing in the database that is upgraded or converted that will prevent you from...
January 17, 2013 at 1:35 pm
SQL Kiwi (8/29/2012)
Yes that is better. Of course now someone will need to split:
DECLARE @x nvarchar(max) = N'?????,??,???,????,??????,???????????,?????,??,?????,???';
SELECT * FROM dbo.XmlInlineSplitter(@x, ',', NEWID()) AS xis;
So eat more of these...
August 29, 2012 at 2:14 pm
Jeff Moden (7/4/2012)
Chris,Which version of DS8K did you use? The one from the article or the updated one in the attachments?
Update the dratted article already! 😎 This happened to...
July 4, 2012 at 1:47 pm
Jeff,
Ctrl+G all the way! I used to do that when character 7 did make the computer beep. 🙂
Erik
June 20, 2012 at 7:02 pm
Second try: failed. 3 days and 20-some-odd hours later, exact same results as before, only with wait time 334,605,998. 🙂
I think I will not be running this again on my...
March 19, 2012 at 11:40 am
I am running your splitter tests on a SQL Server running in a VM. It's taking forever!
I let it go for 17 hours earlier this week, and finally tried canceling...
March 15, 2012 at 7:43 pm
My apologies if I wasted anyone's time! I didn't know there was somewhere else to look for additional improvements. This thread has 28 pages--gadzooks!
March 13, 2012 at 5:04 pm
Jeff,
I made a few tweaks to your function that I think improve performance a little more:
I noticed that the SELECT 0 could be moved from the cteTally table to the...
March 13, 2012 at 12:36 pm
Viewing 9 posts - 1 through 9 (of 9 total)