quote:

---

Originally posted by Lamprey

What have you tried so far? Can you post your DDL & DML (expected output would be nice too). Here are some links that can help you prepare that:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

---

ALTER PROCEDURE [dbo].[spCheckActivePaient]
-- Add the parameters for the stored procedure here
@MR varchar(50)
AS

-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON

-- Insert statements for procedure here


SELECT ~Active , LastName,Active
FROM Demographics 
WHERE MR=@MR

quote:

---

Originally posted by visakh16

ALTER PROCEDURE [dbo].[spCheckActivePaient]
-- Add the parameters for the stored procedure here
@MR varchar(50)
AS

-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON

-- Insert statements for procedure here


Thanks but where is the part that will determine if Active is true? And if it is true I want to update it to false????


SELECT ~Active , LastName,Active
FROM Demographics 
WHERE MR=@MR

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

quote:

---

Originally posted by rsquared

quote:

---

Originally posted by visakh16

ALTER PROCEDURE [dbo].[spCheckActivePaient]
-- Add the parameters for the stored procedure here
@MR varchar(50)
AS

-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON

-- Insert statements for procedure here


Thanks but where is the part that will determine if Active is true? And if it is true I want to update it to false????


SELECT ~Active , LastName,Active
FROM Demographics 
WHERE MR=@MR

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

---

quote:

---

Originally posted by visakh16

quote:

---

Originally posted by rsquared

quote:

---

Originally posted by visakh16

ALTER PROCEDURE [dbo].[spCheckActivePaient]
-- Add the parameters for the stored procedure here
@MR varchar(50)
AS

-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON

-- Insert statements for procedure here


Thanks but where is the part that will determine if Active is true? And if it is true I want to update it to false????


SELECT ~Active , LastName,Active
FROM Demographics 
WHERE MR=@MR

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

---

~Active will cause 1 to become 0 and 0 to become 1 . no need of any checking conditions. ~ is unary not operator

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

ALTER PROCEDURE [dbo].[spCheckActivePaient]
-- Add the parameters for the stored procedure here
@MR varchar(50)
AS

-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON

-- Insert statements for procedure here


UPDATE d
SET Active = ~Active 
FROM Demographics d
WHERE MR=@MR

declare @test table
(
i bit,
r int
)
insert @test
values (1,123)

insert @test
values (0,110)

insert @test
values (1,234)

select i,~i
from @test
where r=123

output
-------------------
i	Negatedi
-------------------
1	0