How to sum / values in part and underline through SQL

Dear Experts,
I have two fileds, which in need to sum

1. 100/98
2. 10/9

need to show result with under line

110/107

Please help
MehramAsked:
Who is Participating?
 
Éric MoreauConnect With a Mentor Senior .Net ConsultantCommented:
try this:

DECLARE @v1 VARCHAR(10) = '100/98'
DECLARE @v2 VARCHAR(10) = '10/9'

DECLARE @v1_1 INT
DECLARE @v1_2 INT
DECLARE @v2_1 INT
DECLARE @v2_2 INT

DECLARE @posv1 int = CHARINDEX('/', @v1)
DECLARE @posv2 int = CHARINDEX('/', @v2)

DECLARE @result VARCHAR(10)

IF (@posv1 = 0) OR (@posv2 = 0)
BEGIN
      SELECT 'invalid values'
END
ELSE
BEGIN
      SELECT @v1, @posv1, @v2, @posv2

      SET @v1_1 = CAST(SUBSTRING(@v1, 1, @posv1-1) AS INT)
      SET @v1_2 = CAST(SUBSTRING(@v1, @posv1+1, 99) AS INT)

      SET @v2_1 = CAST(SUBSTRING(@v2, 1, @posv2-1) AS INT)
      SET @v2_2 = CAST(SUBSTRING(@v2, @posv2+1, 99) AS INT)

      SET @result = CAST(@v1_1+@v2_1 AS VARCHAR) + '/' + CAST(@v1_2+@v2_2 AS VARCHAR)

      SELECT @v1_1, @v1_2, @v2_1, @v2_2, @result
END
0
 
Éric MoreauSenior .Net ConsultantCommented:
there is nothing built-in to do it. you will need to find the / to extract the 2 numbers of each fraction, add them and them concat back a string
0
 
MehramAuthor Commented:
can you help to build this
0
 
Éric MoreauSenior .Net ConsultantCommented:
your fields are stored as varchar(x)?
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>need to show result with under line
For starters, SQL Server is a database, and does not graphically render such as underscore.

If you need to perform math on two columns, I highly recommend running some code similar to Eric's above that searches for the /, writes the two numbers into two new columns, then you can SUM() normally.

Otherwise, Eric's T-SQL above is the correct answer (nice job btw).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.