create an aggregate function

Why you're looking for create this function, you have one called ABS: https://msdn.microsoft.com/en-us/library/ms189800.aspx

Hello

Ok but how create this function?

Thanks

regards

you don't, it is created just use it

I know I can use it, a user asks me to create a function to use it. Thanks

have a look at https://msdn.microsoft.com/en-us/library/ms191320.aspx

That the user asked for it does not mean that giving it to him/her is the right thing to do :)

One example, taking the sum of the absolute values:

SELECT Location, SUM(ABS(Sales)) AS AbsSales
FROM SomeTable
GROUP BY Location

Select allOpen in new window

OTOH, if you wanted the absolute value of the sum:

SELECT Location, ABS(SUM(Sales)) AS AbsSales
FROM SomeTable
GROUP BY Location

Select allOpen in new window

have a look here this may help you: https://msdn.microsoft.com/en-us/library/91e6taax(v=vs.100).aspx

thanks regards