Viewing 15 posts - 76 through 90 (of 191 total)
I'm confused. The result I'm getting is 8, and I'd be curious to know why. I tried both Latin1_General_CI_AS and SQL_Latin1_General_CP1_CI_AS collations - I've had a difficult time...
September 18, 2012 at 6:06 am
Lisa Slater Nicholls (9/14/2012)
ronmoses (9/14/2012)
Rather than parsing the string, how about attempting to CAST the string in a TRY...CATCH block and return a pass/fail value on that basis?
The problem here...
September 14, 2012 at 9:18 am
Rather than parsing the string, how about attempting to CAST the string in a TRY...CATCH block and return a pass/fail value on that basis?
ron
September 14, 2012 at 8:56 am
dwain.c (9/10/2012)
At least mine was in the running for awhile.
Truth be told, I was literally in the process of typing up my response declaring you the winner, when Luis's code...
September 10, 2012 at 6:05 pm
dwain.c, Mark, and Luis, thank you very much for your solutions. All three are workable and really quite brilliant. Ultimately I believe I'll be going with Luis's suggestion,...
September 10, 2012 at 7:56 am
umair 4720 (9/10/2012)
Regex searching and replace ?
I considered going with Regex or another CLR-based solution. If I was doing this on my own data server, that's absolutely...
September 10, 2012 at 6:54 am
dwain.c (9/9/2012)
Nasty piece of work this, but you could try tokenizing the string with a rCTE, replacing the token and then putting it all back together.
Wow, this is very impressive....
September 10, 2012 at 6:41 am
Lowell (9/7/2012)
does this work the way you expect?
Well... it certainly could be a step in the right direction, but I'm not quite there yet. Here's the result set I'm...
September 7, 2012 at 2:39 pm
Lowell (9/7/2012)
the problem with abstracting out the problem is it hides the actual issue.
You're correct, I apologize for confusing the issue by trying to oversimplify it.
This column contains formulas that...
September 7, 2012 at 2:01 pm
Tom Brown (9/7/2012)
replace the untouchable 'BA#' first, then do the main replace, then put the 'BA#' back
SELECT REPLACE(REPLACE(REPLACE(@STRING, 'BA#', '***'), 'A#', 'C#'), '***', 'BA#')
Well, the problem with that is...
September 7, 2012 at 1:52 pm
This is the first QotD in a long time (ever?) that, after getting it right, I audibly said "WOO-HOO!"... at work, in an open office area. So yeah, a...
September 6, 2012 at 6:01 am
GilaMonster (8/21/2012)
August 21, 2012 at 9:26 am
Looks like the least I can get away with is about a $600 machine. A second-gen i3 and 8GB of RAM should do, but I might as well go...
August 21, 2012 at 9:07 am
I got it wrong on the assumption that data type conversion would take precedence over concatenation or addition. Now I understand that while I'm correct about that, the precedence...
August 21, 2012 at 8:50 am
The hardware requirements appear to be more in support of Hyper-V than of SQL Server itself. The specific requirements in the Training Kit are:
============
Virtualization Hardware Requirements:
- x64-based processor that...
August 18, 2012 at 12:33 pm
Viewing 15 posts - 76 through 90 (of 191 total)