Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,366 through 37,380 (of 59,072 total)

RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

joel.weiss 70857 (8/6/2010)
I want dynamic pivots, i,e., pivot a table without knowing what exists in the pivot data. Nothing short will satisfy me. It seems like a religious...
--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 6, 2010 at 6:25 am

#1203432
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

roger_os (8/6/2010)
Thanks for the article Jeff.
You bet. Thanks for stopping by.
--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 6, 2010 at 5:38 am

#1203405
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

TheSQLGuru (8/6/2010)
I soooo prefer the CASE syntax to PIVOT! 🙂
I did learn something new, which honestly doesn't happen all that often for me when it comes 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 6, 2010 at 4:39 am

#1203372
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Gillbert (8/6/2010)
Dear All,
This all [HARD coded] like year or month whatever
in my situations, i don't want to [HARD Coded] my pivt value,
how to build the qry, if anybody'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 6, 2010 at 4:30 am

#1203363
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Toby Harman (8/6/2010)
As an aside (and without reading all 20 pages on this thread) I played around with the PIVOT operator on a SELECT statement and found some interesting performance...
--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 6, 2010 at 3:41 am

#1203326
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

srweal (5/6/2010)
You are a gun Jeff. Got this tasty article in my inbox and was so glad I stopped by for a read. PIVOT scared me off 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)

August 6, 2010 at 3:40 am

#1203323
RE: TSQL or SSIS

KBSK (8/5/2010)
KBSK (8/4/2010)
Jeff Moden (8/2/2010)
It's sometimes difficult to "fight city hall" and you may have to kowtow to their wishes by using SSIS... in which case, I can't help. I...
--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 5, 2010 at 9:25 pm

#1203236
RE: Rolling 3 Weeks

Heh... of course, how much are you actually going to trust an article that gives the following kind of bad advice??? :Whistling:
C. Searching for all datetime2 values in a day
•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 5, 2010 at 9:13 pm

#1203235
RE: Rolling 3 Weeks

drew.allen (8/5/2010)
To add and subtract for all date and time data types, use DATEADD and DATEDIFF.
That's good enough reason for me.
I guess it's a matter of how you read something...
--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 5, 2010 at 8:56 pm

#1203231
RE: Hi i am a sql dba.In my organizastion i am only the who will take care sql servers.2 servers are going to production within 2 days.

Well done on the handle change, Minto...
Getting back to your original problem... the recommendation that a lot of people make is to do daily full backups and transaction log...
--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 5, 2010 at 8:38 pm

#1203230
RE: Null Fun

skcadavre (8/5/2010)
Steve Cullen (8/5/2010)
Note that you can do this:
SELECT 1 WHERE NULL is NULL
Indeed. Or even
SELECT CASE
WHEN NULL IS NULL...
--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 5, 2010 at 8:28 pm

#1203229
RE: Null Fun

skcadavre (8/5/2010)
Jeff Moden (8/5/2010)
Nulls cannot be compared to anything, not even other Nulls. NULL = NULL returns false. NOT IN is like saying NULL <> NULL and even...
--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 5, 2010 at 8:23 pm

#1203228
RE: how to update millions of records quickly........

gah (8/3/2010)
If its "wrong" to use the quiirky update in this manner....
Absolutely not wrong. Well done, Graham. Heh... I was going to write a second article on...
--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 5, 2010 at 8:11 pm

#1203224
RE: how to update millions of records quickly........

TheSQLGuru (8/3/2010)
Hmm, I thought the quirky update WAS primarily a performance tool since it can solve problems where you need a triangular join or actual TSQL cursor to get 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 5, 2010 at 8:03 pm

#1203221
RE: Data Type size

Sanjay-940444 (8/5/2010)
but if we are using varchar datatype sql s. will reserve space as much required for actual value.Any say??
Yep... how many bytes does it take to store the number...
--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 5, 2010 at 7:41 pm

#1203217

Viewing 15 posts - 37,366 through 37,380 (of 59,072 total)