Viewing 15 posts - 40,591 through 40,605 (of 59,072 total)
Lookup NULLIF...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 18, 2009 at 4:43 pm
Steve Jones - Editor (12/18/2009)
Patience, my padawans. I'm looking to write things up, but honestly I'm not 100% sure what the final was since I...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 18, 2009 at 4:38 pm
atwite (12/18/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 18, 2009 at 4:28 pm
For something like that, why not just put a unique index on the meter column and use the thrown error as an alert?
--Jeff Moden
Change is inevitable... Change for the better is not.
December 18, 2009 at 11:59 am
Too bad... I wanted to actually see someone create a scalar function to gen a whole report. 😛 Maybe that's why the OP took it down. :hehe:
--Jeff Moden
Change is inevitable... Change for the better is not.
December 18, 2009 at 11:57 am
Despite the lack of a result sample, it looks pretty clear that the split should occur on any characters (including Carriage Returns and LineFeeds) not in the range of [A-Z0-9]...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 18, 2009 at 11:35 am
PSGS (12/17/2009)
post deleted
Heh... well that's bloody rude. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
December 18, 2009 at 11:26 am
Lynn Pettis (12/15/2009)
Magy (12/15/2009)
When I run the cursor, and then check the table, it...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 18, 2009 at 11:25 am
jcrawf02 (12/18/2009)
By the way Jeff, very nice review of Grant's book.
Thanks... Grant is an easy read and I learned several new tricks as a "bonus".
--Jeff Moden
Change is inevitable... Change for the better is not.
December 18, 2009 at 11:19 am
CirquedeSQLeil (12/18/2009)
Nice review, thanks for the info Jeff.
You bet, Jason. Thanks for the feedback. Grant is an easy read... I read his book in just two nights. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 18, 2009 at 11:16 am
homebrew01 (12/18/2009)
EdVassie (12/18/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 18, 2009 at 11:11 am
Agreed... I forget what they call the equivalent of a Clustered Index in Oracle, but a lot of developers don't know about it and there's usually no need for it...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 18, 2009 at 6:13 am
Robert Frasca (12/17/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 17, 2009 at 7:51 pm
krypto69 (12/15/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 17, 2009 at 7:16 pm
dberra-831997 (12/17/2009)
declare @str varchar(max)
select @str =
'line1
line2
line3
line4'...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 17, 2009 at 7:07 pm
Viewing 15 posts - 40,591 through 40,605 (of 59,072 total)