Viewing 15 posts - 391 through 405 (of 650 total)
They were rather interesting. I was when doing a 'quirky update' from a join with a temporary table and a table variable. It worked fine on the simple test harness...
May 2, 2009 at 3:02 pm
This is the solution to the original problem, based on the Update method. It actually uses a tally table too. Because it has to do a lot of string lifting,...
May 2, 2009 at 5:47 am
Jeff, you're absolutely right. Oh dear, I should have realised that, but I stupidly assumed that the two would be the same.
This proves the point
[font="Courier New"]SELECT [name] FROM
...
May 2, 2009 at 1:54 am
I've just been running some tests on the original problem and hit a curiosity of the Replace function. (I was unsuccessfully trying to get a winning UPDATE solution)
It is...
May 1, 2009 at 10:27 am
With the prettifier, you get the option, but I wrote it originally just to get SQL Code into blogs that only allowed FONT tags. However, it was very quick to...
May 1, 2009 at 7:22 am
Jeff,
...but their developers seem unable to fix things so they work like they used to.
Ouch.
They're doing all they can to put in a better solution ASAP. The problem was that...
May 1, 2009 at 6:51 am
I've been doing a 'skunkworks' project in TSQL that takes a database and scripts it out every day using SMO/DMO to file, and then imports the file contents into a...
April 28, 2009 at 3:02 am
(Update: Two people asked me to remove the big script, so go compile your own! [BigGrin] )
Actually, I just asked Adam to put it as an attachment instead, rather than...
April 27, 2009 at 3:41 pm
Can you please post the SQL build script for this CLR function, please. I'm stuck with my ...
CREATE FUNCTION ....
bit.
..and I bet most people who are trying to follow this...
April 27, 2009 at 2:02 pm
Adam,
Just so we can be sure to test exactly the same code, can you please post the Creation script ?
It looks to me as if you've got a fix for...
April 27, 2009 at 7:33 am
Hmmm.. I'm really scratching my head now wondering about the differences between the two test runs, Flo. At least we can agree that the Tally doesn't cut it when the...
April 26, 2009 at 4:17 pm
[p]I've already posted the Quirky and While solutions, but I put the harness in just to make the post more interesting to others.[/p]
[font="Courier New"]ALTER FUNCTION [dbo].[splitStringToTable](@String NVARCHAR(MAX), @Delimiter VARCHAR(255))
/*
This splits...
April 26, 2009 at 4:13 am
Phil, I've never had to parse anything like Moby Dick, but I would not bet the ranch that I will never be asked to.
Most data feeds are a bit more...
April 25, 2009 at 3:40 pm
[p]I'm afraid I've been still plugging away with splitting chunks of Moby Dick into lines. This is to try and find which function returns a table of lines from Moby...
April 25, 2009 at 1:35 pm
As first I have to apologize for all those "great" CLR test results... Since I tried to reduce the test results to the real split work I used a COUNT(*)...
April 25, 2009 at 8:03 am
Viewing 15 posts - 391 through 405 (of 650 total)