Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,856 through 45,870 (of 59,095 total)

RE: Why do people need to do this?

noeld (1/16/2009)
Answer: Because pigs can fly!
LOL! Oh Lordy, that's what I'm starting to think about the reasons behind this problem. 😛
--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)

January 16, 2009 at 3:34 pm

#928571
RE: working with multiple dataset withing a table in SSRS

Jeff Moden (1/13/2009)
bsrlong (1/13/2009)
As soon As I do find a solution I will not just post a reply I will attempt to have a document available.
I am certainly looking forward...
--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)

January 16, 2009 at 3:28 pm

#928569
RE: Why do people need to do this?

Lynn Pettis (1/16/2009)
The excuse I usually here is this:
It's easier to create and transfer one file instead of multiple files.
Now THAT I get! It's a bit strange in how...
--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)

January 16, 2009 at 3:14 pm

#928555
RE: Why do people need to do this?

Lowell (1/16/2009)
clearly any data without an arbitrary number next to it is worthless! everyone knows that! how else do you know who's number 1, or to give a goals 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)

January 16, 2009 at 3:11 pm

#928552
RE: Why do people need to do this?

Matt Miller (1/16/2009)
If you were a marketing person for CDW - knowing what the top five selling products are within each sales department would be something important. The last...
--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)

January 16, 2009 at 3:09 pm

#928548
RE: Why do people need to do this?

Luke L (1/16/2009)
...to put into a flat file full of repeating groups to send to another organization.
Heh.. that's what you did... my question would be, why did they want it...
--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)

January 16, 2009 at 3:05 pm

#928546
RE: Evaluate a string Expression

ramsatish (1/15/2009)
Hi Michael Earl ,
Thank you for the quick reply.
How we are going to achieve this using CLR procedure.
Is there any method/funtion available in CLR(SSIS) like "eval" to evaluate 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)

January 16, 2009 at 2:29 pm

#928532
RE: Evaluate a string Expression

ramsatish (1/15/2009)
Hi,
I have a table which has expression as a column and the data looks similar to the following .
ID (int) ...
--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)

January 16, 2009 at 2:16 pm

#928523
RE: SQL or Oracle

hb21l6 (1/16/2009)
It would appear that I have made a bit of a stir with this question. Sorry all,
I think I’ll just stick at my MS SQL. Should be ready 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)

January 16, 2009 at 1:34 pm

#928497
RE: Hidden RBAR: Triangular Joins

Caleb (1/16/2009)
Thanks Jeff. In your example, I presume everyone would be running around trying to figure out why tempdb was filling up and without 2005's dmvs would find that task...
--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)

January 16, 2009 at 1:26 pm

#928493
RE: Which SQL would run faster?

leonp (1/16/2009)
ok now that things are returning to normal do we think ISNULL performing better than COALESCE for checking a single operand is no co-incidence?
I don't believe they intentionally did...
--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)

January 16, 2009 at 1:08 pm

#928480
RE: Phone Numbers Table Design

Krishna_DBA (1/16/2009)
According to Abhijits design, I would have to create 6 unique ID's If a particular customer has 6 work phone numbers. is that right??
That's correct... and you shouldn't have...
--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)

January 16, 2009 at 1:03 pm

#928471
RE: Phone Numbers Table Design

By the way... if you do contact CCMI, the wizard behind the curtain that makes it all work is called Ed Sullivan. Laugh if you want, that's his real...
--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)

January 16, 2009 at 1:00 pm

#928469
RE: Phone Numbers Table Design
Jack Corbett (1/16/2009)
Interesting, Jeff. I am in process of developing a system that needs to handle international phone numbers and we decided to go with this design:
Countries (country_code (iso),...
--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)
January 16, 2009 at 12:56 pm

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

By the way, Julie... what does the prefix "Wrt" stand 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)

January 16, 2009 at 12:33 pm

#928447

Viewing 15 posts - 45,856 through 45,870 (of 59,095 total)