emi_sastra
asked on
EXCEL MATH TO SQL
Hi All,
I have below excel math :
=FLOOR(LOG(Number,2),1)+1
How to convert it into MS SQL ?
Thank you.
I have below excel math :
=FLOOR(LOG(Number,2),1)+1
How to convert it into MS SQL ?
Thank you.
floor(log(number)/log(2))+ 1
you could also use log10 instead of log
ASKER
Hi sdstuber,
- floor(log(number)/log(2))+ 1
It works.
- you could also use log10 instead of log
How to do this ?
Thank you.
- floor(log(number)/log(2))+
It works.
- you could also use log10 instead of log
How to do this ?
Thank you.
floor(log10(number)/log10( 2))+1
ASKER
What makes it different ?
Would you please make correction of my code below ?
SELECT FLOOR(LOG(
SELECT COUNT(*) AS TotalMember
FROM TMMEMBERDATA) / LOG(2))+1
Thank you.
Would you please make correction of my code below ?
SELECT FLOOR(LOG(
SELECT COUNT(*) AS TotalMember
FROM TMMEMBERDATA) / LOG(2))+1
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great.
Thank you very much for your help.
Thank you very much for your help.