No Problem, Thanks for the response... I understand that the request i put forward was not correct , I was wondering if things had changed in sql server to the...

I like that...even simpler again....

Many Thanks....ill do some testing and use this solution...easier to read the sql script...which for my query is quite complicated

Thats interesting. You are correct ...there is a small chance that the numbers can be negitive.

Thankyou again

I see 🙂

Thanks again

Sorry I did not "see" you solution at all...my bad

Do you have the time to explain the logic of how/why it works

Many thanks

Hello There,

The solution proposed works as expected BUT I carnt use it as is.

I need to be able to perform a statement similar to the below

Select Name,Address, Function(Amount) as Amount.....

Many...

Thanks for that...

The number of rows I need to process is less than 1000 in the worst case...

Yes it would be possible to do on the front end but I...

Ok I have tried

SELECT ROUND(158.94,1,2) = 158.90...This is what I want

SELECT ROUND(158.97,1,2) = 158.90 This is NOT what I need I need to get 158.95

Just seem to be...

Yep..

158.94 should give me 158.90

158.95 should give me 158.95

158.96 should give me 158.95

158.97 should give me 158.95 etc

Thanks

Hello There

Thank you for your reply, Unfortuntaly im not able to get any of the suggetsions you offered to work in all examples. Perhaps I did not make my self...

Thanks very much for your help...Ill give it a try

Cheers

Andre

HI Again

Thanks for that...not exactly sure I understood what you said...still new to the real power of SQL.

I have decided to create a stored proceedure and access that from the...

Hi There

Thanks you so much for your help 🙂

Just one last question

Is it possible to save this query as a view?

Andre

Sorry That was remiss of me the ApplicationBuildingTypes table has a RowId (int) column which is the primary key

Hello Again

I have tried your suggetion on the live database and it works...many thanks....:-)

Now I need to be able to incorperate the result row returned by your suggestion into a...