Advanced

Technical Article

Create a Tally Function (fnTally)

  • Script

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,397 reads

SQLServerCentral Article

A Love Hate Affair with User Defined Types

  • Article

Many new DBAs think that User-defined types are a very cool feature in SQL Server when they first encounter them. However many experienced DBAs soon realize that UDTs can be a pain to work with and longtime SQL Server guru David Poole discusses his experiences

5 (5)

You rated this post out of 5. Change rating

2007-07-23

7,608 reads

Blogs

A New Word: Ghough

By

ghough – n. a hollow place in your psyche that can never be filled;...

T-SQL Tuesday: Encryption and Data Protection

By

I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...

Parameterize your Databricks notebooks with widgets

By

Widgets provide a way to parameterize notebooks in Databricks. If you need to call...

Read the latest Blogs

Forums

Error message in launching web service url in sql report server

By Teewhy

I am getting the following error when I launch web service url in sql...

How to Pivot daily date to a week Row

By Chris Spencer

I have data as below which is a per day view, I wish to...

SSRS Report Upgrade issue with # Temp tables for 800+ lines of Query

By ralahari

one of the Report which calls two Data sets , Data set1 Contains ,...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers