Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things

Re^2: OT?: Partition the tables? (Re: DBIx::Class with two kinds of otherwise identical table types)

by roboticus (Chancellor)
on Sep 15, 2010 at 13:11 UTC ( #860217=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download

  1. or download this
    select -- Key fields
           D.Merchant_ID, 'YYYYMM' as Billing_Period, D.TxnType, ...
    from TxnDtls D
    where D.TxnDate between ... and ...
    group by D.Merchant_ID, D.TxnType, ...