It sounds like "IN" is what you want. If I have a list of values, i.e. ('Apple', 'Orange') and I want to know if they are in the FRUIT table, I would write: SELECT Name FROM FRUIT WHERE Name IN ('Apple, 'Orange'). This would pull back all values from the fruit table that are in my list. However, there is no logical way to use this with an "AND", because a string can only match one value. If you're looking for the value 'AppleOrange' you might use the LIKE operator: SELECT Name FROM FRUIT WHERE Name LIKE '%Apple%' This would pull back values "Apple" and "AppleOrange" I don't think there's a way to use the LIKE operator with a list though. Hope that helps a bit.

Can anyone comment on the performance pros/cons of using table-valued functions vs. Stored Procedures in SQLServer? Specifically: 1) are the execution plans for the functions stored as they are in stored procedures? 2) When using table variables inside the function, does the entire result set automatically wind up in memory, or can it be streamed using a reader? Thanks for any input.

After much travail, I've finally got my ASP.NET project referencing all of its components when they're stored in the GAC - with one exception. For some reason, the compiler cannot find the "MyApplication.DLL", into which all of the Code-Behind assemblies are compiled. I've verified that this file is strong-named properly, and the entry into the web.config file is identical to all of the others. A couple of hours worth of research hasn't turned up any reason why this file might be different from other DLLs, but I was hoping someone might have a suggestion. Any help is greatly appreciated.

Thank you! I'm reviewing now, but at the very least this is giving me some great ideas.

We have a system requirement for an ASP.NET application to prompt the user to save any changes before leaving the page. This is in a system with 30+ pages that are editable. We're multi-tiered, and all of our pages inherit from a base page, where we are able to put common functionality. Additionally, we have our own navigation 'toolbar', from which users can save the page that they're on, navigate to other pages within the application, etc. This toolbar is in a separate frame from the editable windows. So, specifically, if a page has a combination of controls, such as a text box, a drop-down list, and maybe a couple of checkboxes, can we mark the page as "changed" when the user interacts with those controls? Can this be done in a central location for all pages or does it have to be on a per-control basis? I had thought maybe monitoring the state bag on the page between Postbacks would work, but didn't want to explore that too deeply if someone has a better idea. We would really rather not have to change every page in our application if there's a way to do this cheaply. "Forgetting what is behind and straining toward what is ahead, I press on toward the goal to win the prize for which God has called me heavenward"

Another Link under .NET Framework had it: http://www.codeproject.com/script/comments/forums.asp?msg=1071155&forumid=12076&XtraIDs=1649&searchkw=GAC&sd=1%2F29%2F2005&ed=4%2F29%2F2005#xx1071155xx

Thanks, but distribution is what I'm trying to test at this point. We've already got the development environment running and compiling together with the strong-named assemblies. It's when I try to test how the application works with its core dlls in the GAC that I'm running into trouble. One thing that I'm doing that may not be right is I'm using the Windows Explorer add-on to install the dlls to the GAC, not GACUtil. I wouldn't think that's the problem, because I get the same failures when I use the InstallShield distribution. So I figured it has something to do with how we reference the DLLs. Thanks for looking and responding! Kerry

All Happy Now! We have an existing ASP.NET app (C# backend) that was originally written with weakly named backend objects, distributed to our customer's via traditional "XCOPY" (actually InstallShield, but just dropping files in the right location), so that all of the necessary DLL's are installed in the /bin directory of the default website. This works fine for just one app. Now, we are in the process of adding additional applications to our existing one, and in order to do that, we are strong-naming our components and trying to install them to the GAC, so that they can be globally referenced. I have successfully strong-named all of our components, and can put them into the GAC without issue as well. However, when I remove the /bin directory after having placed the components in the GAC, I get "Object Not Found" errors when trying to run the app. Is there something I need to change in the way my .DLLs reference each other, so that the app will search the GAC when loading? This is somewhat urgent as we are midway through the design process and starting to reconfigure our existing code. If our distribution plans are misinformed, we need to know now so we can lay a better path. Thanks for any help we can get!

Again, much gratitude. All this will take a while to digest, but at least I've got more directon :)

Help! We're getting ready to deploy and I'm trying to build a Launcher application that will run on non-.NET platforms (COM or Win32). Is there any way to build or compile a VB .NET application to output COM or Win32 code, or do I have to re-write this thing in Visual Studio 6 or InstallShield? We're shipping tomorrow! Please help!