Viewing 4 posts - 1 through 4 (of 4 total)
Luis Cazares (2/20/2014)
Here's the final solution with the gaps problem solved (Hoping you won't have dates that go over 25 years in the future).(...)
Thank you for your solution and sorry...
February 24, 2014 at 5:32 am
Eugene Elutin (2/20/2014)
We can see in your expected results only...
Don't you have some other table which...
February 20, 2014 at 1:11 pm
Luis Cazares (2/20/2014)
How do you define that it goes from 10 to 15 and then back to 5?
Result stock for partucular date is calculated:
select ISNULL(SUM(stock), 0) from dates WITH (NOLOCK)...
February 20, 2014 at 9:47 am
I don't know if I understand your question correctly, but period in my case is time between FROM_DATE and TO_DATE.
I'm not interested in time difference, just dates. However period can...
February 20, 2014 at 7:56 am
Viewing 4 posts - 1 through 4 (of 4 total)