Convert dates to week numbers in SQL Server

Hi makumbi,

Use the following query to calculate the Week number.

DECLARE @Date DATETIME
SET @Date = '12/01/2023'
SELECT CONCAT('wk', (DATEPART(WEEK, @Date) - DATEPART(WEEK, DATEADD(MM, DATEDIFF(MM,0,@Date), 0))+ 1)) AS Week_Number

Then pivot query to for displaying the result.

For more details refer below link.

Convert Rows To Columns and Calculate Sum using dynamic Pivot query in SQL Server