Sum up digits of a number in Sqlserver.

Input: 1234

Output: 1+2+3+4=10

DECLARE @str nvarchar(10), @length int

SET @str =’156045′

SET @length =LEN(@str)

SELECT SUM(convert(int,SUBSTRING(@str,number,1)))

from master..spt_values

WHERE type=’p’ AND number BETWEEN 1 and @length

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s