I am trying to use the following if condition is this the right way using Or..
If @ExistingCriticalItem <> @NextCriticalActionItem or @RecCount = 1
BEGIN
UPDATE TABleActions set CRITICAL = '0' where ModuleRecordID=@ModuleRecordID
AND ModuleName = @ModuleName
UPDATE TABLeActions
SET
Critical = '1'
WHERE ActionID = @NextCriticalActionItem
END
Thank you for the helpful info.
If condition using or
Posted - 05/07/2009 : 06:08:25
