[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] Sql to get employees with no paycheck in last 28 days
- Subject: Re: [sqr-users] Sql to get employees with no paycheck in last 28 days
- From: "jiju vengal" <jijucvengal@gmail.com>
- Date: Tue, 6 Jun 2006 21:51:57 +0530
- Delivery-date: Tue, 06 Jun 2006 12:23:59 -0400
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;b=q6NOYJkBX9s1I0mVHc3QGrotjgEdWiEzm7nhs9oW84RHtqfC2ASy5Eb5HyKNgtxs7bK4axz+mWla3JvNN5cMtJDWTdKcYpf78/Vfihe2ZktfLHM92nOci8q9rYog6J8W+Aq56pfgN3ghEn1HLfB3ciieyCvBqVt15BandboKq90=
- In-reply-to: <BAY101-W1061F977717F7646979221FB940@phx.gbl>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- References: <BAY101-W1061F977717F7646979221FB940@phx.gbl>
Hi Veena,
I believe if your purpose is to check whether a check was issued or not, you
may only have to refer the pay_check table and do a check_dt between. And
yes ofcourse you may want to join JOB to fetch only the relevant
EMPL_STATUS.
-Jiju.
On 6/6/06, veena kolanu <veena_kolanu@hotmail.com> wrote:
>
> 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
>
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users