Can you collate when using 2 select statements???

[Paladyr]

Like this:

select * from table1 COLLATE SQL_Latin1_General_Cp1_CS_AS where field1 not in (select field2 from table2)

I've already re-written the query using a left outer join to pull the correct results but was wondering if it is possible to collate when selecting two tables.

 

[swampBoogie]

collate is not applicable at a table level. It is only meaningful for individual values.

What are you trying to accomplish?

 

[Paladyr]

I already know the query I need, this is it:

Select * from table1 LEFT OUTER JOIN table2 On table1.field1 = table2.field2 COLLATE SQL_Latin1_General_Cp1_CS_AS Where table2.field2 Is Null

How should that look if I do a select blah blah not in (select blah blah)???

 

[Paladyr]

Also, the above query works and returns the correct results. SHould it look like this:

select * from thompsonte01.projects where projid not in (select cStudy_Number from schedule.dbo.TIDNumber COLLATE SQL_Latin1_General_Cp1_CS_AS)

 

[Paladyr]

select * from thompsonte01.projects where projid not in (select cStudy_Number COLLATE SQL_Latin1_General_Cp1_CS_AS from schedule.dbo.TIDNumber)

Sorry I meant this