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: )

253 reads

Blogs

Encryption in SQL Server #1 – Column Level Encryption

By

For one reason or another data security and encryption has been coming up quite...

Career: Talk To References

By

As we try to get through these strange times in the world, I am...

This Saturday: #DataWeekender, DataSaturday Southwest

By

Geeked to be speaking 2x on Saturday May 14, my second time speaking at...

Read the latest Blogs

Forums

SSIS Import only new values from a CSV without using a staging table

By datsun

Hello, How can I import a CSV file in SSIS (2016) at the same...

Query store index rebuilds

By Rasmus Remmer Bielidt

Recently we experienced a sudden surge in disk I/O every twenty minutes or so....

Group Managed Service Accounts for SQL Server 2017/2019

By @@caffeine_level

We use group managed service accounts for running the SQL Server 2017/2019 sqlserver.exe processes...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers