Viewing 15 posts - 44,041 through 44,055 (of 59,063 total)
Robert Davis (4/23/2009)
Quality should be the top priority of...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 23, 2009 at 11:50 am
Robert Davis (4/23/2009)
Jeff Moden (4/23/2009)
Heh... there's some extremely talented folks right here in the U.S.A....
Wow, you took a function I wrote more than 4 years ago and sped it up...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 23, 2009 at 11:16 am
Derek Dongray (4/23/2009)
I did a few more tests (beyond the earlier table) and on my systems, the double-tally acheives better than half CPU time at long executions (.e.g 146...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 23, 2009 at 8:56 am
JacekO (4/23/2009)
Muhammad Kashif Azeem (4/23/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 23, 2009 at 8:43 am
Muhammad Kashif Azeem (4/23/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 23, 2009 at 8:27 am
Both are good solutions, but I prefer Wayne's method just because it's a bit easier on the eyes.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 23, 2009 at 8:22 am
gserdijn (4/23/2009)
SELECT @Txt = ''
SELECT @Txt = @Txt + ao.name + ao.type_desc + CHAR(13) + CHAR(10)
FROM SYS.all_objects ao WHERE ao.type IN ('U' , 'V')...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 23, 2009 at 12:42 am
Heh... there's some extremely talented folks right here in the U.S.A....
Here's your function...
[font="Courier New"]--===== Create the "strip tags" function using a typical While Loop
-- (by Robert Davis)
Create...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 23, 2009 at 12:31 am
Bob Hovious (4/22/2009)
🙂
Heh... nope... not stalking. :hehe:
--Jeff Moden
Change is inevitable... Change for the better is not.
April 22, 2009 at 2:17 pm
YSLGuru (4/22/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 22, 2009 at 2:12 pm
Bob Hovious (4/22/2009)
Jeff: Who did your awesomely animated NO...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 22, 2009 at 2:05 pm
Lately, it won't even let you delete your own post.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 22, 2009 at 2:01 pm
jsheldon (4/20/2009)
Francis,Your code was the best fit...thanks to all for the help...
Just don't rely on ISNUMERIC being some sort of magical ISALLDIGITS function because it's not. Please see the...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 22, 2009 at 1:53 pm
Mark (4/17/2009)
WITH CTE AS (
SELECT CUSTOMER_NO,
CURRENT_BALANCE,
ACTUAL_DATE,
ROW_NUMBER() OVER(PARTITION BY CUSTOMER_NO...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 22, 2009 at 1:17 pm
The problem is probably what you're grouping by. Which tables do all the columns belong to? The easiest way to describe that is to apply correct table aliases...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 22, 2009 at 1:07 pm
Viewing 15 posts - 44,041 through 44,055 (of 59,063 total)