[dbo].[FillOutline]

Property	Value
ANSI Nulls On
Quoted Identifier On

SQL Script

-- =============================================
-- Author:        <Author,,Name>
-- Create date: <Create Date,,>
-- Description:    <Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[FillOutline]
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    SELECT document.doc_name, outline.order_num, outline.depth FROM outline JOIN document ON document.doc_id = outline.doc_id  ORDER BY outline.order_num

END
GO