CREATE PROCEDURE [dbo].[MssWebGetOrderWorkTickets]
    @inOrderId int
AS
BEGIN
    SET NOCOUNT ON
    SELECT DISTINCT WorkTickets.WorkTicketNumber as WorkTicketNumber
                from WorkTickets
                where WorkTickets.OrdersPriKey = @inOrderId

END
GO
GRANT EXECUTE ON  [dbo].[MssWebGetOrderWorkTickets] TO [MssExec]
GO