Update column value on every month based on condition using Stored Procedure in SQL Server

Hi mahesh213,

Use Below query.

CREATE PROCEDURE UpdateCount
AS
BEGIN
	IF (GETDATE() = CAST(CAST(YEAR(GETDATE()) AS VARCHAR(4))+'/06/01' AS DATETIME))
	BEGIN
		UPDATE Employee SET [Count] = [Count] + 1
	END
	ELSE IF (GETDATE() = CAST(CAST(YEAR(GETDATE()) AS VARCHAR(4))+'/12/01' AS DATETIME))
	BEGIN
		UPDATE Employee SET [Count] = [Count] + 1
	END	
	ELSE IF (GETDATE() = DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0))
	BEGIN
		UPDATE Employee SET [Count] = [Count] + 2
	END
END