Jonathan Roberts


A DateRange Table Valued function

The function is an inline table-valued function (or sometimes called a parameterised view) so it can be used just like a view or a table but needs parameters. It generates a single-column table of datetime2 with rows differing by any multiple of any of the dateparts that SQL Server provides.

5 (6)

2019-08-29 (first published: )

1,839 reads

Blogs

Data Saturday #8–Southwest US

By

I am very excited to announce that I will be speaking for Data Saturday...

Data Weekender v3.1

By

I am super excited about this new version of Data Weekender, coming up on...

Thanks Kathi and Mala

By

I have to thank Kathi and Mala for putting on the WIT Mental Health...

Read the latest Blogs

Forums

Checking Up on Vendors

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Checking Up on Vendors, which...

SQL 2016 - Need help with complex calculations based on paycodes - New Changes

By DiabloSlayer

Hello Friends, Posting this for help as the client made more requirement changes. I...

Daily Autocheck for SQL instances

By mtz676

[System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources() | SELECT ServerName | Format-Table -HideTableHeaders The above code is not returning all...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers