Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. declare @getCount1 int = 0,
  2. @getCount2 int = 0,
  3. @Total int = 0,
  4. @projectID int,
  5. @periodID int
  6.  
  7.  
  8. exec @Result1 = [dbo].[QSP_getCount1] @projectID = 1,
  9. @periodID = 12
  10.  
  11. exec @Result2= [dbo].[QSP_getCount2] @projectID = 1,
  12. @periodID = 12
  13.  
  14. set @Total = @Result1 + @Result2
  15.  
  16. select @Total
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement