Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
SELECT UPR00100.LASTNAME, UPR00100.FRSTNAME, UPR00100.SOCSCNUM, SUM(UPR00500.DEDNPRCT_1) AS [401K] FROM UPR00500 INNER JOIN UPR00100 ON UPR00500.EMPLOYID = UPR00100.EMPLOYID WHERE (UPR00100.INACTIVE = 0) AND (UPR00500.INACTIVE = 0) AND (UPR00500.DEDUCTON LIKE '401K%') GROUP BY UPR00100.LASTNAME, UPR00100.FRSTNAME, UPR00100.SOCSCNUM
|How to extract a "coded date" from a string field?||4||51|
|SQL Server 2012 express||24||34|
|Selection from table2 where criteria for table1||10||31|
|Error when saving to sql table a '/'||5||25|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!