Tuesday 3 April 2018

REMOVE THE \r\n FROM THE COLUMN VALUE IN SQL SERVER

AS SALAMO ALAIKUM WA RAHMATULLAH

REMOVE THE \r\n FROM THE TABLE COLUMN VALUE AND UPDATE.


Select replace(replace(mobile_slno,char(10),''),char(13),'')
from tbl_str_receipt_det
where mobile_slno like'%'+char(13) or mobile_slno like '%'+char(10)

begin transaction a
update tbl_str_receipt_det
set mobile_slno=replace(replace(mobile_slno,char(10),''),char(13),'')
where mobile_slno like'%'+char(13) or mobile_slno like '%'+char(10)
rollback transaction a

MA ASALAAM
Passion 4 Oracle

Monday 26 February 2018

E-Business Suit Fast Formula

As salamo Alikum wa rahmatullah

Fast Formula in E-business Suit, Please find at the following link

http://www.erpschools.com/articles/fast-formula


--
Ma Asalaam
Passion 4 Oracle


E-Business Suit (Error - Assignment Budget FTE is not equal to Position FTE Capacity)

As salamo alaikum wa rahmatullah

E-Business Suit Error 
Assignment Budget FTE is not equal to Position FTE Capacity
Solution at following link
http://students-of-oracle.blogspot.com/2012/12/position-fte-full-time-equivalent.html

Ma Asalaam
--
Passion 4 Oracle