Guest User

Untitled

a guest
Jan 23rd, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. UserID | DateWorked | HoursWorked | AmountPaid
  2. ----------------------------------------------
  3. 1 | 11/01/17 | 5.00 | 20.00
  4. 1 | 11/02/17 | 3.00 | 5.00
  5. 2 | 11/15/17 | 10.00 | 50.00
  6.  
  7. declare @tablemonth table(...)
  8. declare @tableytd table(...)
  9. insert into @tablemonth execure RawDataSP @BeginDate = @BeginDate, @EndDate = @EndDate
  10. insert into @tableytd execure RawDataSP @BeginDate = @YTDBeginDate, @EndDate = @YTDEndDate
  11.  
  12. columns... | TotalHoursMonth | TotalPaidMonth | TotalHoursYTD | TotalPaidYTD
  13. ---------------------------------------------------------------------
  14. |hours counts | Amount paid |hours counts | Amount paid |
  15. |between 11/01/17 | between 11/01/17|between 01/01/17| between 01/01/17 |
  16. |and 11/30/17 | and 11/30/17 |and 10/30/17 | and 10/30/17 |
Add Comment
Please, Sign In to add comment