Well its two statements after the else so it will commit the transaction but not do the command after the commit.

>Um.....probably not - but since I had to look at it twice to decide yea or nay, I probably should.
>
>
>>Hi Dorris
>>
>>just a guess but do you need
>>
>>BEGIN
>>END
>>
>>around the statement block after your else.
>>
>>
>>
>>>Hi gang
>>>
>>>What I'm trying to do is create a stored procedure that will
>>>
>>>1) Check for existance of a record for a particular SCN
>>>2) If it exists, check to see if this is a restarted test
>>>
>>>For whatever reason (which means I have no clue), the following SP runs with no error, but doesn't produce a result either.
>>>
>>>

>>>USE [DLI_Testing]
>>>GO
>>>SET ANSI_NULLS ON
>>>GO
>>>SET QUOTED_IDENTIFIER ON
>>>GO
>>>
>>>ALTER PROCEDURE [dbo].[TestStart] 
>>>
>>> @Subbank		nchar(1),
>>> @SCN			Nchar(7),
>>> @TCN			nchar(3),
>>> @TestSection	nvarchar(1) OUTPUT,
>>> @TestRestart	nvarChar(1) OUTPUT,
>>> @ErrMsg		nvarChar(100) OUTPUT
>>> 
>>>AS
>>>BEGIN
>>>  declare @iError int, @iRowCnt int, @RecExists int, @TotQst int
>>>  --SET NOCOUNT ON;
>>>  select @RecExists = 1 where @SCN not in (select SCN from TestResult)
>>>  if @RecExists = 1
>>>    Begin
>>>      begin transaction
>>>      Insert into TestResult (Subbank,SCN,TCN)
>>>        values('E0' + @Subbank, @SCN,@Tcn)
>>>      select @iError = @@error, @iRowCnt = @@rowcount
>>>      if @iError > 0 or @iRowCnt < 1
>>>        begin
>>>         Set @ErrMsg = 'Initial Insert Fails ' + @iError
>>>         raiserror('Error on Initial Insert into Result -  %d',16,1, @iError) 
>>>         rollback transaction
>>>         Return
>>>        end
>>>      else
>>>        commit transaction
>>>        Select @TestSection = 'L', @TestRestart = 'F'
>>>    end
>>>  else	--Record already exists
>>>    begin
>>>      select @TestSection = 
>>>        Case (ListenTotal + ReadTotal)
>>>          when 25 then 'R'
>>>          when 0 then 'L'
>>>          when 50 then 'F'
>>>        end,
>>>        @TestRestart = 
>>>          Case (ListenTotal + ReadTotal)
>>>            when 25 then 'T'
>>>            when 0 then 'F'
>>>            when 50 then 'F'
>>>          end
>>>      from TestResult where SCN = @SCN
>>>    end   
>>>END
>>>

>>>
>>>Have at it
>>>Dorris