SELECT
b.FICMOBillNo AS rwno,
b.FWBBillNO AS 工序单 ,
b.FOperID AS col2 ,
b.FOperSN AS col1 ,
b.FItemID AS item ,
( SELECT FNumber
FROM dbo.t_Item
WHERE FItemID = b.FItemID
) AS FNumber ,
( SELECT FName
FROM dbo.t_Item
WHERE FItemID = b.FItemID
) AS Fname ,
( SELECT FName
FROM t_SubMessage
WHERE FInterID = b.FOperID
) AS gxname ,
'R接收' AS clas ,
b.FBasePassQty AS num ,
FLOOR(b.FBasePassQty) AS shuliang ,
CONVERT(VARCHAR(16), a.FDate, 120) AS date,
CONVERT(VARCHAR(16),c.FCheckDate1,120) AS 一审时间,
--RIGHT( CONVERT(VARCHAR(16),c.FCheckDate1,120),10)+' '+ LEFT(CAST(b.FBasePassQty AS VARCHAR(16)),3)AS num
--把时间列 列sun数量列合并为一列,数量转后字符后取'.'前面的数字字符
RIGHT( CONVERT(VARCHAR(16),c.FCheckDate1,120),10)+' '+SUBSTRING(CAST(b.FBasePassQty AS VARCHAR(16)),1,CHARINDEX('.',CAST(b.FBasePassQty AS VARCHAR(16)))-1),
RIGHT( CONVERT(VARCHAR(16),c.FCheckDate1,120),10)+' '+CAST(FLOOR(b.FBasePassQty) AS varchar(10))
FROM ICShop_SubcIn a INNER JOIN ICShop_SubcInEntry b ON a.FInterID = b.FInterID
INNER JOIN ICClassCheckStatus1002523 c ON c.FBillID=a.FInterID