Skip to Content
0
Former Member
Jul 08, 2010 at 05:44 AM

SP with multiple udf's

14 Views

Dear All,

I have the following query which would block the addition of sales quotation if there is no value in row level udf U_Lot1. There are a few more udf's like U_lot2 and U_lot3 for which the requirement is same. Is it possible to get all these udf's in the same Sp or do i have to write different sp's for the udf?

IF @transaction_type IN (N'A', N'U') AND 
(@Object_type = N'23')
begin 
if exists(select T.docentry from QUT1 T where T.docentry = @list_of_cols_val_tab_del and 
T.[U_Lot1] IS NULL  )
begin 
SET @error = 14
SET @error_message = N'Please enter Lot Numbers for Item'
end
end    

Thanks,

Joseph