Hi iammann,
You need to generate the sql query based on the month record you want to dispaly.
Check the below query and add the condition for each month 1 and 15 date.
SQL
CREATE TABLE #Account
(
[AccountID] int IDENTITY(1,1) NOT NULL,
[AccountName] VARCHAR(50),
[Email] VARCHAR(50),
[CcEmail] VARCHAR(50),
[BcEmail] VARCHAR(50),
[SapCode] int,
[June] DECIMAL(18,2),
[July] DECIMAL(18,2),
[August] DECIMAL(18,2),
[September] DECIMAL(18,2),
[October] DECIMAL(18,2),
[November] DECIMAL(18,2),
[December] DECIMAL(18,2),
[January] DECIMAL(18,2),
[February] DECIMAL(18,2),
[March] DECIMAL(18,2),
[April] DECIMAL(18,2),
[May] DECIMAL(18,2),
[AccType] VARCHAR(50)
)
INSERT INTO #Account VALUES('Sunil','Sunil@gmail.com','Sunil@gmail.com','','',0.26 ,2.5,1.21,1.88,0.78,1.28,0.89,0.62,0.67,1.23,0.69,1.2,'Priority')
INSERT INTO #Account VALUES('Jagrity','jagrity@gmail.com','jagrity@gmail.com','','',0.23 ,2.4,1.22,1.88,0.77,1.26,0.89,0.62,0.67,1.23,0.69,1.2,'Priority')
INSERT INTO #Account VALUES('Vinod','Vinodanw@gmail.com','Vinod@gmail.com','','',0.29 ,2.6,2.22,1.45,0.78,1.24,0.89,0.62,0.67,1.23,0.69,1.2,'Priority')
INSERT INTO #Account VALUES('Aniket','Aniket@gmail.com','Aniket@gmail.com','','',0.24 ,2.7,3.22,1.81,0.78,1.23,0.89,0.62,0.67,1.23,0.69,1.2,'Priority')
DECLARE @query VARCHAR(MAX)
DECLARE @Date DATETIME
SET @Date = '2019/11/15'
IF(@Date = '2019/10/01')
SET @query = 'SELECT AccountID,AccountName,Email,CcEmail,BcEmail,SapCode,July,August,September FROM #Account '
ELSE IF(@Date = '2019/10/15')
SET @query = 'SELECT AccountID,AccountName,Email,CcEmail,BcEmail,SapCode,July,August,September,CONVERT(DECIMAL(18,2),October/2) AS ''October'' FROM #Account '
ELSE IF(@Date = '2019/11/01')
SET @query = 'SELECT AccountID,AccountName,Email,CcEmail,BcEmail,SapCode,July,August,September,October FROM #Account '
ELSE IF(@Date = '2019/11/15')
SET @query = 'SELECT AccountID,AccountName,Email,CcEmail,BcEmail,SapCode,July,August,September,October,CONVERT(DECIMAL(18,2),November/2) AS ''November'' FROM #Account '
EXEC(@query)
DROP TABLE #Account
