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: )

6,307 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

407 reads

Blogs

MVP No more, But It’s OK

By

Embracing Limitations: Finding Strength and Purpose in Hard Times For four years, I was...

A New Word: Fitching

By

fitching – v. intr. compulsively turning away from works of art you find frustratingly,...

Copilot in Microsoft Fabric

By

Microsoft Copilot is an app that uses AI to help you find information, create content,...

Read the latest Blogs

Forums

Urgent help for migration with error Login failed for the user

By ramana3327

Hi, We are migrating from SQL 2000 to SQL 2017. As a first step,...

Updated Table Not Displaying Data

By yrstruly

I have a table that contains data only to Financial Year/FY 2024: CREATE TABLE...

Pase keywords in text string

By Bruin

I've been trying to find an example to parse a record that looks for...

Visit the forum

Question of the Day

A Valid Type?

What happens when I run this code in SQL Server 2019?

DECLARE @variable CURSOR;

See possible answers