Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,316 through 39,330 (of 59,102 total)

RE: Calculating total working hours exclude launch, smoking...and etc times

Dehqon D. (3/15/2010)
For me SQL is in learning process, hope can get knowledge soon and help to people like you 🙂
P.S: Reposting 3rd time, after waiting after half hour
Ummm... maybe...
--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 16, 2010 at 8:10 pm

#1134946
RE: Splitting A String

Paul White (3/16/2010)
The tally-table method ... {snip} ... is far, far, superior.
Almost as good a a CLR string splitting function in fact.
Heh... keepsake that is right thar...
--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 16, 2010 at 7:13 pm

#1134943
RE: Computed Column Help Please

GSquared (3/16/2010)
Why the complexity?
The SessionID is used to group 2 to 30 people who attended the same meeting e.g The attendee will have a ServiceID(PK), Date, Time, Meeting Room, Speaker,...
--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 16, 2010 at 7:07 pm

#1134942
RE: Computed Column Help Please

GSquared (3/16/2010)
Jeff, it's c. 60M rows per month, because of the prefix. That's probably enough for most business purposes (unless you're Amazon, Google, et al).
Heh... Yep. I forgot...
--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 16, 2010 at 7:00 pm

#1134941
RE: T-SQL: Why “It Depends”

The Dixie Flatline (3/16/2010)
Jeff: Simply thanks. I've told you before at length how much I owe you. It's good not to be savaged...
--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 16, 2010 at 7:02 am

#1134406
RE: Add business days to a date field

sturner (3/12/2010)
sure, shoot me a private message with an email address.
Nah... do here... in the open where everyone can learn.
--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 15, 2010 at 10:47 pm

#1134250
RE: Concurrent instances of stored procedures

I have a requirement to run a stored procedure that does a lot of heavy processing.
I agree with Jeffrey above. I'll add that anytime I see the words "heavy...
--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 15, 2010 at 10:23 pm

#1134239
RE: Computed Column Help Please

Along with all the other problems people have stated (some having legal impact), the "code" also violates a couple of normal forms because it records 3 different pieces of information...
--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 15, 2010 at 9:40 pm

#1134225
RE: what is the most efficient way to maintain a denormalized table?

15 Hours? It would appear that, in your case, denormalization for reporting puposes is the wrong thing to do. I'd consider a more normalized approach that uses performance...
--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 15, 2010 at 9:23 pm

#1134216
RE: Splitting A String

jarjarlee (3/15/2010)
You should use a funcation.
define a funcation like
CREATE FUNCTION [dbo].[SplittingByDot]
(
@SourceData varchar(255)
)
RETURNS NVARCHAR
AS
BEGIN
......
END
then use the
SELECT dbo.SplittingByDot(OutlineNumber) FROM dbo.Tally
get the result
Other than...
--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 15, 2010 at 8:58 pm

#1134210
RE: select random records but for each category

mister.magoo (3/15/2010)
There is another problem with the previous solution
Which previous solution? 🙂
--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 15, 2010 at 8:01 pm

#1134200
RE: Manipulate Date Output

monitor89 (3/15/2010)
Got it figured out...
Original
substr(h.dob,5,2) || right(h.dob,2) || left(h.dob,4) as Birth_Date,
New
substr(h.dob,5,2) || '/' || right(h.dob,2) || '/' || left(h.dob,4) as Birth_Date,
...pretty easy actually.
How about ...
TO_CHAR(TO_DATE(h.dob,'yyyymmdd'), 'mm/dd/yyyy') AS Birth_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)

March 15, 2010 at 7:55 pm

#1134199
RE: Today's Random Word!

Lynn Pettis (3/14/2010)
snowshoes
One Post. 😉
--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 15, 2010 at 7:36 pm

#1134197
RE: Today's Random Word!

Kit G (3/15/2010)
But alas, intelligence is not a pre-requisite for becoming a pirate.
BWAA-HAAA!!!! According to some of the posts I've seen lately, it's not essentially required to be a...
--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 15, 2010 at 7:35 pm

#1134196
RE: Facing Problem With Bulk Insert

karthik -450760 (3/15/2010)
Thanks Jeff. I have attached the text file. Below is my create table stmt and Bulk Insert Statement.
Thanks Karthik... I have to ask though... is that an actual...
--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 15, 2010 at 7:18 pm

#1134193

Viewing 15 posts - 39,316 through 39,330 (of 59,102 total)