Gerrit Mantel
Programs SQL_TABLE_VALUED_FUNCTION - fun_int_array

Main program

Namefun_int_array
Type_descSQL_TABLE_VALUED_FUNCTION
CommentSQLServer User-Defined Function

PURPOSE
Returns a table with integer values between given minval and maxval.

PARAMETERS
@minval INT Start number
@maxval INT End number
@array ([value] INT) Output table

EXAMPLES
SELECT * FROM dbo.fun_int_array(1,10);
SELECT * FROM dbo.fun_int_array(-10,10);
SELECT * FROM dbo.fun_int_array(YEAR(GETDATE())-9,YEAR(GETDATE()));

HISTORY
2020-08-27 - Created function
2024-02-09 - Changed history table

TAGS
<program>
<description>Returns a table with integer values between given minval and maxval</description>
<generic>1</generic>
<author>Gerrit Mantel</author>
<created>2020-08-27</created>
<lastmodified>2024-02-09</lastmodified>
</program>
DescriptionReturns a table with integer values between given minval and maxval
Minversion
Generic1
AuthorGerrit Mantel
Created2020-08-27 00:00:00
Lastmodified2024-02-09 00:00:00
Xp_cmdshell0
Ole_automation0
Subprogram_cnt0
Sourcecode