/*
*    Sets the status of an Xml System Request (in the XmlSystemRequestQueue table).
*    @param @inXmlSystemRequestQueueId Primary key of a XmlSystemRequestQueue record.
*    @param @inStatus Name of a status from the XmlSystemRequestStatus table.
*/

create procedure [dbo].[SetXmlSystemRequestStatus]
    @inXmlSystemRequestQueueId int,    
    @inStatus nvarchar(12)
as
begin

    declare @requestStatusId int
    select @requestStatusId = XmlSystemRequestStatusId from XmlSystemRequestStatus where [Name] = @inStatus
    update XmlSystemRequestQueue set
        XmlSystemRequestStatusFId=@requestStatusId
    where XmlSystemRequestQueueId = @inXmlSystemRequestQueueId

end
GO
GRANT EXECUTE ON  [dbo].[SetXmlSystemRequestStatus] TO [MssExec]
GO