- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
IF @Detail is not null
AND (SELECT
COUNT(AppraisalResponseID)
FROM AppraisalResponseHistory
WHERE AppraisalResponseID = @AppraisalResponseID) >0
BEGIN
INSERT INTO AppraisalResponseHistory
( AppraisalResponseID,
PermissionID,
AppraisalTypeQuestionPromptID,
Detail,
ModifiedDate,
PersonID )
SELECT AppraisalResponse.ID,
AppraisalResponse.PermissionID,
AppraisalResponse.AppraisalTypeQuestionPromptID,
AppraisalResponse.Detail,
AppraisalResponse.ModifiedDate,
PersonID
FROM AppraisalResponse
WHERE AppraisalResponse.ID=@AppraisalResponseID AND AppraisalResponse.Detail<>@Detail
END
ELSE
IF COALESCE(@Detail, '') = ''
--if the reviewer is inserting a blank record after having filled in a response, insert into history
--if the blank record is the place holder, do not insert into history
AND (SELECT
COUNT(AppraisalResponseID)
FROM AppraisalResponseHistory
WHERE AppraisalResponseID = @AppraisalResponseID) >0
BEGIN
INSERT INTO AppraisalResponseHistory
( AppraisalResponseID,
PermissionID,
AppraisalTypeQuestionPromptID,
Detail,
ModifiedDate,
PersonID )
SELECT AppraisalResponse.ID,
AppraisalResponse.PermissionID,
AppraisalResponse.AppraisalTypeQuestionPromptID,
AppraisalResponse.Detail,
AppraisalResponse.ModifiedDate,
PersonID
FROM AppraisalResponse
WHERE AppraisalResponse.ID=@AppraisalResponseID AND AppraisalResponse.Detail<>@Detail
END
If @Detail is not null or blank, I need to check if AppraisalResponse.Detail is blank or null (- I think this is where I am running into so much trouble). If it is blank or null then
I need to check if there is already a record in AppraisalHistory with this ID. If there is, I need to insert the blank record to history, otherwise not.
If @Detail is null.
I need to check if there is already a record in Appraisal History with this ID. If there is, I need to insert the blank record to history, otherwise not.
Даже описание скопипащено