Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,926 through 47,940 (of 59,099 total)

RE: combining multiple rows into one

Zypsy absolutely wants to use a spreadsheet because of some functionality that's easily available there. Although I normally oppose denormalized pivots for processing, Zypsy may be correct here and...
--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)

October 6, 2008 at 5:30 am

#881031
RE: Date range to also compute previous date per no. of days

This forum is a bit odd... it sometimes turns left parenthesis into smiley faces. There was one in the test code generator. I've repaired that. Also, 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)

October 6, 2008 at 5:22 am

#881029
RE: Date range to also compute previous date per no. of days

Ok... got it. Since you didn't post the data in an easy to consume format and I just can't bring myself to post untested code, you'll have to put...
--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)

October 5, 2008 at 11:31 pm

#880963
RE: combining multiple rows into one

That's better, but guess what this code means?
SELECT BillDaten, CustCode, COUNT(*) AS ThingsThatNeedPivoting
FROM Sample_Data
GROUP BY BillDaten, CustCode
HAVING COUNT(*) > 1
BillDaten ...
--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)

October 5, 2008 at 10:37 pm

#880958
RE: Date range to also compute previous date per no. of days

clint_pow (10/5/2008)
Note :
The input date range may vary!
Will those ranges always be for whole months that start on the first of a month and end on the last of 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)

October 5, 2008 at 10:16 pm

#880956
RE: Let the Excel Play

shashank (10/5/2008)
I know that, an SSChampion won't 😀
Heh... OK. If you're going to throw a conversation on the floor with stuff like that, I guess this conversation is over.
--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)

October 5, 2008 at 10:05 pm

#880955
RE: Pull data from one Column for a report

You bet. Thanks for the feedback, Alex. 🙂
--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)

October 5, 2008 at 8:48 pm

#880949
RE: Let the Excel Play

David.Poole (10/5/2008)
Does it work? Yes
Should it be used? Not if you want a robust scaleable solution.
In the environment where I work we had to buy and install 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)

October 5, 2008 at 8:42 pm

#880948
RE: Let the Excel Play

shashank (10/5/2008)
...why would you write plain text queries for what can be achieved through a stored procedure.
I never said I would. 😉
--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)

October 5, 2008 at 8:37 pm

#880945
RE: The Weekly News for Oct 6, 2008 (Database Weekly)

Heh... what a teaser you are. You just know that I'm going to challenge Phil's findings, don't ya? 🙂
--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)

October 5, 2008 at 8:35 am

#880920
RE: combining multiple rows into one

...AND, if you really want to pivot the data as you say (I still think it's a mistake), take a look at the following article. If you use 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)

October 5, 2008 at 8:29 am

#880919
RE: combining multiple rows into one

You might also want to describe the analysis you intend to do. I see where you say what you think you need to do to the data, but 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)

October 5, 2008 at 8:20 am

#880918
RE: combining multiple rows into one

Heh... yeah, for you, maybe. If you want my help, please post it in the readily consumable form along with a table creation statement like I asked for 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)

October 5, 2008 at 8:16 am

#880917
RE: Let the Excel Play

Don't get me wrong... I'm not bad mouthing your code or your article... I actually gave it a good mark. 😀
There's only one item on a list of benefits that...
--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)

October 5, 2008 at 7:35 am

#880914
RE: combining multiple rows into one

You'll actually be increasing the level of complexity to do the analysis if the analysis will be done by computer and not a human.
Post some data according to the specs...
--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)

October 5, 2008 at 7:10 am

#880909

Viewing 15 posts - 47,926 through 47,940 (of 59,099 total)