一个奇怪的问题,语句如下
INSERT INTO TB_ITEMGATHER
SELECT '1234',V.ordercompany,AA.COMPANYNAME ,
V.BRANCHPLANT,S.W_PLANTNAME,
V.ITEMNUMBER ,I.DESCRIPTION,
V.CUSTOMERID,A.COMPANYNAME as Customer,
SUM(SHIPQUANTITY) as Shipqty,V.BAG
FROM VW_SALE_DETAIL V LEFT JOIN TONE_DJY_UID_PD..TB_ADDBOOK AA
ON V.ORDERCOMPANY=AA.ADDRESSNUMBER LEFT JOIN SYS_SYSTEM S ON
V.BRANCHPLANT=S.W_PLANTID LEFT JOIN TONE_DJY_UID_PD..TB_ADDBOOK A
ON V.CUSTOMERID=A.ADDRESSNUMBER LEFT JOIN TONE_DJY_UID_PD..TB_ITEM I
ON V.ITEMNUMBER=I.ITEMNUMBER WHERE V.WEIGHOUTDATE
BETWEEN '2013-06-03 00:00:00' and '2013-06-03 23:00:00'
and v.nextstatus='060' Group by
V.ordercompany,AA.COMPANYNAME,V.BRANCHPLANT,S.W_PLANTNAME,
V.ITEMNUMBER ,I.DESCRIPTION,V.CUSTOMERID,A.COMPANYNAME ,V.BAG
ORDER BY V.ITEMNUMBER,V.CUSTOMERID其中表格个字段的长度均符合标准,而且在测试机上测试通过,但是工作环境执行就提示字符或二进制将被截断,难道是SQL Server的版本问题吗?
INSERT INTO TB_ITEMGATHER
SELECT '1234',V.ordercompany,AA.COMPANYNAME ,
V.BRANCHPLANT,S.W_PLANTNAME,
V.ITEMNUMBER ,I.DESCRIPTION,
V.CUSTOMERID,A.COMPANYNAME as Customer,
SUM(SHIPQUANTITY) as Shipqty,V.BAG
FROM VW_SALE_DETAIL V LEFT JOIN TONE_DJY_UID_PD..TB_ADDBOOK AA
ON V.ORDERCOMPANY=AA.ADDRESSNUMBER LEFT JOIN SYS_SYSTEM S ON
V.BRANCHPLANT=S.W_PLANTID LEFT JOIN TONE_DJY_UID_PD..TB_ADDBOOK A
ON V.CUSTOMERID=A.ADDRESSNUMBER LEFT JOIN TONE_DJY_UID_PD..TB_ITEM I
ON V.ITEMNUMBER=I.ITEMNUMBER WHERE V.WEIGHOUTDATE
BETWEEN '2013-06-03 00:00:00' and '2013-06-03 23:00:00'
and v.nextstatus='060' Group by
V.ordercompany,AA.COMPANYNAME,V.BRANCHPLANT,S.W_PLANTNAME,
V.ITEMNUMBER ,I.DESCRIPTION,V.CUSTOMERID,A.COMPANYNAME ,V.BAG
ORDER BY V.ITEMNUMBER,V.CUSTOMERID其中表格个字段的长度均符合标准,而且在测试机上测试通过,但是工作环境执行就提示字符或二进制将被截断,难道是SQL Server的版本问题吗?
the object name 'TB_ADDBOOK ' contains more than the maximum number of prefixes.the maximum is 3.