Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE [dbo].[April_2021_MinusTax]
- AS
- SELECT (SELECT Sum(Isnull(job_value, 0)) - ( 12500 )
- FROM dbo.tbl_jobs
- WHERE installation_date BETWEEN '2020-05-20' AND '2021-04-04') -
- (SELECT Sum(Isnull(Van, 0))
- + Sum(Isnull(Tools, 0))
- + Sum(Isnull(Fuel, 0))
- + Sum(Isnull(Insurance, 0))
- + Sum(Isnull(Screwfix, 0))
- + Sum(Isnull(Building, 0))
- + Sum(Isnull(Office, 0))
- + Sum(Isnull(Clothing, 0))
- + sum(isnull(Phone, 0))
- FROM Expenses
- WHERE Invoice_Date BETWEEN '20200405' AND '20210404') -
- (SELECT Sum(Isnull(admin_fee, 0))
- FROM
- tbl_jobs
- WHERE
- installation_date BETWEEN '20200405' AND '20210404')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement