Home Forums SQL Server 2014 Development - SQL Server 2014 Please vote for the "built in Tally Table" function. RE: Please vote for the "built in Tally Table" function.

  • November 27, 2014 at 12:47 am

    #1761207

    Luis Cazares (11/26/2014)

    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.

    generate_series in Postgres I think: http://www.postgresql.org/docs/9.1/static/functions-srf.html

    Does int,bigint, and datetime.