Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,691 through 48,705 (of 59,095 total)

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

Ian Gibson (8/19/2008)
That's interesting. I had my doubts as to how useful pivot might be. It's good to see it backed up by examples and statistics.
I'm looking forward to what...
--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 19, 2008 at 5:23 pm

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

Peter Smith (8/19/2008)
Jeff Moden (8/18/2008)
Comments posted to this topic are about the item
What a performance! Access SQL had the Pivot command from 1992, it's taken 13 years 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 19, 2008 at 5:09 am

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

Phil Factor (8/19/2008)
[p]I hope I'm not mentioning anything that you are covering in subsequent articles, but when you need row and column totals, averages, or other aggregations, then suddenly 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 19, 2008 at 5:03 am

#859895
RE: GOTO vs WHILE

DB_Andrew (8/18/2008)
There are times when you don't always have the time to come up with the proper set based solution. Now I'm not saying you should take the quick...
--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 18, 2008 at 10:19 pm

#859794
RE: Debugger For SQL

Actually, I've gotta be up in 5 hours... I'll finish this tomorrow evening. Heh... don't change that channel! 😛
--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 18, 2008 at 9:58 pm

#859790
RE: Debugger For SQL

Steve Jones - Editor (8/18/2008)
Or write up a short article. It's always good to see how someone tests and their results.
Heh... but since he challenged my method, I 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 18, 2008 at 9:55 pm

#859788
RE: Debugger For SQL

Here's some "simpler" code for the "single run" test... the cteTally split blows the SELECT/UNION ALL method away by 51.7 times on my box. I didn't put it 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)

August 18, 2008 at 9:53 pm

#859787
RE: Need Help In Getting Required Result

Trevor,
This thread kinda got hijacked... are you all set?
--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 18, 2008 at 7:41 pm

#859760
RE: sum multiples matrix SubTotals

Sorry Marcello... a bit of ignorance on my part showing... didn't realize you were doing it in MDX and I know just about nothing about MDX. My appologies.
--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 18, 2008 at 7:10 pm

#859758
RE: setting the recovery model

bodhilove (8/18/2008)
Hope you don't find my explanation too dry...
I am transfering a 2000 db to 2005. I haven't been given a test environment to work with. I am migrating 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 18, 2008 at 6:58 pm

#859757
RE: Creating CLR assemblies with VS 2008

Dave (8/18/2008)
I was wondering when you'd show up to ask me that, Jeff 🙂
I have a stored procedure that creates files that are emailed as attachments by sp_send_dbmail. ...
--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 18, 2008 at 6:55 pm

#859756
RE: TXT file for each table

bluepaperbag (8/18/2008)
Mr. Jeff,
Yes, the 40 tables have different columns but they all have the same createdate and changedate columns which helps for the incremental extract.
The format has to be pipe...
--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 18, 2008 at 6:13 pm

#859753
RE: Difference between SQL Server Standard edition - OEM version , retail and Promo version

If there's that big a price difference, I'm thinking that the OEM version may be the Standard Edition...
--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 18, 2008 at 6:08 pm

#859752
RE: Query Question

You bet... thank you for the feedback.../ 🙂
--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 18, 2008 at 5:55 pm

#859749
RE: Instead of Using Cursor? Other Ways?

pockeyfan (8/18/2008)
Hi, karthikeyan, thanks
However, I could only get the " ed9xxxx@gmail.com" with your codes...
Did you try the function I gave 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 18, 2008 at 5:47 pm

#859748

Viewing 15 posts - 48,691 through 48,705 (of 59,095 total)