Simple View

[KarlNixon]

Hi, am new to SQL and am seeking some support in writing a query.

I have a table of timesheet records (multiple records per day, per employee) which I am looking to summarise into a view by Work Type.

The table has the following fields

Date

Employee

Work Type (Ordinary, 1.5x and Leave)

Hours

Which I am looking to present as a view with the following fields

Date

Employee

Hours Type Ordinary

Hours Type 1.5x

Hours Type Leave

Any help with the syntax would be greatly appreciated!

[#2 · Accepted solution]

Hello @KarlNixon

You can use SQL Pivot query structure for your requirement

Please refer to tutorial for more samples

Here is the SQL query that will help you

select
  *
from
(
  select
    Date, Employee, WorkType, Hours
  from EmployeeWork
) DataTable
PIVOT
(
  SUM(Hours)
  FOR WorkType
  IN (
    [Ordinary],[Leave],[1.5x]
  )
) PivotTable