Hi all,
I have an UDF in Sales Opportunity Title named U_Stage and have an UDF in Sales Opportunity Stage Row
I need Updation Process after Adding Sales Opportunity from the Stage Row Udf to the Title UDF Through Sp _Transaction and My Query is
if @transaction_type IN (N'A', N'U') AND (@Object_type IN ('97'))
update OOPR SET U_stage=(SELECT Max(T1.U_Status) FROM OPR1 T0 ,[@stage] T1 WHERE T0.[OpprId] =@list_of_cols_val_tab_del and T1.Code=T0.U_status ) where OpprId=@list_of_cols_val_tab_del
begin
select @error=10 , @error_message = N' Updation Failed'
end
its Showing Error Updation Failed is there Any Correction Pls Help Me.
Regards,
Yusuf