If @NextCriticalActionItem <> @ExistingCriticalItem
			BEGIN
				UPDATE TAB_ccsNetActions set critical = '0' where ModuleRecordID=@ModuleRecordID 
					AND ModuleName = @ModuleName

				UPDATE TAB_ccsNetActions
				SET
					Critical =  '1'
				WHERE ActionID = @NextCriticalActionItem

			END

quote:

---

Originally posted by cplusplus

I am having problem with the following If condition in my SP:

following are the value's i am getting:

@ExistingCriticalItem = empty

@NextCriticalActionItem = 111

		SET @NextCriticalActionItem = (SELECT TOP 1 ActionID From Tab_ccsNetActions
				WHERE COMPLETEDATE IS NULL and 
						ModuleRecordID=@ModuleRecordID AND ModuleName = @ModuleName
				ORDER BY DUEDATE)

		Set @ExistingCriticalItem = (Select TOP 1 ActionID from Tab_ccsnetActions where Critical='1' 
			and completeDate is null and ModuleRecordID=@ModuleRecordID AND ModuleName = @ModuleName)




		If @NextCriticalActionItem <> @ExistingCriticalItem
			BEGIN
				UPDATE TAB_ccsNetActions set critical = '0' where ModuleRecordID=@ModuleRecordID 
					AND ModuleName = @ModuleName

				UPDATE TAB_ccsNetActions
				SET
					Critical =  '1'
				WHERE ActionID = @NextCriticalActionItem

			END

Thank you very much for the help.

---