Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
11-21-2005, 06:43 PM #1
- Join Date
- Apr 2003
- Thanked 13 Times in 13 Posts
sum profits for all dates including empty ones
i am trying to produce a query which gets something like thisCode:
01-12-04 £4 01-12-04 £3 03-12-04 £9Code:
01-12-04 £7 02-12-04 £0 03-12-04 £9Code:
01-12-04 £7 03-12-04 £9
*currently i am getting the year, month and day components of a date, casting them to varchars and sticking a '-' between them.. if anyone knows a better way of grouping these (preferably into some displayable format too) please tell me!
does anyone have any idea how i would go about achieving what i need? would i need to find the earliest date and loop dateadd until it gets to getdate(), running a query for each date or what?