Re: SQL: Duration Question

Michel Cadot wrote:

> "Charles Hooper" <hooperc2000_at_yahoo.com> a écrit dans le message de news: 1165168282.119663.136140_at_73g2000cwn.googlegroups.com...
>
> <snip>
>
> | Using my example, if the plant manager comes to me and asks, how many
> | of my machines were in use between 6 AM and 7 AM...(<snip>)
>
> Which plant? OP talked about car trips and number of cars on road.
>
> | You are correct that the SQL solution that I provided may not be the
> | one that the OP wanted... (<snip>)
>
> I thought the purpose of this newsgroup was to answer to other's problem.
>
> | Charles Hooper
> | PC Support Specialist
> | K&M Machine-Fabricating, Inc.
>
> Finally, the most important point is that you had fun to post this (I hope so). :)
>
> Regards
> Michel Cadot
>
>

Hopfully the object is not necessarily to give someone complete working code, but to teach them how to work it out for themselves. A quick example or a pointer to how someone else achieved the same result should be all that is necessary as opposed to giving them them a fully working code... After all, isn't that what test databases/boxes are for :) ?

I say this because:
1) if they are in school, you just gave them an answer to their homework 2) if they are working at a company (most likely as a contractor - then they really shouldn't be... resulting in more highly qualified/compensated people getting those jobs.
3) posting code they are/will be using in production could be considered Intellectual Property by their employer - even though given a particular problem, multiple developers would come up with the same answer - but that is another nit.

And before anyone gets too defensive, yes, I have even given out complete working code.

And yes, I do have fun doing this...

-- 
Michael Austin.
Database Consultant