Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,406 through 45,420 (of 59,095 total)

RE: Calculating UnitPrice Discounts

Correct... and a 30% discount rate would mean you only pay 70% of the unit price and that's the other reason for the 1... you subtract 30% (0.3) from 1...
--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)

January 30, 2009 at 12:24 pm

#935782
RE: count of consecutive value

Thanks, Martin... if someone doesn't beat me to it, I'll give it a whirl after work.
--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)

January 30, 2009 at 9:43 am

#935669
RE: What are the Party Plans?

jgrubb (1/30/2009)
Lynn Pettis (1/29/2009)
Jeff Moden (1/29/2009)
jgrubb (1/29/2009)
Completely Off-Topic, I wanted to see who started the Pork Chop thing,
Heh... do you really have to wonder? 😛
Cardinal Moden himself,...
--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)

January 30, 2009 at 9:41 am

#935667
RE: Are the posted questions getting worse?

Sounds like a lot of fun but, consider this, would you like it if your post and name showed up on a "Twit List". Bad enough they show up...
--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)

January 30, 2009 at 9:25 am

#935651
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Thanks for the detailed explanation... I'll take a look tonight after I get home.
--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)

January 30, 2009 at 6:04 am

#935454
RE: Multiple Resultset in a single resultset (UNION)

See the following...
http://www.sqlservercentral.com/articles/Test+Data/61572/
Better question would be, what are you really concatenating and why?
--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)

January 29, 2009 at 11:56 pm

#935312
RE: tempdb - Restricted File Growth option

You can shrink temp DB through the GUI without bouncing the server or the service.
My question would be... what's causing it to grow to 50GB? There's definately something like...
--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)

January 29, 2009 at 11:52 pm

#935311
RE: Determining whether a Stored Procedure returns a resultset

krayknot (1/29/2009)
PhilPacha (1/28/2009)
A former co-worker has asked this question; I admit, I'm a bit intrigued.
Given the name of a stored procedure, is there an “efficient” way to determine...
--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)

January 29, 2009 at 11:44 pm

#935310
RE: records with distinct IDs

rog pike (1/29/2009)
nabajyoti.b (1/28/2009)
the record that appears first in order
select emp_id,emp_name,emp_address,rank
from
(select emp_id,emp_name,emp_address,
row_number()over(partition by emp_address order by emp_name) as rank
from ##emp) as A
where rank=1
order by emp_address,emp_name
emp_id emp_name ...
--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)

January 29, 2009 at 10:56 pm

#935296
RE: Calculating UnitPrice Discounts

AFCC Inc. Com (1/29/2009)
Thanks,
Is the UnitPriceDiscount a percentage or a number ?
select 10 *((1.0)-4)* 6
or
select 10 *((1.0)-.25)* 6
Heh... you tell us... you're the one that can see the table....
--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)

January 29, 2009 at 10:53 pm

#935295
RE: records with distinct IDs

Tim Wilson-Brown (1/29/2009)
Lowell (1/28/2009)
in that case, it is impossible, unless you modify your table to include an identity column.
Which is not reliable either - what if the identity values wrap?
There...
--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)

January 29, 2009 at 10:17 pm

#935283
RE: Calculating UnitPrice Discounts

The 1.0 is to implicity force the calculation to a FLOAT datatype if everything turns out to be an INTEGER. The rest is a matter of simple substitution and...
--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)

January 29, 2009 at 10:11 pm

#935282
RE: count of consecutive value

I'll trade ya... 😉 Tell me the business reason behind this and I'll give you some code to do it. The reason for the "trade" is, I'm writting...
--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)

January 29, 2009 at 10:09 pm

#935281
RE: performance issues

I recently ran into a similar problem (this morning, in fact). The backups to disk had taken up all the harddrive space because they had a problem getting moved...
--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)

January 29, 2009 at 9:59 pm

#935279
RE: Slack SQL Server

Gift Peddie (1/29/2009)
Oracle does not sell developer edition...
Correct... instead, they give it away as a free download. 😉
--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)

January 29, 2009 at 9:52 pm

#935277

Viewing 15 posts - 45,406 through 45,420 (of 59,095 total)