Home Forums Article Discussions Article Discussions by Author Discuss content posted by Suresh G. Kumar A simple T-SQL statement to create a list of lookup values RE: A simple T-SQL statement to create a list of lookup values
mmarovic
SSC Enthusiast
Points: 160
More actions
March 21, 2011 at 4:31 am
#1301176
I wrote an article about the problem in 2006. Besides the solution with table function, look at the third solution: http://www.sql-server-performance.com/articles/dba/list_random_values_p1.aspx