Skip to content

sistemes14.com

…apuntes del día a día

Tag: Union

T-SQL Generar un rango de números entre dos números

08/05/201908/05/2019 admin

T-SQL

Ejecutado en MS SQL Server 2014.

Como obtener un rango de números indicando el primero y el último:

	
declare @valorInicial int = 50
declare @valorFinal int = 350

;with genera as (
	select @valorInicial as num
	union all
	select num+1 from genera where num+1 < = @valorFinal
)
select * from genera
option (maxrecursion 1000)

Continue reading

Consultas, SQL SQL, T-SQL, Union Leave a comment

Archives

  • May 2019
  • March 2019
  • November 2018
  • August 2018
  • August 2016
  • June 2016
  • February 2016
  • September 2015
  • July 2015
  • June 2015
  • March 2015
  • February 2015
  • November 2014
  • October 2014
  • June 2014
  • May 2014
  • February 2014
  • November 2013
  • October 2013
  • August 2013
  • July 2013
  • June 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • July 2012
  • May 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011

Meta

  • Log in
Unite Theme powered by WordPress.