Please vote for the "built in Tally Table" function.

Question

Please vote for the "built in Tally Table" function.

Jeff Moden

SSC Guru

Points: 1004290
More actions
November 24, 2014 at 10:17 pm

#397686

Please see the following CONNECT item by Erland Sommarskog.
https://connect.microsoft.com/SQLServer/Feedback/Details/258733
Also notice that the item is still listed as ACTIVE and, in 3 months, the suggestion will be 8 years old and Microsoft still hasn't seen fit to boost the priority on this.
Please lend a helping hand here. If you use a Tally or Numbers table, take a minute out to vote this one up. If you don't know what a Tally or Numbers table actually is, please do yourself a favor and learn how to use it. It'll change your life. See the following article for what it is and how it can be used as a very high speed replacement for certain types of loops and then vote it up. I'd personally love to see this one top the charts for vote ups.
http://www.sqlservercentral.com/articles/T-SQL/62867/
Thanks for your help, folks.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Viewing 15 posts - 1 through 15 (of 38 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Voted.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Eirikur Eiriksson SSC Guru Points: 182901 More actions · Answer 2

Eirikur Eiriksson

SSC Guru

Points: 182901

November 25, 2014 at 1:01 am

#1760701

+1 (vote)

😎

Jeff Moden SSC Guru Points: 1004290 More actions · Answer 3

Thanks Koen and Eirikur!

How about it folks? There a 1.7 million of you out there. Can we get a few more votes on this important subject? Thanks. 🙂

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

Lynn Pettis

SSC Guru

Points: 442467

November 26, 2014 at 2:57 am

#1761014

Voted!

Neil Burton SSC-Insane Points: 22995 More actions · Answer 5

Voted.

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

Ed Wagner SSC Guru Points: 287026 More actions · Answer 6

My vote made the count 147.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

I decided to down vote this one. Everybody should just go to Oracle where they already have the functionality. (devil)

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Sean Lange SSC Guru Points: 286590 More actions · Answer 8

+1 voted

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Jeff Moden SSC Guru Points: 1004290 More actions · Answer 9

SQLRNNR (11/26/2014)
I decided to down vote this one. Everybody should just go to Oracle where they already have the functionality. (devil)

😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Ed Wagner SSC Guru Points: 287026 More actions · Answer 10

I think you're going to get some votes on this one, Jeff. Hey, it's coming up on its 8-year anniversary in February and it has the support of more than one MVP. You can't expect Microsoft to act too quickly on something like this. 😛

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Jeff Moden SSC Guru Points: 1004290 More actions · Answer 11

Jeff Moden (11/26/2014)
SQLRNNR (11/26/2014)
I decided to down vote this one. Everybody should just go to Oracle where they already have the functionality. (devil)
😛

BWAAAA-HAAAAA-HAAAA!!!! I thought you were kidding... Note about the vote but about Oracle... you recommended a "DUAL" table??? :-D:-P:hehe: I sure do hope they don't take that part of the suggestion.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

LucyGlorius SSC Enthusiast Points: 120 More actions · Answer 12

LucyGlorius

SSC Enthusiast

Points: 120

November 26, 2014 at 10:24 am

#1761141

Voted - now it's at 156.

Luis Cazares SSC Guru Points: 183706 More actions · Answer 13

Jeff Moden (11/26/2014)
Jeff Moden (11/26/2014)
SQLRNNR (11/26/2014)
I decided to down vote this one. Everybody should just go to Oracle where they already have the functionality. (devil)
😛
BWAAAA-HAAAAA-HAAAA!!!! I thought you were kidding... Note about the vote but about Oracle... you recommended a "DUAL" table??? :-D:-P:hehe: I sure do hope they don't take that part of the suggestion.

I'm sure there's a table valued function in a RDBMS, but I can't remember which one is it or how is it called. It was mentioned once in a forum post. It wasn't Oracle and certainly wasn't the dual table.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

SQLRNNR SSC Guru Points: 281334 More actions · Answer 14

Jeff Moden (11/26/2014)
Jeff Moden (11/26/2014)
SQLRNNR (11/26/2014)
I decided to down vote this one. Everybody should just go to Oracle where they already have the functionality. (devil)
😛
BWAAAA-HAAAAA-HAAAA!!!! I thought you were kidding... Note about the vote but about Oracle... you recommended a "DUAL" table??? :-D:-P:hehe: I sure do hope they don't take that part of the suggestion.

Just an example that the big red machine has had it for some time and despite being a single value table, they have some very fast "numbers" tables that are built from it.

That said, they really don't need a DUAL table. A tally table is appropriate.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events