Hi

I have a table (see below) that has an AutoNotify field of type bit in it.
What I would like to do is create a SPROC that will change the AutoNotify
field.

If AutoNotify is 'Off' then turn it 'On' and vice versa.  I will need to
pass in the EmployeeID to make sure only the relevant one is changed.

Thanks

Tim
****************************************************************************
**************
CREATE TABLE [dbo].[EmployeeInfo] (
 [EmployeeID] [smallint] IDENTITY (1, 1) NOT NULL ,
 [FirstName] [varchar] (50) NOT NULL ,
 [LastName] [varchar] (50) NOT NULL ,
 [Email] [varchar] (70) NULL ,
 [Address] [varchar] (100) NULL ,
 [City] [varchar] (50) NULL ,
 [Province] [tinyint] NOT NULL ,
 [PC] [varchar] (12) NULL ,
 [Country] [varchar] (50) NULL ,
 [TimeStamp] [smalldatetime] NOT NULL ,
 [AutoNotify] [bit] NOT NULL
) ON [PRIMARY]
GO

AS

UPDATE EmployeeInfo
  SET AutoNotify = ~ AutoNotify

HTH,

Tim

Wow, it looks pretty simple, but I would never have guessed that!

Thanks Tim