mattd
Last Activity: Feb 7 '12, 02:53 PM
Joined: Feb 1 '12
Location:
-
Rabbit, I found a SQL guys at the office. He helped me build the Cursor query which worked. Thanks for pointing me in the right direction. -
Rabbit thanks for the info but I have no idea how to set this up. I'm pretty new at SQL, would you be able to show me how to set something like this up with Cursor?Leave a comment:
-
Thanks, I'll check it out.Leave a comment:
-
Sorry the data didn't upload visually as I was hoping for.
What I'm trying to do is capture the first and last date each time the employee changes location.
So i'm hoping to get 3 lines out of the data.
1) 1/1/2005 - 5/31/2007 date range for location = BRD.
2) 6/1/2007 - 9/30/2010 date range for location = RMC.
3) 10/1/2010 - null (current) date range for location = BRD.Leave a comment:
-
Combine multiple records into a date time line.
I have a data file that contains multiple records for each employee. I'm trying to build a view of the table that would show me a combined date range for per location. The example below are the fields from the file that i'm trying to combine.
Table Exp:
Employee # Begin Date End Date Location
1 1/1/2005 10/1/2005 BRD
1 10/2/2005 5/31/2007 BRD
1 6/1/2007 3/31/2009...
No activity results to display
Leave a comment: