View Single Post
  #6 (permalink)  
Old October 19th, 2004, 04:35 AM
sudhakaratp sudhakaratp is offline
Registered User
Join Date: Dec 2003
Location: Bangalore, Karntaka, India.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts

Hi Ananth,
This is the query that I am using. Here, I have two databases. Intranet..Events is in collation Compatibility_52_409_30003
Pewcentral..staff is in collation SQL_Latin1_General_CP1_CI_AS
So, I need to get the count of records and here is the query that I am using.
Can you make out any difference in the query that you had sent me and the query that is here. When I run this query, i am getting the error invalid syntax near collate.

Select Count(*) as TotRec
FROM Intranet..Events E LEFT OUTER JOIN PewCentral..staff P on E.EditedBy collate SQL_Latin1_General_CP1_CI_AS = P.Initials

Thanks & Regards