Business Days

Tells how many calendar days are needed to complete a number of bussines days starting in a defined day of the week.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2012-07-23 (first published: 2012-07-04)

764 reads

BussinesDaysToCalendarDays

Tells how many calendar days are needed to complete a number of bussines days starting in a specified week day. Any comments? Let me know =D.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2012-07-20 (first published: 2012-07-04)

859 reads

A few years ago I took a new job at Microsoft, working as a...

I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...

I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...

Comments posted to this topic are about the item Building a SQL Server Fleet...

Comments posted to this topic are about the item Smart AI Agents and Data...

Comments posted to this topic are about the item RegEx Functions IV

I have this data in a table in a SQL Server 2025 database:

EmailAddressID EmailAddress
7              dylan0@ADVENTURE-WORKS.COM
8              Diane1@ADVENTURE-WORKS.COM

If I run this query, which row(s) are returned?

SELECT top 10
 *
 FROM person.EmailAddress
 WHERE REGEXP_LIKE(EmailAddress, '^D', 'i')
 AND BusinessEntityID IN (7,8)