Calendar Table – Week number of month

by 
update TCalendar 
set = WeekNumberOfMonth = DATEDIFF(week, DATEADD(MONTH, DATEDIFF(MONTH, 0, FullDateAlternateKey), 0), FullDateAlternateKey) +1

More Related Contents:

  1. Add a column with a default value to an existing table in SQL Server
  2. Can I protect against SQL injection by escaping single-quote and surrounding user input with single-quotes?
  3. How to Join to first row
  4. Is SQL IN bad for performance?
  5. Pivot using SQL Server 2000
  6. How to get the first and last date of the current year?
  7. How can I generate a temporary table filled with dates in SQL Server 2000?
  8. How Can I Sort A ‘Version Number’ Column Generically Using a SQL Server Query
  9. Perform regex (replace) in an SQL query
  10. WHERE IS NULL, IS NOT NULL or NO WHERE clause depending on SQL Server parameter value
  11. Find last sunday
  12. MySQL: Alternatives to ORDER BY RAND()
  13. IN vs ANY operator in PostgreSQL
  14. sql query to return differences between two tables
  15. SQL Server 2005 How Create a Unique Constraint?
  16. Is there any boolean type in Oracle databases?
  17. Record returned from function has columns concatenated
  18. Rails 3 execute custom sql query without a model
  19. How to Select a substring in Oracle SQL up to a specific character?
  20. passing table and column name dynamically using bind variables
  21. SQL Use alias in Where statement
  22. PostgreSQL JOIN with array type with array elements order, how to implement?
  23. Trim trailing spaces with PostgreSQL
  24. Nth max salary in Oracle
  25. divide by zero/null workaround in SSRS 2008 report
  26. What does sp_reset_connection do?
  27. How to correctly insert newline in nvarchar [duplicate]
  28. Check whether string is a date Postgresql
  29. Postgresql query between date ranges
  30. Oracle ‘Partition By’ and ‘Row_Number’ keyword

Leave a Comment