Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,971 through 44,985 (of 59,101 total)

RE: Update previous close price.

Alright, Ashwin... here's the whole shootin' match including your original posted table except that I included the clustered PK. I've verified that it returns exactly what your code 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)

February 25, 2009 at 9:01 pm

#950390
RE: A Case For Concatenation (Building Delimited Strings ) In T-SQL

Bob Hovious (2/25/2009)
I'm still curious as to why the elapsed times for you (displaying the data) are so dramatically different from the times I get running your code. ...
--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)

February 25, 2009 at 8:02 pm

#950373
RE: Display column of different rows as column of a single row

Bob Hovious (2/25/2009)
Unfortunately, I'm applying that lesson to you as well, even though everyone tells me "If Jeff says it, just go with it."
I absolutely agree with and support...
--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)

February 25, 2009 at 7:55 pm

#950371
RE: Are the posted questions getting worse?

I'm going to give up my formatting habits on this forum... from now on, I'm going to post all code with no comments, all upper case, and, heh... no spaces......
--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)

February 25, 2009 at 7:24 pm

#950367
RE: Are the posted questions getting worse?

jcrawf02 (2/25/2009)
*sniff *sniff - smells like fish in here. :hehe:
I think perhaps what we're looking for are a couple of questions that need to be answered as part 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)

February 25, 2009 at 7:00 pm

#950365
RE: Are the posted questions getting worse?

Steve Jones - Editor (2/25/2009)
I like that code, but then Jeff will get upset over the leading commas. I find myself constantly moving his trailers to leaders. Can't someone explain...
--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)

February 25, 2009 at 6:53 pm

#950362
RE: Are the posted questions getting worse?

GSquared (2/25/2009)
Bob Hovious (2/25/2009)
Hey G 🙂
It's not barrier to entry. Nobody has to take a test on the material. It's just something that first...
--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)

February 25, 2009 at 6:47 pm

#950360
RE: Are the posted questions getting worse?

lmu92 (2/25/2009)
From my point of view any type of best (or recommended) practice does not need to be mentioned as an "entry requirement for requests" unless there is any "reward"...
--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)

February 25, 2009 at 6:40 pm

#950357
RE: Where did Taskpad go?

David Burrows (2/25/2009)
I'm using 2k5 at sp2... and there's no "Summary" selection in the "View" menu... has anyone actually tried this?
I belive it was changed in SP2.
Right click on...
--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)

February 25, 2009 at 6:24 pm

#950354
RE: Converting to Month-Year Format

Sunil Kumar (2/25/2009)
Hi There,
Here is my query....I am getting Daily Sum of MINUTS.
I would likt to make it as Monthly Sum if possible.
SELECT CONVERT(VARCHAR,[Date],105) as DATE,
...
--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)

February 25, 2009 at 6:14 am

#949923
RE: Update previous close price.

Ashwin M N (2/25/2009)
The Detail_ID is in sorted order by Inventory_Code and Detail_Date.
Why is that when I pass a parameter(Inventory_Code) values are updated correctly? If it was not sorted...
--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)

February 25, 2009 at 6:11 am

#949919
RE: Where did Taskpad go?

Thanks folks... darned thing isn't there 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)

February 25, 2009 at 6:09 am

#949918
RE: Performance Problem

Is it actually a table... or is it actually a view?
--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)

February 25, 2009 at 5:21 am

#949884
RE: Where did Taskpad go?

iainthepitman (2/25/2009)
http://www.sql-server-performance.com/faq/taskpad_view_ssms_p1.aspx
I'm using 2k5 at sp2... and there's no "Summary" selection in the "View" menu... has anyone actually tried this?
--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)

February 25, 2009 at 5:19 am

#949881
RE: Automation fun

Pretty much. Some folks actually use it to get around "parameter sniffing" problems.
--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)

February 25, 2009 at 4:55 am

#949873

Viewing 15 posts - 44,971 through 44,985 (of 59,101 total)