Matjaz Justin (9/10/2010)
I would like to take advantage of a chance to join to the discussion with a question which is not directly related to the title but I cannot miss all of eminent professionals on this thread.My question is: is it possible to have CLR table-valued function with variable number of return columns?
Probably... but that can also be done in T-SQL quite easily (although it won't be in a function). Please see the following article for how...
http://www.sqlservercentral.com/articles/Crosstab/65048/
--Jeff Moden
Change is inevitable... Change for the better is not.