ALTER procedure [dbo].[usp_assignedto]
(
@employeeid int,
@issuetrackerid int,
@testerid int
)
as
begin
set nocount on
if (status !=1) or (status !=2)
begin
update issuesdetails set assignedto = @employeeid , testerassign=@testerid where issuetrackerid=@issuetrackerid
end
begin
update issuesdetails set assignedto=@employeeid,status =2 , testerassign=@testerid where issuetrackerid=@issuetrackerid
end
end
First of all the "if (status !=1) or (status !=2)" this condition is not working , if i pass the parameter @status It works but I am not passing any parametr from front end so I cant pass this parameter . So Please give substitute for this also .
I tried using this , the previous issue of updating the status label for all the issue is resolved but now I cant update the status , On submit click no change occur.
Please give me some solution
[edit]Urgency deleted - OriginalGriff[/edit]