Jeff Moden

Forum Replies Created

Viewing 15 posts - 53,866 through 53,880 (of 59,089 total)

RE: Dynamic Query Problem

The conversion caused the radius value to lose precision:
Heh... who cares about the precision... using FLOAT, you've lost some accuracy. Think not? Try this...
DECLARE @Radius FLOAT(53)
...
--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 28, 2007 at 6:47 pm

#755200
RE: Why is this slow?

Perfect. Thanks for the feedback.
Just to be sure... you know what the "Tally" table is and how to build 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)

November 28, 2007 at 3:05 pm

#755163
RE: Help with Registered and Trademark symbols

Similar thing can be done in SQL Server...
SELECT Number AS CharNum, CHAR(Number) AS Character
FROM Master.dbo.spt_Values
WHERE Type = 'P'
AND Number <...
--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 28, 2007 at 3:00 pm

#755160
RE: Foreign keys good or bad practice?

Interesting. Can you post the code that you used to perform your test?
Now, you sound like me 😀 and, dang it... ya beat me to it 😛
--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 28, 2007 at 2:49 pm

#755158
RE: Script table into a single create statement

Outstanding, Edogg! Thank you for the feedback!
--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 28, 2007 at 2:38 pm

#755153
RE: Help with Registered and Trademark symbols

By the way... your code seems to indicate that the Grade_ID is stored as a VARCHAR. If it's trully a numeric throughout, you may want consider changing the datatype...
--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 28, 2007 at 2:36 pm

#755151
RE: Help with Registered and Trademark symbols

This should do it...
UPDATE Grade
SET Grade_Name = CASE
WHEN Grade_ID = '35800'
THEN 'TRANSCOPY' + CHAR(153) --™
...
--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 28, 2007 at 2:33 pm

#755146
RE: Why is this slow?

Not trying to be a smart guy here...
What did you learn by 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)

November 28, 2007 at 2:13 pm

#755141
RE: Documention

Jpotucek (11/28/2007)
trying to come up with a few commands that I can use to query my SQL Server 2000 Instances and Document my Databases - preferably Excel
exec sp_helpdb comes...
--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 28, 2007 at 2:03 pm

#755136
RE: Who's responsible for the Data Model?

That's easy... it would be the person with the most to loose if the design is bad 😉 That's the only way someone will be interested enough in doing...
--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 28, 2007 at 1:41 pm

#755124
RE: SCOPE_IDENTITY Puzzle

Doug Stoltz (11/28/2007)
Jeff, I've got a couple more questions for you:
1) I belive my earlier statement about the 2 web users sharing the same connection are correct, but I believe...
--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 28, 2007 at 1:30 pm

#755121
RE: SCOPE_IDENTITY Puzzle

oh, be careful with IDENT_Current... lot's of folks can insert rows in that very brief time span between the time you do an insert and the time you use IDENT_Current.
--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 28, 2007 at 12:59 pm

#755115
RE: Script table into a single create statement

Sorry about the EM thing... still trying to flatten out a crease in my brain with coffee...
If you set the scripting options correctly in Query Analyzer, you can generate such...
--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 28, 2007 at 12:55 pm

#755113
RE: To NULL or not to NULL

Ron_Kunce (11/28/2007)
Thanks for the Ammo!:D
Heh... ammo is one thing... learning how to shoot it straight may be another. My advice is to play with the code I gave you......
--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 28, 2007 at 12:50 pm

#755111
RE: problem with float data type

How do you pronounce this, i.e. what comes after trillion
Heh... "Quadrillion"...
Mill = 1
Bill (or BI) = 2
Tri = 3
Quad = 4
etc, etc...
Except in some European countries 😛
--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 28, 2007 at 12:40 pm

#755105

Viewing 15 posts - 53,866 through 53,880 (of 59,089 total)