Skip to main content

Get Current Month Total Sales Using SQL Query or Store procedure, get Today Date from SQL , Get first Day of the Month




CREATE PROCEDURE [dbo].[GetSalesbyMonthly]
AS
BEGIN
DECLARE @Today DATE;
DECLARE @FirstDay DATE;
    /*Get First Day  And Month And into @FirstDay Variable */
    SET @FirstDay= (select dateadd(dd,-(day(getdate())-1),getdate()) )
    /*Get Today And Store into @Today Variable */
    SET @Today= (SELECT CONVERT(DATE,GETDATE()) AS Today)   
    BEGIN
            SELECT  ISNULL(SUM([TotalSale]),0) AS TotalSales FROM YOURSALE TABLE  WHERE  (DATE-COLUMN BETWEEN @FirstDay AND @Today)
    END   
END

Comments

Post a Comment

Popular posts from this blog

Get Day Wise Sale of the Week Using SQL Query or Store procedure, get Today Date, get Last Friday from SQL, Create Temporary table in SQL, Drop Temporary table From SQL Create PROCEDURE [dbo].[GetDaysOfTheWeek] AS BEGIN --Creating TEMP Table Create Table #Days (    TodayDate Varchar(12),    Sales decimal (18,2) ) DECLARE @Today DATE; DECLARE @LastFriday DATE; DECLARE @sale decimal (18,2); DECLARE @CurrentDate AS DATE; /*Get Last Friday And Store into @LastFriday Variable */ SET @LastFriday=(SELECT                     CASE WHEN (DATEPART(DW,GETDATE())< 7)                         THEN                             CONVERT(DATE,(DATEADD(dd,-(DATEPART(DW,GETDATE())+1),GETDATE())))    ...
Post a Comment
Read more