|
當產品編為前二碼xx時更改庫別MAxxx
張貼日期 2012/5/5 17:18:41
作者 lutuni
|
1. UPDATE [Leader].[dbo].[INVMB] SET [MB017]='MA101' WHERE SUBSTRING([MB001],1,2)='01' 2. UPDATE [Leader].[dbo].[INVMB] SET [MB017]='MA102' WHERE SUBSTRING([MB001],1,2)='02' 3. UPDATE [Leader].[dbo].[INVMB] SET [MB017]='MA201' WHERE SUBSTRING([MB001],1,2)='03' 4. UPDATE [FLUXTEK_1].[dbo].[INVMB] SET [MB017]='MA401' WHERE SUBSTRING([MB001],1,2)='31' 5. UPDATE [FLUXTEK_1].[dbo].[INVMB] SET [MB017]='MA301' WHERE SUBSTRING([MB001],1,2) BETWEEN '04' AND '30' 6. UPDATE [FLUXTEK_1].[dbo].[INVMB] SET [MB017]='MA301' WHERE SUBSTRING([MB001],1,2) BETWEEN '32' AND '44'
|
|