IF else in sqlserver storeprocedure

See more:

SQL-Server-2005

SQL-Server

 USE [Laboratory]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[pr_Patient_Insert]
	@iErrorCode int OUTPUT,
	@LASID int OUTPUT,
	@PatientName varchar(50),
	@Age int,
	@AgeUnit char(1),
	@Sex char(1),
	@DOB datetime,
	@Priorty char(1),
	@EnterBy int,	
	@Shift char(1),	
	@PatientType char(1),
	@Relation varchar(4),
	@RelativeName varchar(30),
	@PH# varchar(15),
	@Email varchar(50),
	@ReferBy varchar(30),
	@PUID int=null,
	@PenalID int,
	@CashReceiptNo int,
	@CashReceivedBY varchar(30),
	@TotalAmount float,	
	@DiscountPtage int,
	@DiscountBy int
	AS
SET NOCOUNT ON
-----------
declare @seed int, @newSeede int;
set @seed = IDENT_SEED('Patient');
set @newSeede = YEar(Getdate())%100*1000000;
if (@seed <> @newSeede)
	BEGIN
		DBCC CHECKIDENT ( Patient, RESEED,@newSeede )
	End
if( @PUID is null)
	BEGIN
		select @PUID= Max(LASID)+1 from Patient
	END
------------
INSERT INTO [dbo].[Patient] (
	[PatientName],
	[Age],
	[AgeUnit],
	[Sex],
	[DOB],
	[Priorty],
	[EnterBy],	
	[Shift],	
	[PatientType],
	[Relation],
	[RelativeName],
	[PH#],
	[Email],
	[ReferBy],
	[PUID],
	[PenalID],
	[CashReceiptNo],
	[CashReceivedBY],
	[TotalAmount],	
	[DiscountPtage],
	[DiscountBy])
	 VALUES (
	@PatientName,
	@Age,
	@AgeUnit,
	@Sex,
	@DOB,
	@Priorty,
	@EnterBy,	
	@Shift,	
	@PatientType,
	@Relation,
	@RelativeName,
	@PH#,
	@Email,
	@ReferBy,
	@PUID,
	@PenalID,
	@CashReceiptNo,
	@CashReceivedBY,
	@TotalAmount,	
	@DiscountPtage,
	@DiscountBy
)
SELECT @iErrorCode=@@ERROR
-- Get the IDENTITY value for the row just inserted.
SELECT @LASID=SCOPE_IDENTITY()
--endregion

this is my store procedure when i excute this procedure
the

DBCC CHECKIDENT ( Patient, RESEED,@newSeede )

part of code

if (@seed <> @newSeede)
    BEGIN
        DBCC CHECKIDENT ( Patient, RESEED,@newSeede )
    End

excute every time and reseed the column either the condition of if statment is true or false
when i comments the line "DBCC CHECKIDENT ( Patient, RESEED,@newSeede)"
then it works properly
plz help me what i am doing wrong
thanks
My identity field in table is LASID and i want to autogenerate the value but want to start from 0 every year with year postfix means in 2011 it start from 11000000 and in 2012 it start frme 12000000 for 2013 start will be 13000000 ect how can i do this.