Advertisement
Dazzer1966

Percentage/Tax

Sep 17th, 2020
165
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.97 KB | None | 0 0
  1. CREATE PROCEDURE [dbo].[April_2021_MinusTax]
  2.  
  3. AS
  4.     SELECT (SELECT Sum(Isnull(job_value, 0)) - ( 12500 )
  5.             FROM   dbo.tbl_jobs
  6.             WHERE  installation_date BETWEEN '2020-05-20' AND '2021-04-04') -
  7.                   (SELECT Sum(Isnull(Van, 0))
  8.                           + Sum(Isnull(Tools, 0))
  9.                           + Sum(Isnull(Fuel, 0))
  10.                           + Sum(Isnull(Insurance, 0))
  11.                           + Sum(Isnull(Screwfix, 0))
  12.                           + Sum(Isnull(Building, 0))
  13.                           + Sum(Isnull(Office, 0))
  14.                           + Sum(Isnull(Clothing, 0))
  15.                           + sum(isnull(Phone, 0))
  16.                    FROM   Expenses
  17.                    WHERE  Invoice_Date BETWEEN '20200405' AND '20210404') -
  18.                   (SELECT Sum(Isnull(admin_fee, 0))
  19.                    FROM
  20.                   tbl_jobs
  21.                   WHERE
  22.                   installation_date BETWEEN '20200405' AND '20210404')
  23.                  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement