Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,711 through 37,725 (of 59,072 total)

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

Awesome feedback. As a side bar... Heh... no appologies for wanting to for wanting to form an opinion on some things on my own (which I still have 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)

July 13, 2010 at 4:38 pm

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

Almost forgot... thanks for the warning on Rule 6, Tom. I haven't seen anyone address the "problem" you're talking about but I suspect that the word "View" in that...
--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)

July 13, 2010 at 12:34 am

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

Thanks, Tom. Yep... this is one of the many versions of seen. Obviously I was hoping for the real thing but if someone like you, Barry Young, 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)

July 13, 2010 at 12:32 am

#1191800
RE: Are the posted questions getting worse?

CirquedeSQLeil (7/11/2010)
Steve Jones - Editor (7/11/2010)
I added my thoughts to the thread. I think the guy/gal was humble enough, admitting he was in over his head there. I am hoping,...
--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)

July 12, 2010 at 2:03 am

#1191342
RE: Are the posted questions getting worse?

Jack Corbett (7/11/2010)
Jeff Moden (7/9/2010)
Ah.... just found another email from Elena... the Tally Table session in "Approved" and the Hierarchy session has been labeled as an "Alternate" in case someone...
--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)

July 12, 2010 at 1:55 am

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

Jim McLeod (7/12/2010)
I asked a friend, who is a CS Ph.D student, if he could dig it up. Unfortunately, no luck. His reply:
It's referenced in the ACM digital library:
http://portal.acm.org/citation.cfm?id=655234
But...
--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)

July 12, 2010 at 1:27 am

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

David Portas (7/12/2010)
It is included in the disc version of the ACM SIGMOD anthology, although I don't think the text is available online.
http://dblp.uni-trier.de/db/conf/icde/Codd86.html
That's the rebublished version of the Computerworld article.
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)

July 12, 2010 at 1:25 am

#1191336
RE: The Utilty

Absolutely wonderful editorial, Steve. Unfortunately, I've found that many IT shops ARE exactly the same as some water and electric companies... you can't actually get to anything with 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)

July 11, 2010 at 11:35 pm

#1191313
RE: Assigning some week numbers

lmu92 (7/11/2010)
Ok, here's the code including test data setup.
Please note that there a few people around (including myself, usually) who expect sample data in a ready to use format (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)

July 11, 2010 at 11:24 pm

#1191312
RE: Assigning some week numbers

m.dunster (7/11/2010)
Hi,
I've managed to successfully adapt this to solve my problem. Now I'll have to spend some time trying to understand exactly what is happening.
Point noted about the data provision.
Many...
--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)

July 11, 2010 at 11:23 pm

#1191310
RE: create a function

rvasanth (7/10/2010)
You have to use cursor
Use the sysobjects table to get the list of table.
Then loop through one by one and check for the condition you want
Anyone can say such...
--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)

July 11, 2010 at 3:19 pm

#1191271
RE: return calculated null as 0

lmu92 (7/11/2010)
A few more things to notice:
I'm not sure how the functions to_char and to_date are written, but I guess both can be replaced by the built-in function CONVERT(). 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)

July 11, 2010 at 3:16 pm

#1191270
RE: Today as a Serial Date

lmu92 (9/6/2009)
Would the following give the expected result?
SELECT DATEDIFF(dd,0,GETDATE())
However, it's interesting that EXCEL returns 40062 for today (2009-09-06), but SQL Server returns 40060...
The "0" date for for the default date...
--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)

July 11, 2010 at 3:07 pm

#1191269
RE: Assigning some week numbers

m.dunster (7/11/2010)
Hi,
I've managed to successfully adapt this to solve my problem. Now I'll have to spend some time trying to understand exactly what is happening.
Point noted about the data provision.
Many...
--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)

July 11, 2010 at 2:58 pm

#1191268
RE: HI SQL DBA'S

I agree with Lutz. The subject is much to large to put into a simple post. The only way for you to become wise and expert on 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)

July 11, 2010 at 2:54 pm

#1191267

Viewing 15 posts - 37,711 through 37,725 (of 59,072 total)