Milestones

Question

Milestones

rizwan.inam

SSC Journeyman

Points: 86
More actions
November 5, 2009 at 1:17 am

#213531

How to Manage sub activities StartDate and EndDate

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Silverfox SSC-Insane Points: 23150 More actions · Answer 1

No idea what you mean, can you give more details.

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

Jeff Moden SSC Guru Points: 1004378 More actions · Answer 2

rizwan.inam (11/5/2009)
How to Manage sub activities StartDate and EndDate

Google "Slowly changing dimension" and see the article on WikiPedia for how to manage 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)

rizwan.inam SSC Journeyman Points: 86 More actions · Answer 3

Like MS PROJECT Parent Activity Start and End Date depend on Child Activities Start and End Date.

Jeff Moden SSC Guru Points: 1004378 More actions · Answer 4

rizwan.inam (11/5/2009)
Like MS PROJECT Parent Activity Start and End Date depend on Child Activities Start and End Date.

Can you be just a bit more descriptive? Are you saying that you want to list things in Hierarchical order or what? Please see the first link in my signature line below for how to provide some readily consumable data to test 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)