Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,281 through 47,295 (of 59,102 total)

RE: Arrays in Stroed Prcoedure

doss.tychicus (11/10/2008)
I'm trying to get the data from the table
between two dates and for the List of Doctors
select * from tbl_test
where convert(char(10),createdate,121) between '2008-01-01'
and '2008-12-31' and id_doctor in (1,2,3,4,5)
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)

November 13, 2008 at 5:13 pm

#898358
RE: Arrays in Stroed Prcoedure

krayknot (11/10/2008)
doss.tychicus (11/10/2008)
I'm trying to get the data from the table
between two dates and for the List of Doctors
select * from tbl_test
where convert(char(10),createdate,121) between '2008-01-01'
and '2008-12-31' and id_doctor 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)

November 13, 2008 at 5:07 pm

#898357
RE: Generate a random password

Pretty nice, Gaby... your article and some of the comments above gave me a couple of ideas for an article with just a pot-wad of tricks in it... Ok if...
--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)

November 13, 2008 at 12:24 pm

#898247
RE: CTE vs Derived Table

Jim Russell (11/13/2008)
Damn, I learn a lot by lurking on this site. Guess I'll start using more temp tables. Thanks to all.
Oh, be careful, Jim... while I'll admit to using...
--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)

November 13, 2008 at 6:24 am

#898022
RE: Compare Dates in an iterative manner for a particular set of records

prabhu.rangan (11/12/2008)
Hi Members,
I have two tables named 'result' and 'status' for which i have 'status_key_id' in my result table with default 'null'. I have to update the 'key_id' of 'status'...
--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)

November 13, 2008 at 6:12 am

#898017
RE: CTE vs Derived Table

... thanks for the leg up, Lynn. 😛
--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)

November 12, 2008 at 10:21 pm

#897898
RE: Exporting resultset of temp table to other formats. How?

If you put all your stuff to create the result set in a temp table with no other output, not even rowcounts, and do a final SELECT from the TempTable...
--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)

November 12, 2008 at 10:11 pm

#897897
RE: PASS summit 2008

I can't go. I've got tickets and everything but something came up today and I can't go. :crying: Somebody take pictures for me.
--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)

November 12, 2008 at 10:01 pm

#897893
RE: Using Split() Function Insert Value in DataBase?

"Novice" my butt :)... you've been paying attention. 😉
--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)

November 12, 2008 at 9:56 pm

#897892
RE: CTE vs Derived Table

Well I'll be damned... didn't even notice until just now... 12,000+ posts... Steve owes me a shirt or two! 😛
--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)

November 12, 2008 at 9:35 pm

#897887
RE: CTE vs Derived Table

ggraber (11/12/2008)
I was really looking for some basic guidelines.
I really have come to love the readability of CTEs.
I just wanted to make sure I wasn't compromising performance.
I guess if...
--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)

November 12, 2008 at 9:28 pm

#897886
RE: CTE vs Derived Table

ggraber (11/12/2008)
BTW Jeff, I've been meaning to ask you this:
How on earth do you have time to give such thorough answers to so many people on the forums???
I'm really amazed!!
Heh......
--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)

November 12, 2008 at 9:21 pm

#897883
RE: Compare Dates in an iterative manner for a particular set of records

Sorry... almost forgot... borrowed on Carla's good code and expanded the test data set a bit for my testing...
CREATE TABLE PersonRecord ( PersonID int NOT NULL, Version int NOT NULL,DEDate...
--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)

November 12, 2008 at 9:03 pm

#897881
RE: Compare Dates in an iterative manner for a particular set of records

You should see what happens with the correct and incorrect indexing. Adams code (using his because Carla rated it as the fastest) is more than twice as fast as...
--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)

November 12, 2008 at 8:42 pm

#897876
RE: Compare Dates in an iterative manner for a particular set of records

Sorry... looks like those were CPU times.
--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)

November 12, 2008 at 8:37 pm

#897875

Viewing 15 posts - 47,281 through 47,295 (of 59,102 total)