Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,561 through 37,575 (of 59,072 total)

RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

kjc-1057161 (7/20/2010)
Thanks for both responses! The problem isn't the calculation of compound interest, but the rounding issue, hence all the floor() functions. Each day, the interest is calculated only in...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 20, 2010 at 9:53 pm

#1195927
RE: Help with using mulitple replace in a function

Eugene Elutin (7/19/2010)
The fasterst string manipulations would be byte by byte. Not so elegant, a lot of manual coding, but -very fast.
Now, I'll definitely agree with THAT! Done...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 20, 2010 at 9:20 pm

#1195919
RE: Generating SubTotals using GROUPING

Hugo Kornelis (7/20/2010)
My final comment in this topic, and then I'll respect R.P.'s request.
Jeff Moden (7/19/2010)
Still, the order of run return is, in fact, documented in Books Online...
ROLLUP
Specifies that...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 20, 2010 at 9:13 pm

#1195915
RE: BCP Utility

bryan.duchesne (7/20/2010)
No, I am not trying to make the data any longer. In some cases I just want to change the content or blank it out.
I guess we need...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 20, 2010 at 9:09 pm

#1195913
RE: BCP error

Both Sumit and Mike have some good pointers for getting this working.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 20, 2010 at 9:05 pm

#1195911
RE: Average Inventory (Stock) Age

gah (7/20/2010)
Extraordinary..........:w00t:
Running on SQL 2000...7 year old box with 4gb RAM
100K products
20M transaction lines
sub 1 minute !!!!
beats the hell out of the vendor's app (2½hrs)...but that sits on a different...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 20, 2010 at 9:01 pm

#1195909
RE: Average Inventory (Stock) Age

steve.vidal (7/20/2010)
I'm a bit late to the party because I was busy yesterday but I wanted to try that "quirky update" thingo, so I had a crack this morning... just...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 20, 2010 at 8:57 pm

#1195907
RE: Return value for null rows

Nope... not a DTS package...
Here's 24 hours of 15 minute segments...
SELECT CONVERT(CHAR(5),DATEADD(mi,(t.N-1)*15,0),108)
FROM dbo.Tally t
WHERE t.N BETWEEN 1 AND 96
Of course, for that to work,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 20, 2010 at 6:01 pm

#1195893
RE: spliting a varchar(max) into multiples

Paul White NZ (7/20/2010)
Jeff Moden (7/20/2010)
Please see the following "how to" article for a T-SQL only solution...
http://www.sqlservercentral.com/articles/T-SQL/63003/
Yes, that's one of the top articles on the whole site. For some...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 20, 2010 at 4:53 pm

#1195878
RE: Parsing QueryString to SQL Table

Thanks for the feedback, RJ. Glad to have been of service.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 20, 2010 at 4:52 pm

#1195877
RE: TSQL

palla.sureshbabu (7/20/2010)
Hi ,
i need to create a trigger that needs to be fired on a table when that table is idle for two hours.can anybody help me with...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 20, 2010 at 4:51 pm

#1195876
RE: Tempdb growing huge

I agree with Roy. You have to find out what the cause of the growth is before you do anything else.
As a side bar, a 15GB TempDB may not...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 20, 2010 at 4:48 pm

#1195875
RE: Rename Table Without Stored Procedure

amrata88 (7/20/2010)
Hi,
1. Using Stored Procedure requires permission .
Only the members of the sysadmin fixed server role, the db_owner fixed database role, or the owner of the object can execute...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 20, 2010 at 4:32 pm

#1195866
RE: Recursive CTE to replace a cursor problem

I'll tell you that replacing a cursor with a recursive CTE is counter productive and won't buy you much for performance and may actually cost you about 3 times as...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 20, 2010 at 4:20 pm

#1195860
RE: spliting a varchar(max) into multiples

Paarthasarathy (7/20/2010)
Hi,
I have a need to split a varchar column into multiple columns based on a delimiter.
Hi have a variable named @a varchar(max)
it contains value similar to below
select @a =...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 20, 2010 at 7:10 am

#1195485

Viewing 15 posts - 37,561 through 37,575 (of 59,072 total)