Technical Article

UDF for date ranges around a given date (updated)

UDF - SQL 2000 and higherThis function returns an 18 row table of date ranges around a given date.The ranges are: Day, Week (Sunday to Saturday), Month, Quarter, Half Year, Year.For each range there are 3 values: Previous, Same and NextExample of usage:Joined to an orders table:Select r.period, count(o.order_id)from orders oinner join dbo.ufn_date_ranges('2003-04-01') ron o.order_date […]

2007-04-12 (first published: )

470 reads

Blogs

Scary Scalar Functions - Part Four: Your Environment

By

Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...

Being a script magpie

By

Last month (I ran just a little bit late writing this, it was meant...

Community Tools Month 2022 - dbatools

By

The Prompt In July, Brent Ozar (blog | twitter) asked us to make September...

Read the latest Blogs

Forums

How to copy XML converted data to file on local drive?

By Jobs90312

Hi everyone, So I have been working on converting my SQL tables data into...

The Growth of IQP

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Growth of IQP

How to work with Python in Azure Data Studio

By Daniel Calbimonte

Comments posted to this topic are about the item How to work with Python...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers