Posted by brukeste on 07/06/07 18:07

A newbie sql writer, so I hope the question makes sense.....

I need to take a users current title and begin stepping through all
their title records that they have had since they have been with the
organization, until I find a break in the dates of service with their
current title.

So a user gets a new title and its active from 6/30/2006 - 7/6/2007,
then their previous title was the same and it was from 5/15/2004 -
6/29/2007, then they either have a break in service OR they have a
different title from 4/1/2003 - 5/14/2004, but then had a stint with
the same as their current title from 6/1/2000 - 3/31/2003.

Ok, now I would only be interested in stepping back until there was a
break in their current title, so I should end up with a number
(represents days in that title) which would include 5/15/2004 -
current.

Any ideas on how to set this up?

Thanks for any help.

Bruce

• Next in forum: Import/Export wizard DateTime problem
• Prev in forum: Help writing an If else statement
• Thread view: HELP!! Please .......

[Reply to this message]