I have to work with some data that unfortunately is not very friendly in terms of allowing to use SUM. This is what I am trying to do ...
SELECT SUM(CAST(BidValue AS decimal)) AS BidValue FROM Portfolios
BidValue is nvarchar data type. There is nothing I can do to change this, but the issue I am having is I need it to return the decimal places, not round the returned value up or down.
Is there another data type I need to cast to, or is there something I need to add to this?
Thanks in advance.