Help Procedure files

[hameja]

Hi Pros,

Im Back again after a long spell in wilderness.

I this problem. Look at this script and advise

alter procedure mangoC_points @msisdn varchar(13), @balance int, @maxdateofcall datetime, @dateofcall datetime, @message varchar(20)
As if @msisdn = select msisdn from mango_points
where @dateofcall = dateofcall
and @msisdn = msisdn

Insert into mess_errors(msisdn)
select msisdn from mango_points where @msisdn=msisdn

update mess_errors set message = 'Duplicate Entry' where @msisdn = msisdn
Else ....

I want to select from this table b what is not in table a
table a is mango_points but before I insert a record.

 

[apexbs]

incomplete information about the problem, could you please explain your problems in details so that you would get proper response.