Could you try the steps in the following Article?

http://support.microsoft.com/kb/815154

How many values are in the table?

How often does the Status of these values change?

You could use a SELECT Statement with the IN Operator.

I backed out and in and inadvertently created a duplicate post.

I agree with you that the user_to_organization and user_custom_organization tables should be consolidated

You may need a user_organization_Type Column which is stored in the user_to_organization table which is a child to...

user_to_organization - Organizations that users have selected from our list -

user_id INT PK

organization_id INT PK

Do not use a surrogate key, use a composite key User_ID & Organization ID

The User_ID...

Excellent interpretation and explanation Gila Monster.

I started out creating ERD's by using pencil and sketch paper.

Then I would use a primitive word processing program.

After several years I was able to use System Architect and ERWin.

At...

Nice catch on the Company Name Issue.

The FEIN (Federal Employer Identification Number) which is equivalent to the SSN uniquely identifies a Company. That is the best approach to identify the...

I do not understand the criteria behind the following:

If the user does not select a COUNTY, The results should show:

VENDOR A

VENDOR C

You might want to elaborate on this. What are...

Do you have an ERD?

Hopefully I'm wrong but the design of the Database that you are working with as described seems a little ugly.

Could you provide the tables, attributes, relationships...

I did not state my intent correctly.

When I said Billing Address or Mailing Address I meant a separate table with an Address Type.

I have normalize beyond the 3rd Normal Form...

I had some painful experiences using various versions of ODBC Drivers with Oracle Versions 8i, 9i, 10g & 11i.

Yes, Thank you for correcting me. 🙂

CREATE OR REPLACE PROCEDURE procedure_name

[(parameter1 [mode] datatype1.

parameter2 [mode] datatype2,...)]

IS|AS

[local_variable_declarations; ...] ...

Perhaps the following articles may be helpful to your situation:

http://narfle.com/blog/labels/SQL%20Server.asp/

http://blogs.technet.com/b/sql_server_isv/archive/2010/11/30/trace-flag-834-and-when-to-use-it.aspx

http://blogs.msdn.com/b/psssql/archive/2009/06/05/sql-server-and-large-pages-explained.aspx

You are correct for I only included an anonymous block as opposed to a procedure.

A Procedure would In include DECLARE PROCEDURE MyProc

AS...

etc...