Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,166 through 45,180 (of 59,101 total)

RE: Why do people need to do this?

Bruce W Cassidy (2/15/2009)
[font="Verdana"]Okay, not exactly sure this is related. I await correction with trepidation. However...
In a company that shall not be named for which I had the...
--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)

February 15, 2009 at 7:54 pm

#944315
RE: Why do people need to do this?

GilaMonster (1/24/2009)
Jeff Moden (1/24/2009)
To make a longer story shorter, I normally try to write gender agnostic replies when I don't know someone and, one day in a response to "ggraber",...
--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)

February 15, 2009 at 7:46 pm

#944311
RE: How to add cost percentage to product

So... are you saying a...
3' door is $500
4' door is $700
5' door is $900
6' door is $1100
???
--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)

February 15, 2009 at 7:38 pm

#944310
RE: How to convert INTEGER to TIME

DateAdd or not, the op hasn't identified what happens when you exceed 59 minutes and 59 seconds. If the duration in seconds equals two days, should the answer still...
--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)

February 15, 2009 at 7:32 pm

#944309
RE: SQL or Oracle

Lynn Pettis (2/9/2009)
Each has its place, neither is actually better than the other for most applications. You get into the niche areas, that no longer becomes the true. ...
--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)

February 15, 2009 at 7:27 pm

#944308
RE: SQL or Oracle

Perry Whittle (2/9/2009)
Oracle is by far the most powerful and flexible of the two.
In Oracle RAC the distributed cache memory is shared between the cluster nodes and this offers...
--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)

February 15, 2009 at 7:17 pm

#944306
RE: SQL or Oracle

Steve Jones - Editor (2/9/2009)
SQL Server = Oracle = DB2
Maybe not ==, but each has things the other doesn't and for 99% of us out there, any of them will...
--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)

February 15, 2009 at 7:15 pm

#944305
RE: Rollback the job running very long time

The real key here is... you shouldn't have jobs that run that long nor get "stuck". Find out what the root cause is and fix it. Chances are,...
--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)

February 15, 2009 at 7:03 pm

#944303
RE: help me to know

vaibhav_vasani (2/15/2009)
I working on my final year project ... no matter if copy code.
So much for the first rule of DBA's... ethics.
--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)

February 15, 2009 at 6:50 pm

#944300
RE: Building a view to get summary data from multiple tables

But, I liked the parenthesis... 😛
--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)

February 15, 2009 at 6:48 pm

#944299
RE: Sql Query problem

"IT is working..."
What is 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)

February 15, 2009 at 6:46 pm

#944298
RE: Sql Query problem

Be very careful... the recursive CTE method will be slower than even a poorly formed cursor.
--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)

February 15, 2009 at 10:11 am

#944227
RE: count of consecutive value

Looks fine to me, Andrew. Sorry for the panic, but I went into a panic when I saw that the group numbers weren't unique across items when I was...
--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)

February 15, 2009 at 9:14 am

#944223
RE: Need to generate random ID between 1 and 5

Mark (2/12/2009)
DECLARE @PerDay INT
SET @PerDay = 2
SELECT
ORDER_DT = DATEADD(d,t1.N-1,DATEADD(yy,DATEDIFF(yy,0,GETDATE())-1,0)),
ORDER_QTY = ABS(CHECKSUM(NEWID()))%1000+1, --<== Stole from Jeff
...
--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)

February 14, 2009 at 11:17 pm

#944185
RE: count of consecutive value

Ok... now I trust it... just gotta remember to NOT let the fact that GroupNums aren't unique across items but the combination of Item and GroupNum works as expected when...
--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)

February 14, 2009 at 9:52 pm

#944183

Viewing 15 posts - 45,166 through 45,180 (of 59,101 total)