Viewing 15 posts - 106 through 120 (of 692 total)
select len(cast(year(getdate()) as char)) -- returns 4select len(cast(month(getdate()) as char)) -- returns 1
LEN does an implicit right trim. Try DATALENGTH instead.
June 3, 2009 at 8:38 am
GSquared (6/2/2009)
The concept is crap, but I'd rather see it published and debunked than left out there.
Here's my full take (much easier here than on Twitter - damn 140 character...
June 2, 2009 at 2:48 pm
RBarryYoung (5/9/2009)
May 10, 2009 at 4:42 pm
Paul White (4/28/2009)
The idea is to be able to split a string twice...
April 28, 2009 at 6:24 pm
OK, here's my latest. A few bug fixes, and it seems to properly ignore consecutive delimiters (you don't want to know how many times I recompiled this fighting off-by-one...
April 28, 2009 at 10:30 am
David Burrows (4/28/2009)
how to make it ignore consecutive delimiters
Ignore in which way?
I split data with consecutive delimiters, ie a column/field with no data
In most of the use cases I'm interested...
April 28, 2009 at 9:44 am
Now you really are scaring me - people are going to put this kind of unprocessed data into a database and then allow multiple users access to it at the...
April 28, 2009 at 9:12 am
Parsing quoted strings, which would allow embedded delimiters
e.g.
"Field1 with commas ,," , Field2 , "Field 3 with embedded quote"" here"
That's a fun challenge -- I did it in T-SQL a...
April 28, 2009 at 8:10 am
You will notice the "even_faster" function posted by Adam is missing from the 40000 row sample - I had to kill it after 9 minutes and still no results.
Probably a...
April 28, 2009 at 8:07 am
We're not done yet -- if we're going to create the "best" method it should do as much as possible in terms of functionality we would normally want from string...
April 28, 2009 at 6:43 am
Phil Factor (4/27/2009)
(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,...
April 27, 2009 at 3:45 pm
Paul White (4/27/2009)
April 27, 2009 at 3:33 pm
Sorry, but I think I cannot. Currently I have only a x64 system. If you have a x64 system, sure!
This works on both 32 and 64 bit:
(Update: Two people asked...
April 27, 2009 at 2:40 pm
It does appear to be faster for a single delimiter, but it doesn't work properly for multiple delimiters:
select * from dbo.ufn_clr_SplitString_Enumerator_Flo2('a,,b', ',,') q
April 27, 2009 at 1:32 pm
Florian Reischl (4/27/2009)
I really like the _syntax to distinguish between local and module variables. Would you prefer m_anything?
Personally I like Pascal case for externally-facing variables and camel case for...
April 27, 2009 at 1:01 pm
Viewing 15 posts - 106 through 120 (of 692 total)