Share
ReportI'm looking for a script that gives me the gross pay by month and I can total them by year
*This post is locked for comments
You’re offline. This is a read only version of the page.
I'm looking for a script that gives me the gross pay by month and I can total them by year
*This post is locked for comments
Hello Larry,
I used below Sql query to get Yearly Gross Salary. Modify it as per your requirement.
SELECT TOP (100) PERCENT YEAR1,MONTH(CHEKDATE) CheckMonth, EMPLOYID, SUM(NTWPYRN) AS NetWages, SUM(GRWGPRN) AS GrossWg, SUM(FICAMWPR) AS MED, SUM(FCASWPR) AS SS, SUM(FDWDGPRN) AS Federal
FROM dbo.UPR30100
where Year1='2013'
GROUP BY YEAR1, EMPLOYID,MONTH(CHEKDATE)
ORDER BY YEAR1, EMPLOYID,MONTH(CHEKDATE)
Thanks
Sandip
All responses (
Answers (
18,297
