check this example
DECLARE @Date Datetime= getdate()
SELECT
@Date Supplied_Date
, month(@Date) Month_Number
, datename(month,@Date) Month_Name
, datepart(week,@Date) Week_Of_Year
, datediff(week, dateadd(week, datediff(week, 0, dateadd(month, datediff(month, 0, @date), 0)), 0), @date - 1) + 1 Week_Of_Month
Happy Coding!
:)