Jeff Moden

Forum Replies Created

Viewing 15 posts - 57,136 through 57,150 (of 59,101 total)

RE: ltrim(rtrim(colvalue)) doesnt work while inserting/displaying records into a table from another table...

I agree with SQLBill on many of the points he made. You might just be viewing things differently or incorrectly... post the CREATE TABLE statement for the target table... if...
--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)

December 22, 2006 at 9:34 am

#679760
RE: SQL SERVER Query Analyser 2000 - FLOAT column shows 33.87 value as 33.86999999

I agree with Vladan... spend some time with Books Online...
Although I think MONEY is the correct datatype to use here, using DECIMAL(10,2) won't kill you if you don't mind...
--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)

December 22, 2006 at 9:20 am

#679755
RE: Retrieve data from temporary table with dynamic name?

I think you're making a big design mistake but it's your funeral...
CREATE
PROCEDURE dbo
--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)

December 21, 2006 at 11:35 pm

#679648
RE: Table Performance

Rajesh,
What feeds the proc you just posted? A GUI, a batch job, another proc? or ???
--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)

December 21, 2006 at 11:22 pm

#679646
RE: Table Performance

While I'm looking at this, gotta ask... did you run the SELECT through the Index Tuning Wizard, yet?
--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)

December 21, 2006 at 11:09 pm

#679643
RE: Get file size

Rajesh!
Did you try it or 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)

December 21, 2006 at 10:51 pm

#679641
RE: TinyInt, SmallInt, Int and BigInt

David,
Just to add to what Andy has already said... your article has provoked some pretty good conversation. Don't ever let the occasional nasty comment deter you from writing these types...
--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)

December 21, 2006 at 10:43 pm

#679640
RE: Table Performance

The only reason why you think there is no performance problem on the UPDATE is because it is only updating 1 row at a time and you are comparing it's...
--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)

December 21, 2006 at 10:28 pm

#679639
RE: Urgent Expert level Help on a query

... and why on Earth are you using a cursor? Do this set based...

--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)

December 21, 2006 at 10:13 pm

#679636
RE: Urgent Expert level Help on a query

The column is called "Month_of_file".... why are you looking for just one day? Try this as your WHERE clause to return rows for the month of September 2006....
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)

December 21, 2006 at 10:07 pm

#679635
RE: ltrim(rtrim(colvalue)) doesnt work while inserting/displaying records into a table from another table...

A slightly easier to see method... if "Value1" is a column name....
SELECT REPLACE(Value1,CHAR(9),'') AS Value1
FROM your table
"CHAR(9)" is the TAB character.
HOWEVER!!!! If you have such characters...
--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)

December 21, 2006 at 9:59 pm

#679634
RE: SQL SERVER Query Analyser 2000 - FLOAT column shows 33.87 value as 33.86999999

Serqiy is correct... the MONEY datatype is the way to go here... the MONEY datatype takes the same as a datetime... 8 bytes and gives you 4 decimal places to...
--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)

December 21, 2006 at 9:54 pm

#679633
RE: Retrieve data from temporary table with dynamic name?

Almost correct... You don't need to do a different owner prefix... temp tables have scope by session only. You do not need to use a dynamic table name if 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)

December 21, 2006 at 9:43 pm

#679630
RE: any tool or method available to import this file to table.

Why not post them here so we can all learn something?
--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)

December 21, 2006 at 2:54 pm

#679573
RE: Computed Columns

Martin,
If the Total_1 column is any of the integer datatypes and (so it appears) that the Total_1 column is a total number of minutes worked, you may be in for 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)

December 21, 2006 at 2:35 pm

#679565

Viewing 15 posts - 57,136 through 57,150 (of 59,101 total)