|
|
-
Guenter Initial Review 24 Days ago through Puzzles
This challenge invites you to solve a payroll challenge which requires to calculate the number of hours employee worked
in a week.
The Payroll application for the agency expects the payroll data to be send in CSV file. And the CSV file will be created
|
|
|
-
Guenter Initial Review 2 Months ago through Puzzles
Logic wasn't so bad but the formatting was a real struggle.
|
-
richardh Solved 2 Months ago through Puzzles
Logic wasn't so bad but the formatting was a real struggle.
|
-
Guenter Initial Review 2 Months ago through Puzzles
This challenge invites you to solve a payroll challenge which requires to calculate the number of hours employee worked
in a week.
The Payroll application for the agency expects the payroll data to be send in CSV file. And the CSV file will be created
|
|
|
-
rajeshkumar Liked 6 Months ago through Puzzles
This challenge invites you to solve a payroll challenge which requires to calculate the number of hours employee worked
in a week.
|
-
rajeshkumar Commented 6 Months ago through Puzzles
select
d.RecordType,
Case d.RecordType when 'H' then convert(varchar(5),d.EmpId) else '' end as EmpId ,
Case d.RecordType when 'H' then d.EmpName else '' end as EmpName ,
Case d.RecordType when 'H' then d.WeekStart else '' end
|
|
|
|
|