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,076 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

404 reads

Blogs

Summit Launch Pricing Ends June 7

By

The PASS Data Community Summit is back in Seattle this November, the 14-17, 2023....

Masking Columns in Azure SQL and SQL Server: Safeguarding Sensitive Data

By

Information security and privacy are key in today’s data-driven world. Sensitive data needs to...

Tales From The Field Weekly Wrap Up for the Week of 05-22-2023 Microsoft Fabric Launch & Moving Home Offices

By

 Hello Dear Reader!  Sorry this is so late, moving houses has gotten me a...

Read the latest Blogs

Forums

You have an error in your SQL syntax; check the manual that corresponds

By yrstruly

I am having great trouble creating a data pipeline using MariaDB connector 3 with...

Availability Group database went into 'Restoring' state

By Arsh

Dear Friends, Please advise why would one of my Availability Group databases go into...

Access db

By sqlguru

Access db wanting to move  sql server, how much control does business have over...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers