set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go /* GENERAL: Database..........: Boss Procedure name....: prSE_Customer_InvoiceFee_Activate Programming.......: Jonas Bolldén */ ALTER PROCEDURE [dbo].[prSE_Customer_InvoiceFee_Activate] @strCustomerId char(10) AS EXEC [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