Ahmad Osama
SSCertifiable
Points: 7676
More actions
April 1, 2008 at 5:15 am
#71535
Hi All,
How can I create and operate on a 2D matrix.
Do we have an inbuilt function to get minimum of more than values from a set not from a table col.
select min(1,2,4)
Regards,[font="Verdana"]Sqlfrenzy[/font]
Todd Engen
SSCrazy Eights
Points: 9869
April 1, 2008 at 6:43 am
#796421
You could turn the list into a table and use aggregate functions.
This article has details on how to do that: Arrays and Lists in SQL Server
April 2, 2008 at 5:38 am
#797116
y they have not incorporated the concept of array in TSQL like that in other programming languages....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply