Advertisement
Guest User

Untitled

a guest
Jun 25th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. SELECT SUM(SoldValue)
  2. FROM [dbo].[LabourData]
  3. where TenantId = 13 and GenDate = '2018-05-31 00:00:00.0000000'and Type = 'Labour'
  4. AND SaleType = 'Retail'
  5.  
  6. SELECT SUM(SoldValue)
  7. FROM [dbo].[LabourDetailedData]
  8. WHERE TenantId = 13 and GenDate = '2018-05-31 00:00:00.0000000' and Type = 'Labour'
  9. AND SaleType = 'Retail'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement