on 2016 May 24 8:20 AM
Dear All,
Bill of Material update alert needed, because to update FG standard cost. Please help me
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SELECT Code FROM OITT T0
WHERE T0.UpdateDate IS NOT NULL
AND CONVERT(VARCHAR(10), T0.UpdateDate, 101) = CONVERT(VARCHAR(10), GETDATE(), 101)
BOM UPDATION ALERT:
select code,updatedate
as UpdatedOn,(select U_NAME from OUSR where UserSign2 in (select UserSign2 from AITT where UpdateDate='2011-09-19')) UpdatedBy
from AITT A1 where UpdateDate=
(select CONVERT(varchar(10), GETDATE(),121))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.