By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
InvoiceNo | StartDateTime | EndDateTime | InvHours | PayDays | WorkedDays | Amount |
---|---|---|---|---|---|---|
1 | 2022-04-28 22:00:00.000 | 2022-04-30 00:00:00.000 | 86.25 | 3 | 5 | 3000.00 |
1 | 2022-05-01 00:00:00.000 | 2022-05-02 12:15:00.000 | 86.25 | 2 | 5 | 3000.00 |
2 | 2022-05-21 12:45:00.000 | 2022-05-24 04:15:00.000 | 63.50 | 4 | 4 | 1000.00 |
3 | 2022-05-21 19:00:00.000 | 2022-05-24 20:45:00.000 | 73.75 | 4 | 4 | 2000.00 |