SQL to retrieve fields for BI Report

Summary:

Hi All Please share SQL query to fetch below details for generate bursting report.

Thankyou,

Ram

Content (required):

SQL to retrieve Employee Number, Employee Name, Effective Date, Job, Location, Dept, Manager, Old Payroll Name, New Payroll Name, Old Payroll Frequency, New Payroll Frequency

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):