In article <12s4u31plmj6csf7fgbji575cq3b3nee9t@[EMAIL PROTECTED]
>,
Robert <no@[EMAIL PROTECTED]
> wrote:
>On Thu, 20 Mar 2008 09:17:47 +0000 (UTC), docdwarf@[EMAIL PROTECTED]
() wrote:
>
>>In article <qtt3u35t5f16ej8v6loh3pfnf3v5d3f392@[EMAIL PROTECTED]
>,
>>Robert <no@[EMAIL PROTECTED]
> wrote:
>>>On Thu, 20 Mar 2008 01:01:37 +0000 (UTC), docdwarf@[EMAIL PROTECTED]
() wrote:
>>>
>>>>In article <s6f3u3dlalc0i5g0jq4gtilg43kke5nm0o@[EMAIL PROTECTED]
>,
>>>>Robert <no@[EMAIL PROTECTED]
> wrote:
>>>>>On Wed, 19 Mar 2008 12:35:35 +0000 (UTC), docdwarf@[EMAIL PROTECTED]
()
wrote:
>>>>
>>>>[snip]
>>>>
>>>>>>(note - this is a shop that runs on files, not on a database)
>>>>
>>>>[snip]
>>>>
>>>>>select name, separation_date, dirty_money
>>>>> from employees emp,
>>>>> (select employee, sum(amount_paid) as dirty_money
>>>>> from payroll_detail pd
>>>>> where debit_account = '6969'
>>>>> and payment_date between to_date(20051001) and
sysdate
>>>>> group by employee
>>>>> having dirty_money > 0) crook
>>>>> where crook.employee = emp.employee
>>>>> and emp.separation_date is not null
>>>>> and emp.division in
>>>>> (select division from divisions where division_name like
>>>'Midwest%')
>>>>> and emp.start_date >
>>>>> (select min(start_date) from employees where name like
'%Dwarf%')
>>>>>
>>>>>-- Query preparation time: 5 minutes
>>>>
>>>>Amount of time spent carefully reading what preceded query preparation
>>>>time: not enough to catch a clear and unambiguous note.
>>>
>>>All ya gotta do is write a schema defining the flat files and define it
>>>as an ODBC data
>>>source. If there are multiple files, concatenate them with copy
command,
>>>in JCL, or write
>>>a view containing a UNION.
>>
>>That's just the kind of response I'd expect from a Manager, Mr Wagner...
>>are you considering a career-change?
>
>My parents were married.
Punchline #862: Your mother's husband is buried in Penobscot, Main. Your
father just landed a seven-pound trout.
>
>>(actually... I found out Just The Other Day that they *do* have a
'Reports
>>Group' just for situations like this and the Reports Group does...
>>something-or-other with an Oracle loading of the files I interrogate
with
>>COBOL and DFSort.
>>
>>My tech lead said that the users have expressed a preference for putting
>>these requests into my hands... because I seem to Get More Done. Go
>>figure, eh?)
>
>Users SHOULD ask for a general purpose query screen that THEY can run
>without running the
>bureaucratic gauntlet every time.
In my experience, Mr Wagner, people don't always do what they 'SHOULD'
(caps original).
>If I were working there, I'd sell them
>the idea, then
>write it for them.
When I started on this contract there was a fellow who expressed a similar
desire; he was told it would be better to address this after the main
project went live.
After Go Live a bunch of consultant/contractors/hired guns were given
their walking-papers... he was one of them.
DD
|
