Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.40K
Re:
My query below has been working okay for 1 year now and suddenly it is giving an exception: [CODE] (SELECT distinct(R.imei),R.mobile,S.msg,S.reply,M.model, left(S.receiveTime,10) as receiveDate, right(S.receiveTime,8) as receiveTime,'' as 'Reason' from dbSAMSUNGmain.tREGDATA R,dbSAMSUNGmain.tMODELS M,dbSAMSUNGmain.tSMS_TRANSACTIONS S where S.mobile=R.mobile and replace(replace(S.msg,'/',''),' ','') LIKE concat('%',R.imei,'%') and (S.reply like '%Registration successful%' || S.reply like '%Reg … |