RE: [sqr-users] Comparing/Difference of Two Payroll Summaries

["the dragon" <ceprn@hotmail.com>]

how about a union or an outer join of some kind?

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery. If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul. Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent. Be careful lest you let other people 
spend it for you." -- Carl Sandburg (1878 - 1967)

It is impossible to defeat an ignorant man in argument. -- William G. McAdoo

Religion is regarded by the common people as true, by the wise as false, and 
by the rulers as useful. -- Seneca

"I distrust those people who know so well what God wants them to do because 
I notice it always coincides with their own desires." - Susan B. Anthony




----Original Message Follows----

I have been asked to create a report that compares two consecutive payroll
summaries for a specific pay year, pay id, and payroll run  (all prompts)

The final report would appear like the following:



Payroll1
Payroll2

Pay ID      Earn Code       Total                                      Pay
ID      Earn Code       Total                          Difference



RG            ABC               1000.00                                  RG
ABC                400.00                        600.00

RG            DEF                2000.00                                 RG
DEF                1500.00                      500.00







The issue is, both payrolls could have earn codes that do not exist in the
other payroll.  (Eg: Payroll 1 - GHI , 500.00 but does not exist in Payroll
2)



RG           GHI                     500.00
DOES NOT EXIST IN THIS PAYROLL - CANNOT GET TO PRINT/DIFFERENCE



I have stored the first payroll in a temp table and can select the common
earn codes to the second payroll.  How do I get the earn codes that are
unique to each payroll to be listed as well?  And is there a way to insert a
zero if it does not exists so that it can be subtracted for a difference
value?



I thank you in advance for your assistance.





Jean Myles

  <mailto:jean_myles@fitnyc.edu> jean_myles@fitnyc.edu

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

_________________________________________________________________
Now you can see trouble…before he arrives 
http://newlivehotmail.com/?ocid=TXT_TAGHM_migration_HM_viral_protection_0507


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