Viewing 5 posts - 1 through 5 (of 5 total)
Eddie Wuerch (11/12/2009)
November 13, 2009 at 3:18 am
No problem, It was the Calendar idea that was key. As ever I think you learn more by having to overcome issues yourself rather than having things put on...
July 10, 2009 at 2:28 am
I thought about this some more overnight and realised I had used the wrong GROUP BY Clause yesterday.
Correcting this the following:
SELECT b.[Date],p.Price
FROM (
SELECT c.[Date] AS [Date], a.Item AS...
July 10, 2009 at 1:52 am
Thanks for this. I think I understand what you are trying to do: generate a Date sequence from the Calendar table, join it to the priceTimes to generate our...
July 9, 2009 at 1:06 pm
David Burrows (7/9/2009)
July 9, 2009 at 8:01 am
Viewing 5 posts - 1 through 5 (of 5 total)