To find the week and quarter from date column using T-SQL. #SQLserver

find_week_and_quarter_from_date_sql_server.sql

--To find the week and quarter from date column using T-SQL.

DECLARE @temp_tb TABLE (CreateDate DATETIME)

INSERT INTO @temp_tb SELECT '2012-08-15 07:22:56.000'
INSERT INTO @temp_tb SELECT '2012-11-16 10:10:00.000'
INSERT INTO @temp_tb SELECT '2013-04-22 08:47:37.000'
INSERT INTO @temp_tb SELECT '2013-12-31 23:59:38.000'
INSERT INTO @temp_tb SELECT '2013-01-29 16:26:25.000'

SELECT CONVERT(VARCHAR(4),DATEPART(YEAR,CreateDate))+'_'+
  	(CASE LEN(DATEPART(WEEK,CreateDate)) 
		 WHEN 1 THEN '0'+CONVERT(VARCHAR(2),DATEPART(WEEK,CreateDate))
		 ELSE CONVERT(VARCHAR(2),DATEPART(WEEK,CreateDate))
		 END) AS Year_Week
,CONVERT(VARCHAR(4),DATEPART(YEAR,CreateDate))+'_0'+CONVERT(VARCHAR(2),DATEPART(QUARTER,CreateDate)) AS Year_Quarter
FROM @temp_tb