No such thing as a small change | |
PerlMonks |
Re: Re: Re:x2 Escaping parentheses in regexps (select distinct is a Red Flag)by Tanalis (Curate) |
on Jan 22, 2003 at 19:07 UTC ( [id://229108]=note: print w/replies, xml ) | Need Help?? |
A SELECT DISTINCT isn't possible in this case, though it's a good idea and something we'd thought of.
The DB we're using is global, and belongs to a different group to the one I work in. It has data stored how they need it for their reporting, not how we need it for ours - hence the need to concatenate data when duplicates occur on one (of our) orderids. It's for a fairly specific use, actually: we're trying to have their systems interface with ours for reconciliation purposes, and it's proving to be a lot less simple than I originally thought :) It'd make a lot more sense if the company had data storage standards, as we're all essentially in different areas of the the same business, but that'd make life easy ... *grin* -- Foxcub
In Section
Seekers of Perl Wisdom
|
|