Jeff Moden

Forum Replies Created

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

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
RE: ASCII values for GUID

You didn't try it enough. You will get dupes if you use CheckSum on GUID's.
SELECT TOP 1000000
CHECKSUM(NEWID()) AS...
--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:22 pm

#948422
RE: 8 Clicks to What Changed

I hope this was at least a paid entry. Other wise, I'd have to rate it as some seriously overdone SPAM.
--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 8:57 pm

#948418
RE: CURSOR READ SP_WHO2

Have fun... sp_who2 has two SPID columns. Make sure you name them differently in the temp table.
Also, think about NOT using a cursor.
--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 8:46 pm

#948415
RE: Which Data Type to use

Ninja's_RGR'us (2/22/2009)
... and what's the value for a transexual or people with both sexes?
I'm really asking, just wondering if they covered all bases.
Heh... too easy... use the BIT datatype... 0...
--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 8:42 pm

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

sriram (2/22/2009)
I need to display the data in a single row all groups as columns as below.
henry - 10/20/1960 - 2 - 3 - 5
...
--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 8:38 pm

#948413
RE: Are the posted questions getting worse?

I'd say there's bigger fish to fry...
Bold, italics, and underline work just fine but the highlighted item being affected loses focus after any of those. It's frequently desireable 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)

February 22, 2009 at 7:56 pm

#948410

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