Skip to Content
0
Apr 28, 2009 at 06:35 AM

Stored Procedure Updation

22 Views

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