Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,326 through 44,340 (of 59,101 total)

RE: Need T-SQL to list tables by Parent, Dependent, Descendent, etc

DBASkippack (4/6/2009)
Looking for T-SQLto list my tables in a single database in hierarchical fashion.. with all PARENT tables 1st, followed by all dependants, then all descendants, etc..
eg.
Corporation_Table
Branch_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)

April 7, 2009 at 1:28 am

#973139
RE: Just Walk Away - Blacklisting - and Twits without Twitter

I've seen lots and lots of folks agreeing that some of the greatest abusers on this forum are merely understood or just having a frustrating moment, etc, etc. 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)

April 7, 2009 at 1:25 am

#973137
RE: Calculate To Date

Do an update where the base currency and local currency match on a self join on the table. The row to update would be the max FromDate 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)

April 7, 2009 at 1:04 am

#973132
RE: Just Walk Away - Blacklisting - and Twits without Twitter

I don't believe an "official" blacklist is ever necessary. It doesn't take long to figure out whether or not someone is going to launch on you. You can...
--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)

April 7, 2009 at 1:01 am

#973130
RE: Querying based on a multi-week schedule

Justin,
If that doesn't work out for you, take some time to read the link in my signature line below. A little data goes a long way.
--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)

April 7, 2009 at 12:49 am

#973126
RE: Two different processes have X lock on same resource?

Ummm... it may not be necessary to remove the trigger and there is some great value in having an automated "modified date" or whatever you want to call 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)

April 7, 2009 at 12:45 am

#973125
RE: Reference 'Deleted' table: Dynamic SQL

Wow! That's a whole bunch of RBAR. It may work nicely for serveral updates, but if you ever do a large batch update, it's going to take comparatively...
--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)

April 7, 2009 at 12:40 am

#973122
RE: Timestamp to Datetime

Ah... sorry... bad day and I didn't scroll down. I see that folks have already explained that and you agree.
--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)

April 7, 2009 at 12:24 am

#973119
RE: Timestamp to Datetime

javid.alimohideen (4/6/2009)
Actually I am working on some stored procedures that was written by another developer. In my case, the table has a timestamp column, which gets cast to a datetime...
--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)

April 7, 2009 at 12:22 am

#973118
RE: Manners

Jeff Moden (4/6/2009)
Lynn Pettis (4/5/2009)
Well said, both the editorial and the pod cast. From that, I really think that my blog posts are particularly relevant. For those who...
--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)

April 7, 2009 at 12:03 am

#973114
RE: Manners

RBarryYoung (4/6/2009)
majorbloodnock (4/6/2009)
Well, I expect you'll get a lot more posts to this thread agreeing with your article, albeit (frustratingly) all from people who wouldn't commit that cardinal sin in...
--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)

April 6, 2009 at 11:53 pm

#973112
RE: Manners

Lynn Pettis (4/5/2009)
Well said, both the editorial and the pod cast. From that, I really think that my blog posts are particularly relevant. For those who haven't read...
--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)

April 6, 2009 at 11:42 pm

#973109
RE: Convert multiple rows into columns

Actually, I got a blank page on Flo's link... a working link exists in my signature line below. Do yourself a favor and read the article attached to 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)

April 6, 2009 at 11:31 pm

#973105
RE: Convert multiple rows into columns

vishal.chawla (4/6/2009)
Hi All,
Attached is sample data in excel file. I want to display the colored data in column K,L & M as a single row. Please help me.
Thanks,
Vishal
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)

April 6, 2009 at 11:29 pm

#973104
RE: Idenity column question /issue

jgrubb (4/6/2009)
By definition, identity has gaps, check BOL. If you need sequential id's without gaps, identity is not the way.
Ummm.... you're gonna have to show 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)

April 6, 2009 at 11:17 pm

#973100

Viewing 15 posts - 44,326 through 44,340 (of 59,101 total)