NickName:wgpubs Ask DateTime:2012-06-02T06:40:19 Is there a LookupSet equivalent in SQL Server 2008 ... NOT r2? Just spent the day figuring out how to properly use the LookupSet method only to find out it isn't supported on my production database which is NOT running SQL Server 2008 R2 (it is just running ol' SQL Server 2008). So, is there a way to re-produce the functionality so it will work with old SQL Server 2008? Thanks - wg Copyright Notice:Content Author:「wgpubs」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.Link to original article:https://stackoverflow.com/questions/10858190/is-there-a-lookupset-equivalent-in-sql-server-2008-not-r2 Answers Jamie F 2012-06-05T16:50:55 As Gordon Linoff points out in the comments, this can usually be implemented in the SQL query. If the datasource for your target of the LookupSet is similar enough to the the main query, then you can accomplish this with a Common Table Expression or a correlated subquery in SQL.",