Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,311 through 50,325 (of 59,091 total)

RE: Errors with Select query

Yes, but that bit of math is the divisor in a larger formula...
CASE WHEN (SUM(CONVERT(NUMERIC,CRC.Contact))*100) <> 0.0 THEN ISNULL(CONVERT(DECIMAL(6,2),(SUM(CONVERT(NUMERIC,CRC.Contact))/(CONVERT(DECIMAL(6,2),(SUM(TalkTime + HoldTime + WrapTime + WaitTime + PreviewTime +...
--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)

May 25, 2008 at 9:01 am

#820062
RE: sa removal

If you simply rip the SA rug out from under them, you'll make a lot of enemies... you need to get management to buy into a good security plan where...
--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)

May 25, 2008 at 8:55 am

#820061
RE: decrypt sql server 2005 sp

Ok... thanks...
Like the others have said, if you do a Google or other search, you'll find several articles on how to do this. It's just not something that most...
--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)

May 25, 2008 at 8:49 am

#820060
RE: User Defined Function With CTE

Marvin,
So, is the CTE a good enough solution for you?
Shifting gears a bit... its pretty clever how they put the test question assessment list together so that it works against...
--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)

May 24, 2008 at 8:43 pm

#820041
RE: decrypt sql server 2005 sp

avipenina (5/21/2008)
hi,
how can i decrypt a stored procedure in sql server 2005?
THX
I'm curious... where is your source code? Or are to trying to break in on someone else?
--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)

May 24, 2008 at 6:13 pm

#820036
RE: Query to retrive distinct id in child table

sharma (5/24/2008)
Hi i need a query for below scnario
[font="Arial Black"]TblMaster[/font]
ID NAME
100 James
101 Joseph
102 Felix
103 bernadsha
[font="Arial Black"]TblChild[/font]
ID NAME LOCATION
100 James New Jersy
101 Joseph California
102 Felix New York
103...
--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)

May 24, 2008 at 6:10 pm

#820035
RE: Errors with Select query

Obviously, the following creates a zero somewhere...
TalkTime + HoldTime + WrapTime + WaitTime + PreviewTime + DeadTime
What do you want to do when you have a zero in that simple...
--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)

May 24, 2008 at 6:06 pm

#820034
RE: User Defined Function With CTE

FROM LD_SDT
LEFT OUTER JOIN WK_SDT_ORGANIZER B 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)

May 24, 2008 at 5:48 pm

#820032
RE: data mining structure processing issue

Please check you post... can't see what you posted for the "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)

May 24, 2008 at 4:43 pm

#820026
RE: sa removal

It's easy... don't try to remove the SA login... just change the password and don't give it out to anyone, ever...
--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)

May 24, 2008 at 4:23 pm

#820025
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

Matt Miller (5/23/2008)
The funny clothes I can deal with. The tin foil hat on the other hand...:)
Heh! C'mon... I don't wear the hat in public... and no one...
--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)

May 24, 2008 at 4:17 pm

#820024
RE: DELETE DUPLICATE RECORDS

Heh... TODD!!!??? Why are you having me figure it out... run it against the table generator I provided and report your findings! 😀
The answer to your question is...
--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)

May 24, 2008 at 4:13 pm

#820023
RE: User Defined Function With CTE

Heh... post the other data from the other table and let's see if we can get it down to a couple of minutes, eh? 🙂
--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)

May 24, 2008 at 3:55 pm

#820022
RE: Database Design for 100GB DB

CrazyMan,
I have a similar situation at work... Just to be sure... you're talking about 24 tables, correct?
Just to be sure, you ARE using 2005, correct?
How many (order of magnitude) rows...
--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)

May 24, 2008 at 9:44 am

#820003
RE: User Defined Function With CTE

Marvin,
I'm a bit confused and I'm obviously missing something.... I looked at the 100 rows of test data you attached... Without me wading through all the code you posted, what...
--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)

May 24, 2008 at 9:33 am

#820002

Viewing 15 posts - 50,311 through 50,325 (of 59,091 total)