He friends,
I need your hel to find the availably quantity in between date selection .
Let suppose I ahve 10 product A In stock .
My database structure will be like this .
StockID ProductID OrderID ReorderQuantity DateOfBooking DateOfReturning CreatedDate ModifiedDate IsActive
1 1 1 5 2013-01-01 02:21:16.910 2013-01-04 02:21:16.910 2012-12-31 02:21:16.910 2012-12-31 02:21:16.910 0
2 1 2 5 2013-01-03 02:21:54.857 2013-01-07 02:21:54.857 2012-12-31 02:21:54.857 2012-12-31 02:21:54.857 0
Now What I want is if customer want the product A on Rent for between tow selected date with quantity I want to find out Available quantity between the selected date and quantity.
So please help me to find out the solution.
It is just like to find the seat Availablity in train as we provide product on rent.
Thank in Advance
Go to the complete details ...