Applied Concepts HR/Payroll

how to reduce the size of the transaction log when using SQL Server

Field Level Security - creating a filter using multiple fields.

Resolve an invalid object error by changing ownership of a SQLserver object (table, function, ect).

An example general ledger interface

SQL performance tip - When joining char and varchar columns

create a view which combines employee deduction (EDF) and DDS

Resolving pay/deduction overflow issues on the ETF table

Null values can cause SQLstate 22002

Create a temporary PYT file requesting a DDS (Deduction Detail Summary) report.

Reducing bandwidth demand by limiting metatext to one language