Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,031 through 45,045 (of 59,101 total)

RE: Evaluating String Arithmetic Expressions in SQL Server 2005

Michael Earl (2/23/2009)
Jeff - I think you have an error in your outer REPLACE - it should be a / rather than a *.
You are going to have trouble 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)

February 23, 2009 at 8:24 am

#948629
RE: Update previous close price.

I haven't tested it, but Jack normally writes code that works especially since you posted some test data. My concern is that of performance... this does have to run...
--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)

February 23, 2009 at 8:11 am

#948617
RE: problem in generating the required data

The problem is, which BillingID do you want to use for which MemberEventID.
I'm not sure this problem has a solution for the given data.
--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)

February 23, 2009 at 8:03 am

#948610
RE: Update previous close price.

Yes, it is possible but not easily in a single query especially since you probably have the clustered index on the IDENTITY column (good idea for this type of table)....
--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)

February 23, 2009 at 7:55 am

#948603
RE: Converting to Month-Year Format

First thing I do when I learn any new language is to lookup and read about all the functions available. Lookup CONVERT in Books Online (comes free with SQL...
--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)

February 23, 2009 at 7:11 am

#948562
RE: Query Slower when using smaller date range?

Jack Corbett (2/23/2009)
Edit: moved the final closing parenthesis so that it was not a smiley.
That's definitely on my wish list to Steve to fix. In the meantime, I run...
--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)

February 23, 2009 at 7:07 am

#948557
RE: Evaluating String Arithmetic Expressions in SQL Server 2005

Ya gotta be sneaky...
Drop table #mYhead
CREATE TABLE #MyHead
(
RowNum INT IDENTITY(1,1),
...
--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)

February 23, 2009 at 6:52 am

#948545
RE: defrag tool on MDF and LDF files?

jmoss111 (2/23/2009)
I run contig.exe online, and have had no issues
Regards,
Jim
What is "contig.exe" and does it come with Windows or SQL Server for free?
Also, on a crowded disk, will it move...
--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)

February 23, 2009 at 6:48 am

#948542
RE: Ltrim rtrim no working with UPDATE

That's why Andrew said to check and make sure that what look like spaces, actually are... it's a data problem... the trim functions will not remove all white-space characters... just...
--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)

February 23, 2009 at 6:38 am

#948537
RE: Are the posted questions getting worse?

Ninja's_RGR'us (2/23/2009)
Jeff Moden (2/22/2009)
Oh yeah... I almost forgot... we need a way to download all PM's. There's a 100 I wanna keep. 😉
Why not bump the limit to 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)

February 23, 2009 at 6:13 am

#948523
RE: CURSOR READ SP_WHO2

Sorry, didn't mean to leave you hanging...
Here's one way to read the result set of SP_WHO2 into a temp table. What ever you're doing (it would be nice 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)

February 23, 2009 at 6:08 am

#948520
RE: Are the posted questions getting worse?

Oh yeah... I almost forgot... we need a way to download all PM's. There's a 100 I wanna keep. 😉
--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)

February 22, 2009 at 10:44 pm

#948430
RE: Which Data Type to use

Steve Jones - Editor (2/22/2009)
I don't like bits for things like this and I'd go with ISO. Who knows what crazy categories someone might assign, so leave room for growth...
--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)

February 22, 2009 at 9:48 pm

#948425
RE: Display column of different rows as column of a single row

To be more clear...
If it were a cross tab of aggregated numbers, it could save a huge amount on how much you stuff into the pipe. But, even then,...
--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)

February 22, 2009 at 9:45 pm

#948424
RE: Display column of different rows as column of a single row

Bob Hovious (2/22/2009)
Why ask why? 😉
I get these kinds of requests from our reports group. Some people want to squeeze as much information as they can onto 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)

February 22, 2009 at 9:28 pm

#948423

Viewing 15 posts - 45,031 through 45,045 (of 59,101 total)