I am trying to combine two stored procedures I have but my syntax is wrong ... help ?
/****** Object: StoredProcedure [dbo].[Totalmonthlyexpenses] Script Date: 08/15/2012 20:49:53 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE PROCEDURE [dbo].[Monthlytotalbalance]
(Select SUM ((c.BDotcut)*a.qty)
from dbo.Subscriptions a
inner join Clients as b on a.clientid = b.Clientid
inner join Services as c on c.Serviceid = a.serviceid
WHERE c.billedon = 'm') -
(Select SUM (amount) as TotalExpenses
WHERE recurring = 'm')
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL).
Depending on business requirements, a single Stored Procedure can return differe…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …