
[dbo].[git_baseline_update]
Create PROCEDURE git_baseline_update (@P_BASELINE_NAME NVARCHAR(100),
@P_ATTRIBUTE_NAME NVARCHAR(100))
AS
BEGIN
INSERT INTO ai_baseline_attribute_info(attribute_uuid,
column_name ,
attribute_type ,
attribute_format,
attribute_value_text ,
attribute_value_long ,
attribute_value_double )
select TOP 1 baseline_info.baseline_attrib_uuid,
@P_ATTRIBUTE_NAME,
3,
300,
NULL,
NULL,
10
from ai_baseline_info as baseline_info
INNER JOIN ai_baseline as baseline ON baseline.baseline_uuid = baseline_info.baseline_uuid
where baseline.baseline_name = @P_BASELINE_NAME
AND NOT EXISTS
(select * from ai_baseline_attribute_info where ai_baseline_attribute_info.attribute_uuid = baseline_info.baseline_attrib_uuid)
END
GO
GRANT EXECUTE ON [dbo].[git_baseline_update] TO [aiadmin]
GO