Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,696 through 43,710 (of 59,063 total)

RE: Rearranging data

Actually, because all of the row data is to be stored as CSV's in a single column, it's a concatenation job. Please see the following article for how 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)

May 21, 2009 at 6:58 pm

#998637
RE: How to trim the decimal places?

Bruce W Cassidy (5/20/2009)
Jeff Moden (5/20/2009)
Take Lynn's original advise... The third operand of ROUND will allow you to truncate instead of round. Heh... look it up in Books Online....
--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)

May 21, 2009 at 9:08 am

#998329
RE: How to trim the decimal places?

Bruce W Cassidy (5/20/2009)
[font="Verdana"]I guess the issue is with not wanting to round the decimal places. Sadly, even using the various formatting options in SQL Server Reporting Services will...
--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)

May 20, 2009 at 3:20 pm

#997941
RE: Eliminating Cursors

Charles Kincaid (5/20/2009)
Kevin Rathgeber (5/20/2009)
Charles Kincaid (5/20/2009)
If I remember correctly is this not how sequence generators in Oracle work?
Is that word allowed on this forum 😀
If we don't mention them...
--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)

May 20, 2009 at 3:16 pm

#997940
RE: Are the posted questions getting worse?

I think all kids should leave home just as soon as they think they know it all. Should save 10-12 years on upbringing.
--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)

May 20, 2009 at 3:14 pm

#997937
RE: Are the posted questions getting worse?

Roy Ernest (5/20/2009)
All of you need a vacation... You have all gone crazy.... 😛
Heh... SHHHH!!! It's fun to watch. 😛
--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)

May 20, 2009 at 3:12 pm

#997933
RE: Are the posted questions getting worse?

Alvin Ramard (5/20/2009)
Lynn Pettis (5/20/2009)
You know, there are a few people who just need to walk away from the computer and get a job flipping burgers or something.
Got it!
Oh, what'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)

May 20, 2009 at 3:06 pm

#997923
RE: Eliminating Cursors

Kevin Rathgeber (5/19/2009)
Hi Jeff.....I just read your solution regarding the sequence tables. Very good explanation. I have one minor concern (very minor). You have indicated having 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)

May 19, 2009 at 8:09 pm

#997348
RE: T-sql procedure error in job

The errors in the job output in the GUI are truncated and you're probably not seeing the whole thing and that's why it looks different. Notice that it didn't...
--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)

May 19, 2009 at 7:09 pm

#997343
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Very cool. Glad you could use so much of the article. Thanks for the feedback, Ray.
--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)

May 19, 2009 at 6:25 pm

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

fun_sunshine_summer (5/19/2009)
I have a problem where a value in one row of the record set is base on the value of the previous row. I hate doing RBAR so 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)

May 19, 2009 at 3:16 pm

#997268
RE: I've tried this on 2 other forums, does anyone know the answer?

Paul White (5/17/2009)
Jeff:
This was what I was referring to: (with emphasis this time!)
EdVassie (5/5/2009)
The only definite answer to this problem is 'it depends'.
So 'it depends' is a definite answer... 😀
BWAA-HAAA!!!...
--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)

May 18, 2009 at 3:51 pm

#996670
RE: Fastes way to increment an id column

Florian Reischl (5/17/2009)
Why? :unsure:
I use this since about 5 years. Long time before I joined SSC 🙂
Heh... ok... then 5 bucks for posting a cursor solution to a set based...
--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)

May 18, 2009 at 3:49 pm

#996669
RE: Fastes way to increment an id column

Florian Reischl (5/17/2009)
Thanks Jeff!
It's not a big deal but if I get one Dollar for every time I showed somebody to remove a cursor I would be a rich man...
Best...
--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)

May 17, 2009 at 11:57 am

#996048
RE: Oracle Query help!

Frank He (5/17/2009)
In aircraft industry, the flight from one place to its destination called leg, but some requests have mulitple stops (legs). I need to caculate the turn time 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)

May 17, 2009 at 11:39 am

#996045

Viewing 15 posts - 43,696 through 43,710 (of 59,063 total)