Return WeekNo (ISO 8601 standard)

In MS SQL, January 1 of any year defines the starting number for the week. The DATEPART(wk, 'Jan 1, xxxx') always return 1. However, a lot of reports Week No is actually based on ISO 8601 standard, that is January 1 of any year can be Week 53/52 or Week 1. (http://www.merlyn.demon.co.uk/weekinfo.htm#IDC)The Rule is as […]

2005-06-14 (first published: )

247 reads

Blogs

Daily Coping 13 Aug 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Homework – August 2020 – More DML Triggers

By

Well, I’m running a bit late. Both for this month and the fact I...

Your First Databricks Notebook

By

On August 4, 2020, I presented this on the weekly Pragmatic Works webinar series....

Read the latest Blogs

Forums

Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

Guidance on Application changes to support the 2014 Cardinality Estimator update

By Steve

Hello all. We recently had an opportunity to discover a hidden treasure in SQL...

XE predicate order

By dbgaragedays

Hello, I am reading Stellato's Extended Events Stairway series and in the final (4th)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers