Comments by Siddharth_Gupta (Top 1 by date)

I guess I figured a way around the problem, below is the code I used:
ALTER procedure [dbo].[project]

@N int

AS

BEGIN
declare @tbl table (ID int identity(1,1),x1 int, x2 int, x3 int, x4 int, x5 int, x6 int, x7 int, x8 int, x9 int, x10 int,sumall int)
declare @tbl1 table (ID int identity(1,1),ttl int)
declare @amount int
declare @T int
declare @x int, @y int
set @x=1
set @y=1
while @y<=@N
begin
set @T=@x*@y
insert into @tbl values(@T, @T*2, @T*3, @T*4, @T*5, @T*6, @T*7, @T*8, @T*9, @T*10,@T+ @T*2+ @T*3+ @T*4+ @T*5+ @T*6+ @T*7+ @T*8+ @T*9+ @T*10)
end
select *from @tbl
END


//If anyone has a better work around then please do share//