Viewing 15 posts - 48,841 through 48,855 (of 59,065 total)
toniupstny (8/10/2008)
An alternative without cursor is:sp_msforeachtable 'select ''?'', count(*) Rows from ?'Toni
Ummm.... not quite correct, Toni. If you go and look at the code for sp_MSForEachTable, you'll find a...
August 10, 2008 at 9:37 am
CAS - Crappy Application Syndrome - I like it a lot, Paul!
Here's what I would do...
... NOTHING...
At least nothing overt for the time being. You've already informed management...
August 10, 2008 at 9:25 am
ps. If your yourdistinctlistofcharacters is supposed to contain a single quote, you'll need to include it twice. If yourdistinctlistofcharacters is supposed to contain brackets, then you'll need to...
August 10, 2008 at 9:07 am
shamshad.ali (8/9/2008)
The problem is I have to "Find DISTINCT SPECIAL characters in column [NTLogin]"Shamshad Ali.
With a minor modification, Peso's solution will do it...
SELECT * FROM Users
WHERE UserName LIKE '%[yourdistinctlistofcharacters]%'
Change the...
August 10, 2008 at 9:05 am
Heh... that's the most blatant "bump" I've ever seen. 😛
Seem like you have a couple of good answers there. I'd continue your post there if I were you.;)
August 9, 2008 at 7:05 pm
GilaMonster (8/9/2008)
Jeff, do you know if anyone's tested the speed of a CLR proc vs the built in XQuery for shredding xml documents?
No, I sure don't, Gail. Sorry.
August 9, 2008 at 5:21 pm
Peter, are you, by any chance, going to PASS this year? Sure would like to me you in person, someday.
August 9, 2008 at 5:19 pm
Just a bit of advice to a beginner... Most of the time where someone thinks they need a CLR, Matt and I have been able to beat the pants off...
August 9, 2008 at 11:26 am
Heh... even SCOPE_IDENTITY() doesn't fix that problem. 🙂
August 9, 2008 at 10:48 am
Hugo Kornelis (8/7/2008)
As Jeff already said, this might not be the best way to find your first gap. Here are two alternatives that...
Here's another take on the same problem... test...
August 9, 2008 at 10:42 am
Thanks for the feedback, Atif!
August 9, 2008 at 10:36 am
Awesome. Thanks for the feedback, Buzz.
August 9, 2008 at 10:34 am
Dang... Yeaup... I already knew about the prettifier... was hoping there was something a bit more auto-magic... 🙂
August 8, 2008 at 10:18 pm
Viewing 15 posts - 48,841 through 48,855 (of 59,065 total)