Who's On?

	Membership:
	Latest: Lauren Beeker
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5222

	People Online:
	Visitors: 113
	Members: 0
	Total: 113

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Previous Pay Rate Query from PRRATEHIST

2 Replies

0 Subscribed to this topic

52 Subscribed to this forum

Sort:

Author

Messages

vc727

Advanced Member

Posts: 44

7/16/2009 3:25 PM

I am trying to write a query that will tell me the employees pay rate just previous to the current rate. Using the query Builder is this possible? What I have now just Gives me a list of all previous rates. I need to limit it to just the most recent rate.

Any help would be appreciated.

David Williams

Veteran Member

Posts: 1127

New Poster

7/16/2009 3:52 PM

This is a simple solution:
If the previous pay record you're looking for is the last record of your Query then let it loop through all the records and then get the last record's value. If the previous pay record is the first record of your Query then limit it to 1 record and pick up that value.

Gary Davies

New Member

Posts: 0

7/16/2009 4:44 PM

The table has an index that has the Begin Date in reverse order (PRHSET2), so there is no need to spin through all records for a specific employee just read the first one. It is by POS-LEVEL though.