Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,591 through 40,605 (of 59,072 total)

RE: Change 0 to a null in a query

Lookup NULLIF...
--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 18, 2009 at 4:43 pm

#1094372
RE: Are the posted questions getting worse?

Steve Jones - Editor (12/18/2009)
We went to Android, isn't everyone?
Patience, my padawans. I'm looking to write things up, but honestly I'm not 100% sure what the final was since 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)

December 18, 2009 at 4:38 pm

#1094370
RE: How can I find duplicate Entries in a table?

atwite (12/18/2009)
I may not understand what you mean but, I do not think that will work in the database I work on. We have one table that has thousands...
--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 18, 2009 at 4:28 pm

#1094369
RE: How can I find duplicate Entries in a table?

For something like that, why not just put a unique index on the meter column and use the thrown error as an alert?
--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 18, 2009 at 11:59 am

#1094237
RE: Scalar function to generate report

Too bad... I wanted to actually see someone create a scalar function to gen a whole report. 😛 Maybe that's why the OP took it down. :hehe:
--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 18, 2009 at 11:57 am

#1094234
RE: Data to be split in different column

Despite the lack of a result sample, it looks pretty clear that the split should occur on any characters (including Carriage Returns and LineFeeds) not in the range of [A-Z0-9]...
--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 18, 2009 at 11:35 am

#1094221
RE: Scalar function to generate report

PSGS (12/17/2009)
post deleted
Heh... well that's bloody rude. 😉
--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 18, 2009 at 11:26 am

#1094215
RE: cursors and order by

Lynn Pettis (12/15/2009)
Magy (12/15/2009)
But it didn't order the data according to my ORDER BY clause...that's why I'm confused.
When I run the cursor, and then check the table, 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)

December 18, 2009 at 11:25 am

#1094214
RE: Are the posted questions getting worse?

jcrawf02 (12/18/2009)
By the way Jeff, very nice review of Grant's book.
Thanks... Grant is an easy read and I learned several new tricks as a "bonus".
--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 18, 2009 at 11:19 am

#1094211
RE: Dissecting SQL Server Execution Plans

CirquedeSQLeil (12/18/2009)
Nice review, thanks for the info Jeff.
You bet, Jason. Thanks for the feedback. Grant is an easy read... I read his book in just two nights. ...
--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 18, 2009 at 11:16 am

#1094209
RE: Where's My Additional Free Space ?

homebrew01 (12/18/2009)
EdVassie (12/18/2009)
Changing one of the existing indexes to clustered may (or may not) cause maintenance problems in the future if you apply a service pack from your app supplier....
--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 18, 2009 at 11:11 am

#1094205
RE: Where's My Additional Free Space ?

Agreed... I forget what they call the equivalent of a Clustered Index in Oracle, but a lot of developers don't know about it and there's usually no need for 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)

December 18, 2009 at 6:13 am

#1093983
RE: Dissecting SQL Server Execution Plans

Robert Frasca (12/17/2009)
I have the book on my desk. I also have had the pleasure of speaking with Grant and hearing him speak at the New England SQL Server...
--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 17, 2009 at 7:51 pm

#1093850
RE: How to do this...?

krypto69 (12/15/2009)
I don't really have access to the individual transactions. I know that sounds odd, but this is a core system for us, they do not want it tampered with...
--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 17, 2009 at 7:16 pm

#1093846
RE: Convert String to a Table using CTE

dberra-831997 (12/17/2009)
I used this function with data pasted from a column or data from excel. Short of some additional error checking it is a handy techique:
declare @str varchar(max)
select @str =
'line1
line2
line3
line4'...
--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 17, 2009 at 7:07 pm

#1093842

Viewing 15 posts - 40,591 through 40,605 (of 59,072 total)