When U have multiple items (an array) U can use an xml (create an xml on web server) and send it to the SQL server.

The SQL has the capability of...

True, the data need to be cleaned.

And "There's just no need to do 2 derived tables and a union and an inner join to query from a simple nn table,...

the solution is simple, but Remi Gregoire just did not tested it's own code.

IF OBJECT_ID('tempdb..#Test') IS NOT NULL DROP TABLE #Test

CREATE TABLE #Test (

 PKtest int IDENTITY (1, 1) NOT NULL...

yes, OPENQUERY may force it to execute as remote, but ... you must be very good at chosing what you wanna do

SQL Server has the posibility of runnig a subquery ....

sorry, missed a Group by

select raccount AS raccount, MAX(Classification) AS Classification

FROM (... ) a

GROUP BY raccount

HAVING COUNT(*) = 1

if you are not...

having your select

SELECT a.raccount,

b.Classification

FROM master_tix_header a,tblProductType b

WHERE revent = Event AND (master_tix_header.ryear >= 1999 AND master_tix_header.ryear <= 2002)

GROUP BY raccount,Classification

with the results

10100004.0 N

10100004.0 O

10100004.0 P

10100004.0 M

10100005.0 O

10100007.0...

/* creating the date (if not available) */

IF OBJECT_ID('tempdb..#T1') IS NOT NULL DROP TABLE #T1

CREATE TABLE #T1 (T1_ID INT, T1_Col VARCHAR(256))

INSERT INTO #T1 SELECT 1, 'field1'

INSERT INTO #T1 SELECT 2,...

U're loosing the poit here, the all thing is about this question is that it is not recomandet to use "NULL" in a "not in" list

So, forget the "ansi_nulls", "rules...