无法解决我的查询中的排序规则冲突 [英] Cannot resolve the collation conflict in my query
问题描述
我正在尝试选择一个视图内部将它与 SQL Server 2012 中的另一个表连接,但显示此错误
I'm trying to select a view & inner join it with another table in SQL Server 2012 but it is showing this error
消息 468,级别 16,状态 9,第 18 行
无法解决SQL_Latin1_General_CP1_CI_AS"和Latin1_General_CI_AI"在等于操作中的排序冲突.
Msg 468, Level 16, State 9, Line 18
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation.
这是我的查询:
SELECT
vpr.PARTNUMBER, vpr.DESCRIPTION,
vpr.BUYER, vpr.[GL CLASS], vpr.[ABC CODE],
vpr.TODAY, vpr.DAY1, vpr.DAY2, vpr.DAY3, vpr.DAY4, vpr.DAY5,
vpr.[COO QTY],
ROUND(vpr.[QOH-MSTORE], 0) AS [QOH-MSTORE],
vpr.[QOH-COO], vpr.[QOH-SDV],
ABS(ROUND(vpr.TOPUPQTY, 0)) AS [TOPUPQTY],
(CASE
WHEN ABS(ROUND(vpr.TOPUPQTY, 0)) < vpr.[QOH-SDV] THEN ABS(ROUND(vpr.TOPUPQTY, 0))
WHEN ABS(ROUND(vpr.TOPUPQTY, 0)) >= vpr.[QOH-SDV] THEN vpr.[QOH-SDV]
END) AS [SDV TO PICK]
FROM
vw_PartsReport vpr
LEFT JOIN
(SELECT twudc.Description1
FROM tbl_WH_UserDefineCodes twudc
WHERE twudc.UserDefineCodes = 'SO'
GROUP BY twudc.Description1) AS [SOI] ON vpr.PARTNUMBER = Description1
WHERE
vpr.TOPUPQTY <= 0
有人可以告诉我我的查询有什么问题吗?谢谢
Can someone please advise me what's the problem with my query? Thanks
推荐答案
所以要么
on vpr.PARTNUMBER collate Latin1_General_CI_AI = Description1
或
on vpr.PARTNUMBER = Description1 collate Latin1_General_CI_AI
取决于哪个是哪种排序规则.尝试一个,如果不正确,请尝试另一个,您的帖子中没有所需的信息来告诉您是哪一个.
depending on which one is which collation. try one and if it's not right try the other, the required information isn't in your post to tell you which one it is.
这篇关于无法解决我的查询中的排序规则冲突的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!