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

1 vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    0 comments

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

      Feedback and Knowledge Base