Jeff Moden

Forum Replies Created

Viewing 15 posts - 53,821 through 53,835 (of 59,089 total)

RE: Dynamic Query Problem

you need to first EXPAND the precision BEFORE the operation, and then DECREASE the PRECISION when you're done....
Heh... and what better way to do that than to use FLOAT...
--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 30, 2007 at 11:21 am

#756085
RE: Disk Sace Usage

b_boy (11/29/2007)
I used the following script to create the table for the results to be inputed into the space_used table, but doesnt to work as i get 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)

November 30, 2007 at 11:08 am

#756081
RE: Naming Convention of Stored Procedures

"That's the way we do it here".
Heh... that reminds me of a saying...
"Even if the majority agrees on an idiotic idea... it's still an idiotic idea." 😛
--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 30, 2007 at 10:52 am

#756076
RE: help with isnull()

Heh... thanks for that, Jason. Hope a couple of other folks take heed of that little lesson...
In the meantime, what's the best way for me to get this dried...
--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 30, 2007 at 10:48 am

#756073
RE: Dynamic Query Problem

Heh... oh yeah... almost forgot...
"NO... I am NOT smarter than a 5^th grader!" 😛
--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 30, 2007 at 10:41 am

#756070
RE: Dynamic Query Problem

Another surprising for someone result comes from simple primary school exercise.
X / N * M = X * M / N
Is it true?
( :blush: Wait a minute...
--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 30, 2007 at 10:34 am

#756068
RE: Documention

Jpotucek,
C'mon... I'm trying to help... I need the answers to the questions I asked above so we can avoid the problems you're having...
--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 30, 2007 at 8:48 am

#756002
RE: The 5 Stages of Volunteering

Now isn't that odd... aren't those the same stages as a job? 😉
--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 29, 2007 at 9:46 pm

#755795
RE: Get record count for every table in a DB (1 Step)

Better think about DBCC UPDATEUSAGE once in a while....
--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 29, 2007 at 9:41 pm

#755793
RE: Simple query on select statement using variables...

Heh... I know the feeling...
Study sp_ExecuteSQL in BOL... it'll show you how to do exactly what you want.
--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 29, 2007 at 9:17 pm

#755790
RE: query optimization

It would be very helpful if you put this in just before the exec and printed out the result for us...
PRINT @strQuery
--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 29, 2007 at 9:15 pm

#755789
RE: Naming Convention of Stored Procedures

Dang, Joe... between this and the NULLs problem, I'm thinking that you've landed in a doozy of a place. Who are these geniuses that you keep having fights about...
--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 29, 2007 at 9:08 pm

#755787
RE: multiple nested select statments in 1 query

I appologize ahead of time for the layout of my code on this page.
Heh... if you took 5 minutes out ahead of time to fix it, you wouldn't have...
--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 29, 2007 at 8:59 pm

#755784
RE: Writing to a file from a stored procedure using DTS

You might have a bit more luck getting a response to your posted this in the "Data Transformation Services" forum...
--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 29, 2007 at 8:56 pm

#755783
RE: Bulk Insert skipping second row

Yeah... that's the disappointing truth...
I'm actually on vacation, right now... I'll see if I can find that script at work on Monday... it's in a piece of automation 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 29, 2007 at 8:51 pm

#755782

Viewing 15 posts - 53,821 through 53,835 (of 59,089 total)