Technical Article

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

257 reads

Blogs

Azure Cosmos DB – HTAP using Azure Synapse Link

By

I haven’t done much blogging in the last 6 months. My last article was...

Azure Cosmos DB – HTAP using Synapse Analytics

By

I haven’t done much blogging in the last 6 months. My last article was...

Power BI Meets Programmability – TOM, XMLA, and C#

By

For anyone who read the title of this and immediately thought, “Oh no, I...

Read the latest Blogs

Forums

How to do Join

By patla4u

Hello, I am looking for output where EG_RequestID = 175998968 and Reissue from paymentID...

Connect to PostgreSQL as an External Data Source using PolyBase

By JerodJ

Comments posted to this topic are about the item Connect to PostgreSQL as an...

Growing and Keeping Up

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Growing and Keeping Up

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers