SELECT WaferID,SID,BagID+'-'+CONVERT( varchar, Row_Number() OVER (partition by BagID ORDER BY CONVERT(int, SID) asc)) as BagID FROM LMS_EPIStroeInfo
where BagID in ('G1-0020')
本文共 225 字，大约阅读时间需要 1 分钟。
SELECT WaferID,SID,BagID+'-'+CONVERT( varchar, Row_Number() OVER (partition by BagID ORDER BY CONVERT(int, SID) asc)) as BagID FROM LMS_EPIStroeInfo
where BagID in ('G1-0020')
转载于:https://www.cnblogs.com/gf0817/p/6018606.html