SELECT CUS_SO_NO = CUS_NO+'-'+RIGHT(100000+ROW_NUMBER()OVER(PARTITION BY CUS_NO ORDER BY GETDATE()),5) FROM MF_POS where OS_ID='PO'
先感谢早上帮过我的大大们,
现小弟还有一个问题,就是如果将查询出来的数据,
更新到原来的字段?CUS_SO_NOFG12-00001
FG32-00001我原来的字段名也是 CUS_SO_NO
先感谢早上帮过我的大大们,
现小弟还有一个问题,就是如果将查询出来的数据,
更新到原来的字段?CUS_SO_NOFG12-00001
FG32-00001我原来的字段名也是 CUS_SO_NO
update
a
set
CUS_SO_NO=a.CUS_SO_NO
from
tb a,
(select
cus_no,
CUS_OS_NO=cus_no+'-'+right('100000'+row_number()over(partition by cus_no order by getdate()),5)
from
tb)b
where
a.cus_no=b.cus_no
update
a
set
CUS_SO_NO=b.CUS_SO_NO
from
tb a,
(select
cus_no,
CUS_OS_NO=cus_no+'-'+right('100000'+row_number()over(partition by cus_no order by getdate()),5)
from
tb)b
where
a.cus_no=b.cus_no