http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660We had to use something similar to the UDF to pass an array in Oracle. We did an inner join rather than IN (the IN clause is the Devil). It was significantly faster doing it that way, but of course, even though you are returning a table from the UDF, you can't index it, so it doesn't have the same performance as joining 2 real tables. http://ayende.com/2629/sending-arrays-to-sql-server-xml-vs-comma-separated-values#comment4http://ayende.com/2629/sending-arrays-to-sql-server-xml-vs-comma-separated-values#comment4Wed, 11 Jul 2007 14:49:04 GMTNot sure if this will help, but this is a fantastic article on passing arrays in SQL: http://www.sommarskog.se/arrays-in-sql-2005.html#iterative http://ayende.com/2629/sending-arrays-to-sql-server-xml-vs-comma-separated-values#comment3http://ayende.com/2629/sending-arrays-to-sql-server-xml-vs-comma-separated-values#comment3Tue, 10 Jul 2007 22:27:16 GMTI used to be the king of sqlxml.. but I learned. Interesting experiment; I'll have to try it out. Ooddly enough, my sqlxml output to xslt to html web app is still in use now 6 years later. Still talk to them, and they are still happy with it. http://ayende.com/2629/sending-arrays-to-sql-server-xml-vs-comma-separated-values#comment2http://ayende.com/2629/sending-arrays-to-sql-server-xml-vs-comma-separated-values#comment2Tue, 10 Jul 2007 21:45:21 GMTWill it change anything if you INNER JOIN to the UDF instead of WHERE IN... I wonder... More crazy Ideas? create a SqlCLR that runs a Regex split, I wish that had regex support had come built in... it doesn't seem to be too much to ask. http://ayende.com/2629/sending-arrays-to-sql-server-xml-vs-comma-separated-values#comment1http://ayende.com/2629/sending-arrays-to-sql-server-xml-vs-comma-separated-values#comment1Tue, 10 Jul 2007 21:02:37 GMT