I AM WRITING THE FOLLOWING FUNCTION CREATE FUNCTION [dbo].[Smart_Get_WeekOfMonth_Range] ( @F_DATE NVARCHAR(240) ) RETURNS NVARCHAR(240) BEGIN DECLARE @theDate DATETIME, @TMP_OUTPUT AS NVARCHAR(240) SET @theDate = @F_DATE ;WITH Yak(firstMonth, lastMonth, w) AS ( SELECT m.firstMonth, m.lastMonth, DATEADD(DAY, DATEDIFF(DAY, -53686, m.firstMonth) / 7 * 7, d.k - 53686) AS w FROM ( SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, @theDate), 0) AS firstMonth, DATEADD(MONTH, DATEDIFF(MONTH, -1, @theDate), -1) AS