RE: [sqr-users] fetch value in array

[prashanth reddy <bpreddy78@yahoo.com>]

Thanks for the reply..
I'm getting data from flat file not from table. Thats
the reason I'm using array. What I'm doing is reading
data from flat file, validating emplid in ps_job
record, if emplid doesn't exist in job record, emplid
and max count should show on report.

Thanks,
Prashanth 

--- Bob Stone <bstone@fastenal.com> wrote:

> wow.  convoluted example....nice use of the same 3
> letters all caps for
> 5 different employees...real readable.
> 
> So, I'm going to pretend the first guy is ABC,
> second is LMN, and third
> is XYZ.  Or maybe we got Jones, Smith, and Grady. 
> ...XYZ ZYX YZX YXZ,
> not so good.
> 
> select *
> from YOURTABLE a
> where (a.emplid, a.company, a.count) in 
>        (select b.emplid, b.company, b.count from
> yourtable b
>         where a.emplid = b.emplid and a.company =
> b.company
>           and b.count = ( select max(c.count) from
> YOURTABLE c where
> 
>                       b.emplid = c.emplid and
> b.company = c.company)
> 
> Is there an easier way?  probably.  do you have to
> join 3 times?  maybe
> not.  It's just what I would try.
> 
> 
> -----Original Message-----
> From:
> sqr-users-bounces+bstone=fastenal.com@sqrug.org
>
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]
> On Behalf Of
> prashanth reddy
> Sent: Friday, January 06, 2006 10:43 AM
> To: sqr-users@sqrug.org
> Subject: [sqr-users] fetch value in array
> 
> Hi,
>  
>  I'm using array in sqr and data in array looks like
> this:
>  
> Emplid  Company Count
> XYZ       A      1
> XYZ       A      2
> XYZ       A      3
> YXZ       B      1
> YXZ       B      2
> YXZ       B      3
> ZYX       A      1
> YZX       B      1
> 
> >From this array I'm supposed to get max count for
> each
> emplid, i.e for emplid XYZ have to get line 3 (XYZ  
> A
>  3), for emplid YXZ (YXZ  B 3) and for emplid ZYX
> (ZYX
>  A  1).
> 
> When i compare row value, I'm not able to get the
> correct results.
> Any help or suggestion would be appreciated.
> 
> Thanks,
> Prashanth      
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 



                
__________________________________________ 
Yahoo! DSL – Something to write home about. 
Just $16.99/mo. or less. 
dsl.yahoo.com 


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users