How to get the six week sunday's weekno in SQL server 2008 r2?

I want to get the six week sundays weekno using the SQL Server 2008.For example i have the November month, date 18, year 2012. The WeekNo of the November month 18 th date is “47”.

  • How to add minutes in DateTime value from SQL Server to C#
  • Sql server greater than operator gives wrong result on datetime
  • Not reinitialize variable inside While Loop
  • can we pass parameter to a view in sql?
  • SSIS - Parallel execution of same package
  • Recursive t-sql query
  • One Solution collect form web for “How to get the six week sunday's weekno in SQL server 2008 r2?”

    Try this:

    SELECT DATEPART(week,'18-nov-2012')
    
    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.