Paid by the line

-- Created By : <No longer here>
-- Date : 12 April 2013
-- Description : Get <table2> items from <table2>


ALTER PROCEDURE [dbo].[<table>_GetByApplicationId]
    @ApplicationID BIGINT,
    @IsActive BIT = NULL
AS
    BEGIN

        IF ( @IsActive = 0 )
            BEGIN
                                -- Only Get inactive <table> items
                SELECT  <COLUMNS...>
                FROM    <table1> dcrp (nolock)
                        JOIN <table2> psh (nolock) ON psh.ProcessInstanceID = dcrp.ProcessInstanceID
                WHERE   dcrp.ApplicationID = @ApplicationID
                        AND psh.IsActive = 0
            END
        ELSE
            IF ( @IsActive = 1 )
                BEGIN
                -- Only Get active psh items
                    SELECT  <COLUMNS...>
                    FROM    <table1> dcrp (nolock)
                            JOIN <table2> psh (nolock) ON psh.ProcessInstanceID = dcrp.ProcessInstanceID
                    WHERE   dcrp.ApplicationID = @ApplicationID
                            AND psh.IsActive = 1
                END
            ELSE
                BEGIN
                --Get all psh items
                    SELECT  <COLUMNS...>
                    FROM    <table1> dcrp (nolock)
                            JOIN <table2> (nolock) ON psh.ProcessInstanceID = dcrp.ProcessInstanceID
                    WHERE   dcrp.ApplicationID = @ApplicationID
                END
    END