Published on InterSystems Developer Community (https://community.intersystems.com)

Home > How to get a Numbers View

Question
Drew Holloway · Feb 28, 2020

How to get a Numbers View

In T-SQL, I can create a recursive CTE to create a subquery or a view that will hold a whole lot of numbers.  Is there a way to do this in Cache SQL?  I'd like the numbers from 0 to 10000 if possible. 

Thanks!

#SQL #Caché

Source URL:https://community.intersystems.com/post/how-get-numbers-view