Jeff Moden

Forum Replies Created

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

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
RE: QA and SP - different resutls

Heh... I shouldn't post so late at night... I forgot the bloody spaces. :hehe:
--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 12:32 am

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

Actually, all of the answers given use a performance crushing technique that will kill a server with relatively few rows. It's called a "Triangular Join" and it can be...
--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 12:21 am

#952894
RE: Random records with no duplication Script

Bagath (2/19/2009)
Thank you sooo much for simple and awesome query.....
Any more alternates?
Thanks,
Heh... WHY? Isn't that one good enough? 😉
--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 12:13 am

#952891
RE: QA and SP - different resutls

WHERE (a ISNULL AND b ISNULL)
--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 12:11 am

#952890
RE: Convert Row Values into Column

bhuvaneshwari_m (3/3/2009)
Me too in need of same kind of requirement....help pls...
http://www.sqlservercentral.com/articles/cross+tab/65048/
--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 12:04 am

#952889
RE: Performance Issues

briangillock (2/12/2009)
Should it take 17-20 seconds to return a simple count? Another, relatively simple query takes 2-4 hours to run. I realize that can be very much affected...
--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 3, 2009 at 10:24 pm

#952869

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