Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,261 through 37,275 (of 59,072 total)

RE: replacing long running cursor

Oh, I see it coming...
--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)

August 17, 2010 at 9:12 am

#1207949
RE: Are the posted questions getting worse?

Roy Ernest (8/17/2010)
I am disappointed. I was trying to get Redgate to sponsor a speaker for our user group. They came up with an idea that Brad could do 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)

August 17, 2010 at 8:29 am

#1207912
RE: Compare Records in Table On coloumns

malaytech2008 (8/16/2010)
What I understand if there is value in each column then return true if not then return false.
select Col1, case when coalesce(COl1,'')='' then false else true as Status...
--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)

August 17, 2010 at 8:22 am

#1207908
RE: Are the posted questions getting worse?

Jack Corbett (8/16/2010)
Jeff Moden (8/16/2010)
Steve Jones - Editor (8/16/2010)
I think the SQL Rally is designed to "try" some things out that don't happen at the Summit, and get more speakers...
--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)

August 17, 2010 at 8:20 am

#1207904
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

Alain Rastoul (8/17/2010)
Hi Jeff,
Here you'll find 3 papers from E.F.Codd ,
A Relational Model of Data for Large Shared Data Banks
http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.98.5286&rep=rep1&type=pdf
Extending the Database Relational Model to Capture More Meaning
http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.84.9469&rep=rep1&type=pdf
RELATIONAL COMPLETENESS OF...
--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)

August 17, 2010 at 8:13 am

#1207894
RE: The Multi-valued Parameters problem in Reporting Services

gary.bland (8/16/2010)
Thanks Jeff for your help! Code working pretty well. Only issue I'm having is getting one parameter to be dependent on the other in a stored proc that populates...
--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)

August 16, 2010 at 8:20 pm

#1207636
RE: MCJ - The Missing Link

dma-669038 (8/16/2010)
Jeff, thank you for teh timely reminder, i will check the site tonight and post some responses. I am not sure how much time i have (much less than...
--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)

August 16, 2010 at 8:13 pm

#1207634
RE: Are the posted questions getting worse?

Steve Jones - Editor (8/16/2010)
I think the SQL Rally is designed to "try" some things out that don't happen at the Summit, and get more speakers there. Personally I'd like...
--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)

August 16, 2010 at 7:58 pm

#1207633
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

mtillman-921105 (8/16/2010)
I was a philosophy major (and a psychology major by the way), so I started reading my book on elemetary logic about empty sets over the weekend. Now here...
--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)

August 16, 2010 at 7:46 pm

#1207631
RE: Are the posted questions getting worse?

Does anyone know what's up with the upcoming SQL Saturday in Minnesota? I see no speakers and no sessions. I've sent emails asking what's up and have gotten...
--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)

August 16, 2010 at 7:02 am

#1207318
RE: Are the posted questions getting worse?

Jack Corbett (8/16/2010)
GilaMonster (8/16/2010)
Jeff Moden (8/14/2010)
I believe I'll submit the whole grass roots gambit next year... Triangular Joins, Tally Table, Cross Tabs, Quirky Update (and other ways to avoid cursors),...
--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)

August 16, 2010 at 6:59 am

#1207316
RE: Turn a Bad Job into a Good Experience

Perfect and well said. I had one job where I quite literally did just about everything for the company from learning how to run a letter folding machine 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)

August 15, 2010 at 10:08 pm

#1207145
RE: Compare Records in Table On coloumns

vrkn82 (8/15/2010)
I have a table with 5 columns. My requirement is if record in each column is equal to one 1 then it has to print true or it should...
--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)

August 15, 2010 at 9:43 pm

#1207142
RE: Compare Records in Table On coloumns

bitbucket-25253 (8/15/2010)
Is this what you require?
CREATE TABLE #T(C1 INT, C2 INT, C3 INT, C4 INT, C5 INT)
INSERT INTO #T
SELECT 1,1,1,1,0 UNION ALL
SELECT 1,1,1,0,1 UNION ALL
SELECT 1,1,0,1,1 UNION ALL
SELECT 1,0,1,1,1 UNION...
--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)

August 15, 2010 at 9:41 pm

#1207141
RE: Alter PK to Cluster

jeff.mason (8/9/2010)
Yep, this is why I NEVER use PRIMARY KEY CLUSTERED even IF I intend to cluster on that column. I am willing to burn the index space and...
--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)

August 15, 2010 at 9:36 pm

#1207140

Viewing 15 posts - 37,261 through 37,275 (of 59,072 total)