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
Havasvölgyi Ottó schrieb:
> Hi,
>
> Let's assume I have a table (called tbl) with a column 'name' and an index on
> it.
> How to optimally find records whose name column begins with - say - "Pre"?
> I know it can be done with LIKE (WHERE name LIKE 'Pre%'), but will this use
> the
> index mentio
Hi,
Let's assume I have a table (called tbl) with a column 'name' and an index
on it.
How to optimally find records whose name column begins with - say - "Pre"?
I know it can be done with LIKE (WHERE name LIKE 'Pre%'), but will this use
the index mentioned above to optimize the search?
Thanks,
Ot
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
