Monthly Archives: June 2017

SQL With

Using mssql: pulling data out of air from the system tables:   select top 5 ROW_NUMBER() over(order by a.name) + 2014 as yr from sys.all_objects a above query gives you 5 rows with column yr with values 2015-2019 WITH ds … Continue reading

Posted in Uncategorized | Leave a comment