Re: SQL Work Needed at the City of Wilsonville

On Jul 26, 2011, at 10:26 AM, gabrielle wrote:

>> On Jul 21, 2011, at 10:10 PM, Lindsey Smith wrote:
>
>>> In their words: "Take 2 tables with the same data in different columns
>>> (owners, addresses, etc) massage the data in SQL then drop it into a
>>> fresh table that we use to update our production database."
>
> Tom commented:
>> Sounds more like a Perl job to me.
>
> Yeah... and deceptively simple. I might call them and find out some
> more details.
>
> Anybody interested in a group PDXPUG hackfest/fundraiser/helping out
> the local gov, or is that a totally insane idea?
>
> gabrielle
>

I was thinking a join or union deal and a select into. I could be grossly underestimating how complex their data is.

I like the idea of a hackfest for this. It would be really interesting to see how everyone goes about this.

Brent D.