Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,036 through 37,050 (of 59,072 total)

RE: recursive or a better way to solve this problem

To anyone else reading this particular thread...
The method Wayne used is affectionately known as the "Quirky Update" or the "Running Total Solution". It has rules that you MUST follow...
--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)

August 29, 2010 at 6:42 am

#1213522
RE: recursive or a better way to solve this problem

Wayne,
I was looking at your previous row calculation on the 3 part update thinking to myself "Cool... he even thought of the forced RN change when EMID changes 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)

August 29, 2010 at 6:34 am

#1213521
RE: recursive or a better way to solve this problem

Aye... that's the ticket, matey!
--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)

August 29, 2010 at 6:10 am

#1213517
RE: If You Had To Pick a Super Hero...

Funny that you mention The Flash, Wayne... I'm always hungry like he is after a good run... especially after I quit smoking (finally).
--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)

August 29, 2010 at 5:43 am

#1213515
RE: database mail without cursors?

pietlinden (8/28/2010)
I'm a noob... so I have a dumb question. Say I have a table of "Studies" and a table of "Staff". Staff--(1,M)---Studies.
Say for the sake of argument...
--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)

August 28, 2010 at 2:20 pm

#1213491
RE: sql

Thanks for the feedback, Brian. And you and I have said virtually the same thing now on NVARCHAR(MAX)... 2GB max storage requirement (same as VARCHAR(MAX)), 1GB max displayable characters....
--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)

August 28, 2010 at 2:13 pm

#1213490
RE: Sumof previous columns (in pivot table)

Since you have no data that we can actually play with, all I can do is give you a suggestion... see the following article...
http://www.sqlservercentral.com/articles/Crosstab/65048/
--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)

August 28, 2010 at 2:09 pm

#1213489
RE: What is the Maximum Page Size in SQL Server 2000?

You'd figure that after 7 hears on this site, that I'd have run into this fun and informative article by now. As an update, the SQL Server documentation now...
--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)

August 28, 2010 at 2:02 pm

#1213488
RE: 8KB page size

It's always fun to look at that stuff at the byte level. Thanks for posting it, Brian. 🙂
--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)

August 28, 2010 at 1:55 pm

#1213487
RE: I Love the SQL Community

Heh... now you're on it. And folks don't even have to hold office to do such a wonderful thing. Just show up. 😉
--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)

August 28, 2010 at 1:30 pm

#1213481
RE: Are the posted questions getting worse?

Alvin Ramard (8/27/2010)
How many times must I repeat this? We do not need a DBA!!!!
http://www.sqlservercentral.com/Forums/Topic976708-266-1.aspx#bm976772
Looks like someone's about to have a great weekend.
Let's hum them a work tune to...
--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)

August 28, 2010 at 1:23 pm

#1213480
RE: Are the posted questions getting worse?

CirquedeSQLeil (8/28/2010)
I'll never think of "comma delimited" in the same way again
Forum Post title:
To split comma delimiterd string
Has somebody been leaving hamster poo in here?:hehe:
Heh... nope. Wrong kind of...
--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)

August 28, 2010 at 1:08 pm

#1213474
RE: Excel Colum Formatting

It's not a matter of formatting with them... it's a matter of not destroying formatting with them.
--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)

August 28, 2010 at 1:01 pm

#1213471
RE: sp_who2 results show one spid 24 times

Ariadne (1/9/2009)
I've got a 64 bit, cluster, enterprise 2005 server that is having CPU issues. I can diagnose the standard stuff, but I'm seeing something that is strange. When 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)

August 28, 2010 at 12:59 pm

#1213470
RE: sql

Brian O'Leary (8/28/2010)
Try
WHERE [Timestamp] >= '2010-08-28 00:00:00.000' and [Timestamp] <= '2010-08-28 23:59:59.999';
Hi Brian,
That's not the recommended way to do things because 1)... 23:59:59.999 rounds UP to the next day for...
--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)

August 28, 2010 at 12:50 pm

#1213468

Viewing 15 posts - 37,036 through 37,050 (of 59,072 total)