Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Include Generate Series

It'll be great if SQLServer has an equivalent feature like Generate series [PostgreSQL], which generates the sequence number for a given top & bottom value.

Source:
http://www.postgresql.org/docs/9.1/static/functions-srf.html

For Example
Query:
Select * from GetScaleRange(1,5)

Output:
1
2
3
4
5

Thanks
Manjunathan R

3 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base