Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help needed with the report

Status
Not open for further replies.

reacha

Programmer
Jun 9, 2010
83
US
I have a report in which first i have grouped by supervisorname,username,auditdate,pkgid

Now i need to get only 2 pkgid's for each username they should be on different dates

For Ex:

Supervisor Username Auditstamp pkgid
---------- --------- ---------- ------
TOM Peter 11/30/2010 10000
11/31/2010 10001
12/05/2010 10005

Adam james 12/01/2010 10010
10012
12/05/2010 10014

Output should be
----------------

Supervisor Username Auditstamp pkgid
---------- --------- ---------- ------
TOM Peter 11/30/2010 10000
11/31/2010 10001

Adam james 12/01/2010 10010
12/05/2010 10014


Thanks,
reacha
 
Hi,
What determines which 2 pkgid entries you want to show?


[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Any two pkgid's for any dates so that they want to quality audit process on that
 
i want the 2 pkgid's which are random with the corresponding dates





Please help me out!!



Thanks,
reacha
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top