Skip to Content
0
J S
May 13, 2020 at 09:11 AM

SBO_SP_PostTransactionNotice

100 Views Last edit May 14, 2020 at 11:39 AM 2 rev

Hi

I have below code but it is still allowing Null value

IF @object_type = N'30' AND ( @transaction_type = N'A' OR @transaction_type = N'U')                                                 
BEGIN
	if exists(Select T0.[TransId] from OJDT T0
	where (T0.[U_Deptt] is Null or T0.[U_Deptt] = '')
	and T0.[TransId]=@list_of_cols_val_tab_del)
	begin
		Select @error = 1, @error_message = 'Select Deptt'
	end
End

Thanks