Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Fine but not for contiguous date ranges
Message
From
31/10/2006 10:10:55
 
 
To
31/10/2006 09:09:44
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01165450
Message ID:
01165773
Views:
18
>>>>Ne'er mind! I've sorted this. I do 2 passes - one for the prev period and one for the curr period, i.e. each with only half of the CASE statement.
>>>
>>>When you talk to yourself, at least you know you can't complain about the company. And you got your (almost) undivided attention.
>>
>>Like I've always said, you meet a better class of person.
>>
>>Well I had to talk to myself as no-one was offering any ideas.
>
>You were just emulating your own Auntie Emma.

That principle (pal?) is the truest truism of coding. How many times has one walked an interested party a guided tour through one's code, when there's a problem, and, in so doing, found the bug. :-)
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform