无法解决我的查询中的排序规则冲突 [英] 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屋！