Thank this author by sharing:
By Federico Iori, 2012/11/14
We have a table DIM_ESHOP_PHONE, containing a column Color_RGB in RGB Hex Format . We want to reduce the color to a given palette of colors, contained into the table DIM_COLOR . We simply associate the RGB code to the palette using the minimal cartesian 3d distance , defined as
POWER( Power((R-Ro),2)+Power((G-Go),2)+Power((B-Bo),2) , 0.5) .
It works.
I love my Kindle, but it uses an older e-ink technology that's a little slow and doesn't support col...
How to creat a color parameter
Power is a limited resource, but one that's required for computing. Microsoft has a new idea for gen...
Alternating Group Colors and Alternating Row Colors After posting my recent blog about Alternating ...
POWER function and BIGINT
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
