Lorjust Bayne
asked on
How can I expand a table row for each day within a range using VB.net 2012 and/or SQL?
This is probably a very basic issue, but I'm a noobie. I don't really know how much detail to give but here we go.
I want to take Table A and create Table B to show one row for each date within the Checkin/CheckOut date range in Table A.
Table A
CheckIn CheckOut Name
8/1/2014 8/5/2014 Watson, JB
Table B
CheckIn CheckOut Name DateValue
8/1/2014 8/5/2014 Watson, JB 8/1/2014
8/1/2014 8/5/2014 Watson, JB 8/2/2014
8/1/2014 8/5/2014 Watson, JB 8/3/2014
8/1/2014 8/5/2014 Watson, JB 8/4/2014
8/1/2014 8/5/2014 Watson, JB 8/5/2014
I want to take Table A and create Table B to show one row for each date within the Checkin/CheckOut date range in Table A.
Table A
CheckIn CheckOut Name
8/1/2014 8/5/2014 Watson, JB
Table B
CheckIn CheckOut Name DateValue
8/1/2014 8/5/2014 Watson, JB 8/1/2014
8/1/2014 8/5/2014 Watson, JB 8/2/2014
8/1/2014 8/5/2014 Watson, JB 8/3/2014
8/1/2014 8/5/2014 Watson, JB 8/4/2014
8/1/2014 8/5/2014 Watson, JB 8/5/2014
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.