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

255 reads

Blogs

3 Reasons Why Focusing on Tech Is The Worst Way To Deploy a HA/DR Solution

By

This past Thursday, Edwin Sarmiento presented a session for our Microsoft Data Platform Continuity...

The PowerBI Volleyball Report – Organizing Data To Start

By

One of my goals this year was to build a report that I can...

Daily Coping 2 Aug 2021

By

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

Read the latest Blogs

Forums

Import CSV Data Into Existing Tables

By VSCurtis

Hi Guys, I am having issues trying to import data from CSV files into...

Function not returning all data.

By David C Young

I inherited this code. Written by a 3rd party. I have 3 servers, 1...

Need to change RS Execution Acct PWD, automatically w/ T-SQL

By Express12

We use a 3rd party vendor to administer our SQL Server service account PWDS....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers