On Tue, 13 Jan 2009 22:18:32 -0800
Erik Jones wrote:
>
> On Jan 11, 2009, at 8:32 AM, Ivan Sergio Borgonovo wrote:
>
> > I'm looking to some book/tutorial/sample code that will teach me
> > how to use SQL to solve some standard problem that goes a bit
> > beyond using group by and aggregates.
>
On Jan 11, 2009, at 8:32 AM, Ivan Sergio Borgonovo wrote:
I'm looking to some book/tutorial/sample code that will teach me how
to use SQL to solve some standard problem that goes a bit beyond
using group by and aggregates.
Something like "SQL problem solving" or "SQL design strategies for
sele
On Sun, 11 Jan 2009 11:19:19 -0700
"Scott Marlowe" wrote:
> On Sun, Jan 11, 2009 at 9:32 AM, Ivan Sergio Borgonovo
> wrote:
> > My current problem is how to manage discounts in SQL, inside
> > transactions. Specifically how to "delete" promotions if they are
> > overlapping, considering I have
On Sun, Jan 11, 2009 at 9:32 AM, Ivan Sergio Borgonovo
wrote:
>
> My current problem is how to manage discounts in SQL, inside
> transactions. Specifically how to "delete" promotions if they are
> overlapping, considering I have to display discounted prices on a 1M
> article DB and I may have hund
I'm looking to some book/tutorial/sample code that will teach me how
to use SQL to solve some standard problem that goes a bit beyond
using group by and aggregates.
Something like "SQL problem solving" or "SQL design strategies for
selected problems".
My current problem is how to manage discounts