API tools faq
paste
Advertisement
snapxynith

stirling-today

snapxynith
Aug 11th, 2020
2,026
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 10.25 KB | None | 0 0
raw download clone embed print report
  1. SELECT 'Michael Boychuck 50%' AS 'Name', SUM(discount) AS discountamt, SUM(quan * costeach) AS "sold", (SUM(discount) + SUM(quan * costeach)) AS "sold-discount",  ((SUM(discount) + SUM(quan * costeach)) * 0.5) AS 'commission' FROM (dba.posdetail d0 INNER JOIN dba.posheader AS posheader ON (posheader.transact = d0.transact)) WHERE (posheader.STATUS = 3 AND NOT (d0.prodtype IN (100,101)) AND d0.opendate = dateadd(DAY, 0, CONVERT(VARCHAR(10), getdate(), 120)) AND masteritem IN (SELECT d1.masteritem FROM dba.posdetail d1 WHERE prodnum =5375)) UNION ALL SELECT 'Oscar Gomez 50%' AS 'Name', SUM(discount) AS discountamt, SUM(quan * costeach) AS "sold", (SUM(discount) + SUM(quan * costeach)) AS "sold-discount",  ((SUM(discount) + SUM(quan * costeach)) * 0.5) AS 'commission' FROM (dba.posdetail d0 INNER JOIN dba.posheader AS posheader ON (posheader.transact = d0.transact)) WHERE (posheader.STATUS = 3 AND NOT (d0.prodtype IN (100,101)) AND d0.opendate = dateadd(DAY, 0, CONVERT(VARCHAR(10), getdate(), 120)) AND masteritem IN (SELECT d1.masteritem FROM dba.posdetail d1 WHERE prodnum =5376)) UNION ALL SELECT 'Christina Olsen 50%' AS 'Name', SUM(discount) AS discountamt, SUM(quan * costeach) AS "sold", (SUM(discount) + SUM(quan * costeach)) AS "sold-discount",  ((SUM(discount) + SUM(quan * costeach)) * 0.5) AS 'commission' FROM (dba.posdetail d0 INNER JOIN dba.posheader AS posheader ON (posheader.transact = d0.transact)) WHERE (posheader.STATUS = 3 AND NOT (d0.prodtype IN (100,101)) AND d0.opendate = dateadd(DAY, 0, CONVERT(VARCHAR(10), getdate(), 120)) AND masteritem IN (SELECT d1.masteritem FROM dba.posdetail d1 WHERE prodnum =5377)) UNION ALL SELECT 'Gabriela Perez 50%' AS 'Name', SUM(discount) AS discountamt, SUM(quan * costeach) AS "sold", (SUM(discount) + SUM(quan * costeach)) AS "sold-discount",  ((SUM(discount) + SUM(quan * costeach)) * 0.5) AS 'commission' FROM (dba.posdetail d0 INNER JOIN dba.posheader AS posheader ON (posheader.transact = d0.transact)) WHERE (posheader.STATUS = 3 AND NOT (d0.prodtype IN (100,101)) AND d0.opendate = dateadd(DAY, 0, CONVERT(VARCHAR(10), getdate(), 120)) AND masteritem IN (SELECT d1.masteritem FROM dba.posdetail d1 WHERE prodnum =5378)) UNION ALL SELECT 'Jenny Arce 40%' AS 'Name', SUM(discount) AS discountamt, SUM(quan * costeach) AS "sold", (SUM(discount) + SUM(quan * costeach)) AS "sold-discount",  ((SUM(discount) + SUM(quan * costeach)) * 0.4) AS 'commission' FROM (dba.posdetail d0 INNER JOIN dba.posheader AS posheader ON (posheader.transact = d0.transact)) WHERE (posheader.STATUS = 3 AND NOT (d0.prodtype IN (100,101)) AND d0.opendate = dateadd(DAY, 0, CONVERT(VARCHAR(10), getdate(), 120)) AND masteritem IN (SELECT d1.masteritem FROM dba.posdetail d1 WHERE prodnum =5379)) UNION ALL SELECT 'Marco Saenz 20%' AS 'Name', SUM(discount) AS discountamt, SUM(quan * costeach) AS "sold", (SUM(discount) + SUM(quan * costeach)) AS "sold-discount",  ((SUM(discount) + SUM(quan * costeach)) * 0.2) AS 'commission' FROM (dba.posdetail d0 INNER JOIN dba.posheader AS posheader ON (posheader.transact = d0.transact)) WHERE (posheader.STATUS = 3 AND NOT (d0.prodtype IN (100,101)) AND d0.opendate = dateadd(DAY, 0, CONVERT(VARCHAR(10), getdate(), 120)) AND masteritem IN (SELECT d1.masteritem FROM dba.posdetail d1 WHERE prodnum =5380)) UNION ALL SELECT 'Gina Capasso 50%' AS 'Name', SUM(discount) AS discountamt, SUM(quan * costeach) AS "sold", (SUM(discount) + SUM(quan * costeach)) AS "sold-discount",  ((SUM(discount) + SUM(quan * costeach)) * 0.5) AS 'commission' FROM (dba.posdetail d0 INNER JOIN dba.posheader AS posheader ON (posheader.transact = d0.transact)) WHERE (posheader.STATUS = 3 AND NOT (d0.prodtype IN (100,101)) AND d0.opendate = dateadd(DAY, 0, CONVERT(VARCHAR(10), getdate(), 120)) AND masteritem IN (SELECT d1.masteritem FROM dba.posdetail d1 WHERE prodnum =5381)) UNION ALL SELECT 'Elizabeth Orozco 40%' AS 'Name', SUM(discount) AS discountamt, SUM(quan * costeach) AS "sold", (SUM(discount) + SUM(quan * costeach)) AS "sold-discount",  ((SUM(discount) + SUM(quan * costeach)) * 0.4) AS 'commission' FROM (dba.posdetail d0 INNER JOIN dba.posheader AS posheader ON (posheader.transact = d0.transact)) WHERE (posheader.STATUS = 3 AND NOT (d0.prodtype IN (100,101)) AND d0.opendate = dateadd(DAY, 0, CONVERT(VARCHAR(10), getdate(), 120)) AND masteritem IN (SELECT d1.masteritem FROM dba.posdetail d1 WHERE prodnum =5382)) UNION ALL SELECT 'Darlene Gahagan 50%' AS 'Name', SUM(discount) AS discountamt, SUM(quan * costeach) AS "sold", (SUM(discount) + SUM(quan * costeach)) AS "sold-discount",  ((SUM(discount) + SUM(quan * costeach)) * 0.5) AS 'commission' FROM (dba.posdetail d0 INNER JOIN dba.posheader AS posheader ON (posheader.transact = d0.transact)) WHERE (posheader.STATUS = 3 AND NOT (d0.prodtype IN (100,101)) AND d0.opendate = dateadd(DAY, 0, CONVERT(VARCHAR(10), getdate(), 120)) AND masteritem IN (SELECT d1.masteritem FROM dba.posdetail d1 WHERE prodnum =5383)) UNION ALL SELECT 'La Chelle Hall 10%' AS 'Name', SUM(discount) AS discountamt, SUM(quan * costeach) AS "sold", (SUM(discount) + SUM(quan * costeach)) AS "sold-discount",  ((SUM(discount) + SUM(quan * costeach)) * 0.1) AS 'commission' FROM (dba.posdetail d0 INNER JOIN dba.posheader AS posheader ON (posheader.transact = d0.transact)) WHERE (posheader.STATUS = 3 AND NOT (d0.prodtype IN (100,101)) AND d0.opendate = dateadd(DAY, 0, CONVERT(VARCHAR(10), getdate(), 120)) AND masteritem IN (SELECT d1.masteritem FROM dba.posdetail d1 WHERE prodnum =5384)) UNION ALL SELECT 'Darlene Gahagan 10%' AS 'Name', SUM(discount) AS discountamt, SUM(quan * costeach) AS "sold", (SUM(discount) + SUM(quan * costeach)) AS "sold-discount",  ((SUM(discount) + SUM(quan * costeach)) * 0.1) AS 'commission' FROM (dba.posdetail d0 INNER JOIN dba.posheader AS posheader ON (posheader.transact = d0.transact)) WHERE (posheader.STATUS = 3 AND NOT (d0.prodtype IN (100,101)) AND d0.opendate = dateadd(DAY, 0, CONVERT(VARCHAR(10), getdate(), 120)) AND masteritem IN (SELECT d1.masteritem FROM dba.posdetail d1 WHERE prodnum =5385)) UNION ALL SELECT 'Elizabeth Orozco 10%' AS 'Name', SUM(discount) AS discountamt, SUM(quan * costeach) AS "sold", (SUM(discount) + SUM(quan * costeach)) AS "sold-discount",  ((SUM(discount) + SUM(quan * costeach)) * 0.1) AS 'commission' FROM (dba.posdetail d0 INNER JOIN dba.posheader AS posheader ON (posheader.transact = d0.transact)) WHERE (posheader.STATUS = 3 AND NOT (d0.prodtype IN (100,101)) AND d0.opendate = dateadd(DAY, 0, CONVERT(VARCHAR(10), getdate(), 120)) AND masteritem IN (SELECT d1.masteritem FROM dba.posdetail d1 WHERE prodnum =5386)) UNION ALL SELECT 'Gina Capasso 10%' AS 'Name', SUM(discount) AS discountamt, SUM(quan * costeach) AS "sold", (SUM(discount) + SUM(quan * costeach)) AS "sold-discount",  ((SUM(discount) + SUM(quan * costeach)) * 0.1) AS 'commission' FROM (dba.posdetail d0 INNER JOIN dba.posheader AS posheader ON (posheader.transact = d0.transact)) WHERE (posheader.STATUS = 3 AND NOT (d0.prodtype IN (100,101)) AND d0.opendate = dateadd(DAY, 0, CONVERT(VARCHAR(10), getdate(), 120)) AND masteritem IN (SELECT d1.masteritem FROM dba.posdetail d1 WHERE prodnum =5387)) UNION ALL SELECT 'Marco Saenz 10%' AS 'Name', SUM(discount) AS discountamt, SUM(quan * costeach) AS "sold", (SUM(discount) + SUM(quan * costeach)) AS "sold-discount",  ((SUM(discount) + SUM(quan * costeach)) * 0.1) AS 'commission' FROM (dba.posdetail d0 INNER JOIN dba.posheader AS posheader ON (posheader.transact = d0.transact)) WHERE (posheader.STATUS = 3 AND NOT (d0.prodtype IN (100,101)) AND d0.opendate = dateadd(DAY, 0, CONVERT(VARCHAR(10), getdate(), 120)) AND masteritem IN (SELECT d1.masteritem FROM dba.posdetail d1 WHERE prodnum =5388)) UNION ALL SELECT 'Jenny Arce 10%' AS 'Name', SUM(discount) AS discountamt, SUM(quan * costeach) AS "sold", (SUM(discount) + SUM(quan * costeach)) AS "sold-discount",  ((SUM(discount) + SUM(quan * costeach)) * 0.1) AS 'commission' FROM (dba.posdetail d0 INNER JOIN dba.posheader AS posheader ON (posheader.transact = d0.transact)) WHERE (posheader.STATUS = 3 AND NOT (d0.prodtype IN (100,101)) AND d0.opendate = dateadd(DAY, 0, CONVERT(VARCHAR(10), getdate(), 120)) AND masteritem IN (SELECT d1.masteritem FROM dba.posdetail d1 WHERE prodnum =5389)) UNION ALL SELECT 'Gabriela Perez 10%' AS 'Name', SUM(discount) AS discountamt, SUM(quan * costeach) AS "sold", (SUM(discount) + SUM(quan * costeach)) AS "sold-discount",  ((SUM(discount) + SUM(quan * costeach)) * 0.1) AS 'commission' FROM (dba.posdetail d0 INNER JOIN dba.posheader AS posheader ON (posheader.transact = d0.transact)) WHERE (posheader.STATUS = 3 AND NOT (d0.prodtype IN (100,101)) AND d0.opendate = dateadd(DAY, 0, CONVERT(VARCHAR(10), getdate(), 120)) AND masteritem IN (SELECT d1.masteritem FROM dba.posdetail d1 WHERE prodnum =5390)) UNION ALL SELECT 'Christina Olsen 10%' AS 'Name', SUM(discount) AS discountamt, SUM(quan * costeach) AS "sold", (SUM(discount) + SUM(quan * costeach)) AS "sold-discount",  ((SUM(discount) + SUM(quan * costeach)) * 0.1) AS 'commission' FROM (dba.posdetail d0 INNER JOIN dba.posheader AS posheader ON (posheader.transact = d0.transact)) WHERE (posheader.STATUS = 3 AND NOT (d0.prodtype IN (100,101)) AND d0.opendate = dateadd(DAY, 0, CONVERT(VARCHAR(10), getdate(), 120)) AND masteritem IN (SELECT d1.masteritem FROM dba.posdetail d1 WHERE prodnum =5391)) UNION ALL SELECT 'Oscar Gomez 10%' AS 'Name', SUM(discount) AS discountamt, SUM(quan * costeach) AS "sold", (SUM(discount) + SUM(quan * costeach)) AS "sold-discount",  ((SUM(discount) + SUM(quan * costeach)) * 0.1) AS 'commission' FROM (dba.posdetail d0 INNER JOIN dba.posheader AS posheader ON (posheader.transact = d0.transact)) WHERE (posheader.STATUS = 3 AND NOT (d0.prodtype IN (100,101)) AND d0.opendate = dateadd(DAY, 0, CONVERT(VARCHAR(10), getdate(), 120)) AND masteritem IN (SELECT d1.masteritem FROM dba.posdetail d1 WHERE prodnum =5392)) UNION ALL SELECT 'Michael Boychuck 10%' AS 'Name', SUM(discount) AS discountamt, SUM(quan * costeach) AS "sold", (SUM(discount) + SUM(quan * costeach)) AS "sold-discount",  ((SUM(discount) + SUM(quan * costeach)) * 0.1) AS 'commission' FROM (dba.posdetail d0 INNER JOIN dba.posheader AS posheader ON (posheader.transact = d0.transact)) WHERE (posheader.STATUS = 3 AND NOT (d0.prodtype IN (100,101)) AND d0.opendate = dateadd(DAY, 0, CONVERT(VARCHAR(10), getdate(), 120)) AND masteritem IN (SELECT d1.masteritem FROM dba.posdetail d1 WHERE prodnum =5393)) ORDER BY name
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!