Exact code used is this

Create proceduretest1

As

Begin

Declare@col1totalint

Declare@col2totalint

Declare@col3totalint

Declare @dynqrynvarchar(max)

Declare @counterint

Select@counter=1

While@counter<=3

Begin

Select@dynqry='Declare @col'+convert(varchar(5),@counter)+'total int'

Select@col'+CONVERT(varchar(5),@counter)+'total=SUM(col'+CONVERT(varchar(5),@counter)+') FROM Table1'

exec sp_executesql @dynqry

Select @counter=@counter+ 1

End

Select @col1total,@col2total,@col3total

End

But even if i declare and assign value after executing the query the output value is showing as null