--DECLARE Ouput variable
                       DECLARE @Min_Target Money, @Max_Target Money, @Min_Percenatge float ,@Max_Percenatge float

                       --Finding Min_Target
                       SET @Min_Target=(SELECT TOP 1 [GivenTarget] as Min_Target
                       FROM [Target]
                       WHERE  [Name] = @Name
                       AND Quarter = @Quarter
                       AND Mothod =@Mothod
                       and [GivenTarget] < @AchievedTarget
                       order by [GivenTarget] desc)
                       IF @Min_Target IS Null
                       SET @Min_Target=(@AchievedTarget)

                       --Finding Max_Target
                       SET @Min_Target=(SELECT TOP 1 [GivenTarget] as Min_Target
                       FROM [Target ]
                       WHERE  [Name] = @Name
                       AND Quarter = @Quarter
                       AND Mothod =@Mothod
                       and [GivenTarget] < @AchievedTarget
                       order by [GivenTarget] ASC)
                       IF @Max_Target IS Null
                       SET @Max_Target=(@AchievedTarget)

                       --Finding @Min_Percenatge
                        SET @Min_Percenatge=(SELECT TOP 1 [Percenatge] AS Min_Percenatge
                        from [Target ]
                        WHERE  [Name] = @Name
                        AND Quarter = @Quarter
                        AND Mothod =@Mothod
                        AND [GivenTarget] in (@Min_Target,@Max_Target))

                        --Finding @Max_Percenatge
                        SET @Max_Percenatge=(SELECT TOP 1 [Percenatge] AS Max_Percenatge
                        from [Target ]
                        WHERE  [Name] = @Name
                        AND Quarter = @Quarter
                        AND Mothod =@Mothod
                        AND [GivenTarget] in (@Min_Target,@Max_Target)
                        ORDER BY [Percenatge] DESC)

                        --Display Ouput
                        SELECT @Name, @Quarter,@Mothod ,@Min_Target, @Max_Target, @Min_Percenatge,@Max_Percenatge