[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL2005 Collation Conflict

Posted on 2012-08-27
1
Medium Priority
?
496 Views
Last Modified: 2012-09-02
I'm getting a
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

with this SQL statement.  I've had this message before but I'm not clear on where I need to place the COLLATE SQL syntax.

Thanks

select gm.[Tracking Number] as 'GMTrackingNumber'
from  udtGMFreightCosts gm
where gm.[Tracking Number] in (select [value] from KPRD.tms32.dbo.PACKAGE_ATTRIBUTES
      where [description]='Tracking Number' COLLATE SQL_Latin1_General_CP1_CI_AI)
0
Comment
Question by:jdr0606
1 Comment
 
LVL 9

Accepted Solution

by:
selva_kongu earned 2000 total points
ID: 38339627
Try this

select gm.[Tracking Number] as 'GMTrackingNumber'
from  udtGMFreightCosts gm
inner join KPRD.tms32.dbo.PACKAGE_ATTRIBUTES pa
ON gm.[Tracking Number] = pa.[Value] COLLATE SQL_Latin1_General_CP1_CI_AI
where [description]='Tracking Number'

Regards
SelvaS
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question