<div>
Depending on what version of SQL Server you have, you can even opt for creating a table variable. An inline index is allowed as well. Would just second Friedhelm and go with a table with joins and null / not null check.
</div>


<div>
Thanks for the replies. &nbsp;The GUIDs would change but not often. &nbsp;Due to the read only access, my plan was to track this list of &quot;excluded&quot; GUIDs in the VB.Net winforms application, and then generate dynamic SQL code or the temporary table.<br />
<br />
Sorry, I don't have access to the particular database at the moment. &nbsp;Can a temporary table be used/created if the DB user has read-only privileges?<br />
<br />
Also, just to confirm, the temporary table will be deleted from the database once that particular connection is closed, right?
</div>


<div>
Please mention the version of SQL Server, when you get it, very important. <br />
<br />
Our responses are not much around where you will stored GUIDs and dynamic SQL. It is to state that table + join approach is preferred over the in clause.<br />
<br />
If you have read only access, you will obviously will not be able to create a temp table. However, you can create a table variable, I believe.<br />
<br />
Temporary tables does automatically gets dropped when connection is closed.
</div>


<div>
I will be connecting to SQL Server 2008 and 2012 databases. &nbsp;If I need to request slightly elevated user rights from the DBA, do you know what specific rights I should mention to be able to create and use temporary tables? (Sorry, DB administration novice here)
</div>


<div>
You can use table variables. That's probably the best way.<br />
<br />
Unfortunately, I am not DBA either. To the best of my knowledge, db_reader and then db_writer role. While db_writer role will allow to you to perform CRUD (insert, select, update, delete) operations, it would still not allow to you create objects such as temp tables (I think!)<br />
<br />
As it turns out you need no special permissions to create a temp table as stated <a href="https://jasonstrate.com/2013/05/21/security-questions-what-permissions-are-required-to-create-temporary-tables/" rel="ugc">here</a>.
</div>


<div>
Thanks to all. &nbsp;Nice tidbits about adding an index, and no special permissions for temp tables.
</div>


<div>
<blockquote>
and go with a table with joins and null / not null check. 
</blockquote>
Nitin, can you clarify why you mentioned the null / not null check? &nbsp;I don't usually do that for SQL Joins.
</div>


<div>
The kind of insert into [tablename] values (),() syntax I have given above you can add maximum 1000 values in one go. You will need to add more 'insert into's for more batches of 1000 values each.
</div>


<div>
Thanks for the sample code, Nitin. &nbsp;I was actually considering using NOT EXISTS, but your code seems slightly simpler.
</div>


<div>
<div class="content wysiwyg-content">
Using &nbsp;VB.NET Winforms application: &nbsp;Essentially, I would like to generate a list of GUIDS to exclude from a query (anywhere from about 10 to 1000 GUIDS). &nbsp;I am looking to determine which of these is most efficient. &nbsp;Assuming that I have read-only access, can run SQL query code (but not create stored procedures). &nbsp;<br />
<br />
Options:<br />
1) &nbsp;Dynamically create a SQL WHERE clause to exclude the GUIDS (e.g. &quot;WHERE field1 is NOT IN ('GUID1', 'GUID2&quot;, etc...)&quot;<br />
2) Create temporary table in SQL, load the excluded GUIDS, then run the final query against standard tables JOINed with this temporary table<br />
3) Other?
</div>
</div>


Using  VB.NET Winforms application:  Essentially, I would like to generate a list of GUIDS to exclude from a query (anywhere from about 10 to 1000 GUIDS).  I am looking to determine which of these is most efficient.  Assuming that I have read-only access, can run SQL query code (but not create stored procedures).  

Options:
1)  Dynamically create a SQL WHERE clause to exclude the GUIDS (e.g. "WHERE field1 is NOT IN ('GUID1', 'GUID2", etc...)"
2) Create temporary table in SQL, load the excluded GUIDS, then run the final query against standard tables JOINed with this temporary table
3) Other?

SQL Server SQL Query Excluding Specific Field Values (Efficienct Code)

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.