Advertisement
Guest User

Untitled

a guest
Jan 16th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. SELECT TOP(1) t1.Activated
  2. FROM [dbo].[tblVoucher] AS t0
  3. INNER JOIN [dbo].[tblVoucherActived] AS t1 ON t0.VoucherID = t1.VoucherID -- is activated
  4. WHERE t0.VoucherID = 648455117
  5. ORDER BY t1.Activated DESC
  6.  
  7. SELECT TOP(1) t1.Activated
  8. FROM [dbo].[tblVoucher] AS t0
  9. INNER JOIN [dbo].[tblVoucherActived] AS t1 ON t0.VoucherID = t1.VoucherID -- is activated
  10. INNER JOIN [dbo].[tblAccount] AS t2 ON t1.ActivatedByAccountID = t2.AccountID
  11. WHERE t0.VoucherID = 648455117
  12. ORDER BY t1.Activated DESC
  13.  
  14. SELECT TOP(1) t1.Activated, t3.DisplayName
  15. FROM [dbo].[tblVoucher] AS t0
  16. INNER JOIN [dbo].[tblVoucherActived] AS t1 ON t0.VoucherID = t1.VoucherID -- is activated
  17. INNER JOIN [dbo].[tblAccount] AS t2 ON t1.ActivatedByAccountID = t2.AccountID
  18. INNER JOIN [dbo].[tblUser] AS t3 ON t2.UserID = t3.UserID
  19. WHERE t0.VoucherID = 648455117
  20. ORDER BY t1.Activated DESC
  21.  
  22.  
  23. SELECT TOP(1) t1.Activated, t4.ProjectNumber, t4.[Name]
  24. FROM [dbo].[tblVoucher] AS t0
  25. INNER JOIN [dbo].[tblVoucherActived] AS t1 ON t0.VoucherID = t1.VoucherID -- is activated
  26. INNER JOIN [dbo].[tblProject] AS t4 ON t1.ProjectID = t4.ProjectID
  27. WHERE t0.VoucherID = 648455117
  28. ORDER BY t1.Activated DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement