I am having problems with this portion:
--allow a valid NMSR Date to be inserted
if (@srdate is not null) and (@srcompletedate is null) and (@nmsrdate_delete is null) and (@nmsrdate is not null) and (@nmsrdate >= @srdate and @nmsrdate <= @currentdate)
update [Service Database] set [NMSR_Date] = @nmsrdate_delete where [Service Report No] = @srnum
When I try to change the current NULL value for the NMSR_Date column for that record to any date, the value return back to NULL when it should have taken the new value for the date.
Please help. Thanks.