Tuesday, April 28, 2009

SQL SP for Update with the Condition cheking

ALTER PROCEDURE [dbo].[uspUpdateEmployee]
@UserName varchar(50),
@JoinDate datetime,
@PermantApprovedDate datetime,
@IsActive bit,
@EmployeeStatus int
AS

DECLARE @IsPermentEmployeeVal BIT
IF(@EmployeeStatus = 1)

BEGIN
SET @IsPermentEmployeeVal=1
END

ELSE
BEGIN
SET @IsPermentEmployeeVal = 0
END

UPDATE tblEmployees

SET
[LastModifiedDate] = Getdate(),
[PermantApprovedDate] = @PermantApprovedDate,
[JoinedDate] = @JoinDate,
[IsActive]=@IsActive,
[EmployeeStatus] =@EmployeeStatus,
IsPermentEmployee=@IsPermentEmployeeVal
WHERE UserName=@UserName

No comments: