SQL Server :: How To Get Output As A Whole When Uasge Of Loop In Stored Procedure

I have written SP like this to get my required output.create procedure [dbo].[usp_gl_ProjectBudgets] set nocount on begin tran declare @SPError int

declare @y1 varchar(20)
declare @y2 varchar(20)
declare @y3 varchar(20)
declare @y4 varchar(20)
declare @y5 varchar(20)
declare @Glink int
declare @i int
set @y1='Year1'
set @y2='Year2'
set @y3='Year3'
set @y4='Year4'
set @y5='Year5'
set @Glink=1
set @i=1
[code]...