Jeff Moden

  • Interests: SQL. When Im not having fun with that, then SQL. ;-)

Technical Article

Create a Tally Function (fnTally)

Many people have published high performance, read-less, Inline Table Valued functions that use Itzik Ben-Gan's wonderful "Virtual Numbers Table" to replace WHILE loops and other forms of RBAR. This one is Jeff Moden's version.

4.86 (7)

You rated this post out of 5. Change rating

2019-08-13 (first published: )

5,534 reads

Technical Article

Difference between dates with thousands separators

This function calculates the time difference between 2 datetimes and displays the results in the following format:H,HHH,HHH:MM:SSThe return is a 15 character field that is left padded with spaces so that the field becomes right justified.  This makes the colons line up for easy reading.  Commas are automatically added as thousands separators as needed by […]

3 (2)

You rated this post out of 5. Change rating

2004-03-14

406 reads

Blogs

TryHackMe Advent of Cyber

By

I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...

You should be running on SQL Server 2022

By

It’s me again with my apparently semi-annual blog post. This time we’re going to...

Removing a PowerShell Array Element–#SQLNewBlogger

By

I saw an article on this and realized I had no idea how to...

Read the latest Blogs

Forums

SQL AOAG with listener ( without windows clustering)

By chetan06

Hello, I am deploying SQL 2019 Enterprise edition with AOAG ( without windows clustering)....

Event ID 65102 [Warning] FailoverClusterQueryError

By Luckless7611

Hello @all, i am facing a problem and can not find a solution... I...

Check scheduled pipelines in ADF

By blom0344

We are used to the job activity monitor in SQL server allowing quick checks...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers