Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TOP(1) t1.Activated
- FROM [dbo].[tblVoucher] AS t0
- INNER JOIN [dbo].[tblVoucherActived] AS t1 ON t0.VoucherID = t1.VoucherID -- is activated
- WHERE t0.VoucherID = 648455117
- ORDER BY t1.Activated DESC
- SELECT TOP(1) t1.Activated
- FROM [dbo].[tblVoucher] AS t0
- INNER JOIN [dbo].[tblVoucherActived] AS t1 ON t0.VoucherID = t1.VoucherID -- is activated
- INNER JOIN [dbo].[tblAccount] AS t2 ON t1.ActivatedByAccountID = t2.AccountID
- WHERE t0.VoucherID = 648455117
- ORDER BY t1.Activated DESC
- SELECT TOP(1) t1.Activated, t3.DisplayName
- FROM [dbo].[tblVoucher] AS t0
- INNER JOIN [dbo].[tblVoucherActived] AS t1 ON t0.VoucherID = t1.VoucherID -- is activated
- INNER JOIN [dbo].[tblAccount] AS t2 ON t1.ActivatedByAccountID = t2.AccountID
- INNER JOIN [dbo].[tblUser] AS t3 ON t2.UserID = t3.UserID
- WHERE t0.VoucherID = 648455117
- ORDER BY t1.Activated DESC
- SELECT TOP(1) t1.Activated, t4.ProjectNumber, t4.[Name]
- FROM [dbo].[tblVoucher] AS t0
- INNER JOIN [dbo].[tblVoucherActived] AS t1 ON t0.VoucherID = t1.VoucherID -- is activated
- INNER JOIN [dbo].[tblProject] AS t4 ON t1.ProjectID = t4.ProjectID
- WHERE t0.VoucherID = 648455117
- ORDER BY t1.Activated DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement