[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Sql to get employees with no paycheck in last 28 days
- Subject: [sqr-users] Sql to get employees with no paycheck in last 28 days
- From: "veena kolanu" <veena_kolanu@hotmail.com>
- Date: Mon, 5 Jun 2006 22:04:15 +0000
- Delivery-date: Mon, 05 Jun 2006 18:06:34 -0400
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Hi All,
I need a sql in my SQR to get the employees who did had a paycheck in last 4
weeks . That pay_end_dt I need to send it as a termination date.
I am wondering with PS_PAY_CHECK what other table should I use to join them.
Any help would be greatly appreciated.
Thanks
_________________________________________________________________
Search on the go: Try Windows Live(tm) Search for Mobile beta
http://www1.imagine-msn.com/minisites/mobile/Default.aspx?locale=en-us
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users