The other day I was working on an OutSystems project and needed 10 random names from a table containing 1000 names. How could I write an Advanced SQL statement that could do this as simply as possible? During my research, I came across an interesting difference in behavior between two methods of generating random numbers in SQL Server.”