set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgo/* GENERAL: Database..........: Boss Procedure name....: prSE_Customer_InvoiceFee_Activate Programming.......: Jonas Bolldén*/ALTER PROCEDURE [dbo].[prSE_Customer_InvoiceFee_Activate] @strCustomerId char(10)ASEXEC [dbo].[usp_LogProcCalls] @@PROCID declare @ContractId int declare @ErrorCode int declare @DateNow char(8) select @DateNow = convert(char(8), getdate(), 112) set @ErrorCode = 0 if exists ( select * from customer c (nolock) where 1=1 and c.customerid = @strCustomerId ) begin insert into customerflag(customerid,flagtype,registrationdate) values(@strCustomerId,68,@DateNow) end else begin /* Borde aldrig inträffa */ end