Viewing 5 posts - 1 through 5 (of 5 total)
Nice function.
But, errors (Invalid length parameter passed to the LEFT or SUBSTRING function) if both search patterns exist and @secondpattern appears BEFORE @firstpattern.
So I would enhance your function by...
December 30, 2014 at 3:19 am
Bill,
If number is even
n / 2
which eventually reduces all even numbers to 1.
Not so fast - it only reduces 2n quickly to 1. Some even numbers (18, say) bounce around...
October 3, 2011 at 9:37 am
My comment conveniently ignores the
one of the things I am interested in is the count of how many repetitions of the sequence it took to reach 1
but I...
October 3, 2011 at 8:13 am
I think this QoD and the discussion about ANSI standards, extensions to the standard, behaviour of MS SqlServer vs Oracle etc should be compiled into a proper 'Featured Article' on...
July 28, 2004 at 2:46 am
OK, I eat, sleep & dream T-SQL so this Question wasn't likely to confuse me (unlike any question with 'Bind' 'TCPIP' or 'Port' in the question, which scramble my brain). ...
July 13, 2004 at 3:35 am
Viewing 5 posts - 1 through 5 (of 5 total)