Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,051 through 37,065 (of 59,098 total)

RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

AnthonyR (8/30/2010)
I just thought I'd share a head-smacking moment with you. It's been touched-on previously in this thread, but I don't think anyone's come right out and demonstrated it.
Thanks 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 30, 2010 at 6:28 pm

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

aykut canturk (8/29/2010)
yes actually. but column count and column names are changing all the time. so I beleive a kind of "for each column..." structure needed. and the the sql...
--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 30, 2010 at 7:57 am

#1213735
RE: GETDATE Value During Long Running Job

Agreed. If the date mustn't change, then storing it in a variable is definitely the way to go just to be on the safe side.
--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 30, 2010 at 7:23 am

#1213698
RE: check if Row exists in the table

Don't use @@IDENTITY for this. It could cause the wrong number to be returned if certain things happen to the database in the future. Use SCOPE_IDENTITY() instead. ...
--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 30, 2010 at 7:20 am

#1213696
RE: How to bulkinsert a particular column to sql table

nithiyanandam-447806 (8/30/2010)
but we can't bulk insert the table..
it expects status columns.
Obviously, you've correctly identified the problem. You'll need to change something about that. My recommendation is to NEVER...
--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 30, 2010 at 7:17 am

#1213695
RE: how to get the results of a subquery as a commaseparated list

Karl-452938 (8/26/2010)
Complete table definitions would include a lot of stuff, that is not needed here.
Let's keep it simple
We have one table Files, which has 2 fields we need here
-FileID...
--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 30, 2010 at 7:03 am

#1213694
RE: The Great Debate!

steve.robson 58295 (8/26/2010)
Just a few of comments on the posts above . . .
1 - It always depends, but you should try to adopt a standard approach, some general guidelines...
--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 7:20 am

#1213529
RE: Turn a Bad Job into a Good Experience

On the flip side of all this, people make a huge difference either way. A great job can suddenly become a major PITA based on a change in someone's...
--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 7:09 am

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

aykut canturk (8/28/2010)
wow, quick answer. yes I have no data, sorry I know it would be easy. okay, let me put in that way. here's sample data:
Product Col1...
--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 7:03 am

#1213525
RE: sql server architecture

j.venugr (8/28/2010)
i got architecture from your forum, but i need brief explanation about sql sever architecture to understand very clearly, so please send the explanation, my mail ID is j.venugr@gmail.com
It's...
--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:57 am

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

thava,
Does that answer your question for you?
--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:45 am

#1213523
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

Viewing 15 posts - 37,051 through 37,065 (of 59,098 total)