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
Tuesday, April 28, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment