How do I use a startdate & enddate field to create multiple records with incrementing date?
Posted on 2008-10-06
I have created a leave application list in sharepoint with an OperatorName, LeaveStartDate, LeaveEndDate and LeaveApplicationDate. I can extract the data I need from sharepoint and end up with a table in SQL Server 2005 like this:
OperatorName LeaveStartDate LeaveEndDate LeaveApplicationDate
Bob 04-Sep-2008 08-Sep-2008 01-Aug-2008
Fred 05-Sep-2008 05-Sep-2008 01-Jun-2008
Joe 07-Sep-2008 09-Sep-2008 16-Aug-2008
I would like to create a table / view that looks like the following, putting the operators in a single field in the order of the leave application date:
05-Sep-2008 Fred, Bob
07-Sep-2008 Bob, Joe
08-Sep-2008 Bob, Joe
The reason I would like the data in this format is that I want to import it into Excel and perform a vlookup on this table.
Thank you for your time.