Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,836 through 44,850 (of 59,101 total)

RE: Select distinct row on SQL 2000. Please help me!

tuyetmuadong (3/3/2009)
This result is my demo. Actually, we can get (2, TRG, TFS) or (2, DFG, EFB). That is ok. I only care value of LINK field, I don't care...
--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)

March 4, 2009 at 6:54 pm

#953730
RE: The February 2009 Energy Update

Luke L (3/4/2009)
no, but liquid nails works adequately well for these types of applications.
Heh... So does two short nails.
--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)

March 4, 2009 at 6:05 pm

#953725
RE: Are the posted questions getting worse?

Grant Fritchey (3/4/2009)
This post has a bit irony attached I think:
http://mangalpardeshi.blogspot.com/2009/03/how-to-disable-right-click-on-your-blog.html
10 pounds worth...
--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)

March 4, 2009 at 4:46 pm

#953701
RE: Are the posted questions getting worse?

Derek Dongray (3/4/2009)
I skimmed over most of Mangal's blog posts and felt that there wasn't much there which I hadn't come across elsewhere. Nothing wrong with that really (although 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)

March 4, 2009 at 4:33 pm

#953696
RE: Are the posted questions getting worse?

bitbucket (3/4/2009)
heck it is their culture.
I hate people that won't adapt and that think the world needs to kiss their hiney just cuz they were spawned from the right 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)

March 4, 2009 at 4:29 pm

#953692
RE: Query for "as of Date"

Grant Fritchey (3/4/2009)
I always forget they're there when I post. Makes me crazy.
:D:P;):w00t::cool::hehe:
Heh... I don't get it... remember when they fixed it so spaces would be preserved? They just...
--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)

March 4, 2009 at 4:23 pm

#953687
RE: Question on following sql

steveb (3/4/2009)
nymgk_75 (3/4/2009)
Hey Jeff,
Thanks for the reply! I like your way also...
Can you explain what the "U" is used for then? We didn't have that in 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)

March 4, 2009 at 4:19 pm

#953684
RE: Question on following sql

beezell (3/4/2009)
Good point Jeff. I almost put the word "Scope" in there for the dropping of temp tables, but I was afraid I would overcomplicate the explaination. Good...
--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)

March 4, 2009 at 4:15 pm

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

calston (3/4/2009)
Jeff, this was like a God-sent article to me. It's fantastic. I do need to add a few more groupings, but without your article I would not have been...
--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)

March 4, 2009 at 4:12 pm

#953678
RE: Sum of previous rows till this row.

souLTower (3/4/2009)
I knew I remembered a way to do this with variables!
Heh... yep... that's the way, ST. Just gotta remember that you need to add a WITH (INDEX(0)) (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)

March 4, 2009 at 4:07 pm

#953676
RE: Table Value Function

nwinningham (3/4/2009)
Here is the data from the three tables. Please see attached.
Just a suggestion... a good number of us have not upgraded to Office 2007 and some of...
--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)

March 4, 2009 at 4:00 pm

#953672
RE: "Answered" Posts

Mangal9i (3/4/2009)
Hahaha...
Jeff Thank for advice.
In some of those deleted posts, I also mentioned that my self has asked such questions 100times... yes 100 times, or may be more than 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)

March 4, 2009 at 3:54 pm

#953669
RE: "Answered" Posts

Heh... has anyone noticed than Mangal deleted all but one of his posts here? And, take a look at the following... he'll be an excellent poster because 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)

March 4, 2009 at 7:49 am

#953208
RE: converting milliseconds

ramu4ind (2/25/2009)
Hi,
how to convert milliseconds into hours,minutes,seconds and milliseconds.
i have two dates from that i have taken milli seconds using datediff.now i want to display total hours,minutes,sec,millisec in that milli...
--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)

March 4, 2009 at 7:30 am

#953177
RE: QA and SP - different resutls

GilaMonster (3/4/2009)
Jeff Moden (3/4/2009)
Heh... I shouldn't post so late at night... I forgot the bloody spaces. :hehe:
Howcanyouforgetthespaces?
heh.BecauseAllMyVariablesAndColumnNamesAreMixedCaseAndItsBecomeAHabit. 😛
--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)

March 4, 2009 at 6:04 am

#953059

Viewing 15 posts - 44,836 through 44,850 (of 59,101 total)