TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Goran Bibic
480
2.9k
200.3k
Multiply columns MS SQL
Jun 1 2018 3:51 AM
Query is ok
In table mp_racun_roba (down in query) i have column name kolicina
1) I need to multiply this three column with kolicina
2) In sum column if have value with thousand separator not sum (example 1,644.00) just jump that value
SELECT SUM(isnull(cast(REPLACE(TRY_CONVERT(
float
,TRY_CONVERT(
float
,iznos_bpdv),1),
'#,0.00'
,
''
)AS decimal(10,2)),0.00)) as UKUPNObpdv,
SUM(isnull(cast(REPLACE(TRY_CONVERT(
float
,TRY_CONVERT(
float
,pdv),1),
'#,0.00'
,
''
)AS decimal(10,2)),0.00)) as UKUPNOpdv,
SUM(isnull(cast(REPLACE(TRY_CONVERT(
float
,TRY_CONVERT(
float
,iznos_sa_pdv),1),
'#,0.00'
,
''
)AS decimal(10,2)),0.00)) as UKUPNOsapdv
from mp_racun_roba
where tip_robe=
'Roba (Generalno)'
and id_fakture=
'34'
Reply
Answers (
4
)
Split string based on values
How to Create Batch File for BackUp