Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  .NET Inside SQL Server (2005)  distinct on a CLR table function

Author  Topic  lholden Starting Member 5 Posts Posted - 2008-05-16 : 05:08:31 I have written a table function, that returns data through the IEmunerator. If add a distinct clause to my T-SQL select statement: select distinct a,b from tableFunc() where does the distinct get executed? Does it resolve the enumeration back to sql memory and then call the distinct? does it/ can it do something clever and pass the distinction back to the enumerator? Would there be (in general) any benift/performance gain in pulling the data back to a temp table first and then issuing the distinct over the temp table? cheers lee