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 (5)

2019-08-29 (first published: )

967 reads

Blogs

SSAS Tabular – Process Add memory consumption

By

For me it’s a bit surprising how little information can be found regarding the...

Our SQL Server 2019 Administration Inside Out Fun Author Survey

By

SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...

What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup

By

Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...

Read the latest Blogs

Forums

Going from Failover Cluster Instance to Availability Group with Azure Replica

By jcourtjrSQL

So if we have a FCI on premises, and want to add Availability Group...

most efficient way to copy data from one table to another in a different DB

By Budd

I have a table in DB [a] (a.dbo.a) that gets reloaded every 10 minutes...

What is spinlock ALLOC_CACHES_HASH?

By My_Sky

Hi, Queries are slow, cpu usage at 80%. ALLOC_CACHES_HASH backoffs start at same time...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers