--First lets create a functin will return the sumup values for you .. 
--Function Starts here.. 

Create  Function SumCol(@Val int )
returns Int 
As 
BEgin 
Declare @Qry Varchar(100),@Cnt Int,@SumVal Int 
Select @Qry = Cast(@Val as Varchar),@Cnt =0,@SumVal = 0
While (@Cnt <=Len(@Qry))
Begin 
	Select @SumVal = @SumVal + Cast(SubString(@Qry,@Cnt,1) As Int),@Cnt = @Cnt+1
	
End 

Return @SumVal

--Now lets create a view 

Create View VwSumColValues
As 
Select Col1,Dbo.SumCol(Col1) As Col2 From TblTmp 

End 

create function sumdigits(@i int)
returns int 
as
begin
	declare @n int,	
		@c int
	select 	@n = 1000000000

	select @c = 0
	while @n > 0
	begin	
		select 	@c = @c + @i / @n
		select  @i = @i % @n,
		select  @n = @n / 10
	end
	return @c
end