Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UserID | DateWorked | HoursWorked | AmountPaid
- ----------------------------------------------
- 1 | 11/01/17 | 5.00 | 20.00
- 1 | 11/02/17 | 3.00 | 5.00
- 2 | 11/15/17 | 10.00 | 50.00
- declare @tablemonth table(...)
- declare @tableytd table(...)
- insert into @tablemonth execure RawDataSP @BeginDate = @BeginDate, @EndDate = @EndDate
- insert into @tableytd execure RawDataSP @BeginDate = @YTDBeginDate, @EndDate = @YTDEndDate
- columns... | TotalHoursMonth | TotalPaidMonth | TotalHoursYTD | TotalPaidYTD
- ---------------------------------------------------------------------
- |hours counts | Amount paid |hours counts | Amount paid |
- |between 11/01/17 | between 11/01/17|between 01/01/17| between 01/01/17 |
- |and 11/30/17 | and 11/30/17 |and 10/30/17 | and 10/30/17 |
Add Comment
Please, Sign In to add comment