Approximate word-count

0

Please login or register to vote for this query.

(click on this box to dismiss)

An approximation of total word-count entered. Will be thrown off by lots of code, so may be less accurate for StackOverflow.

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

-- Approximate word-count
-- An approximation of total word-count entered. Will be thrown off by lots of code, so may be less accurate for StackOverflow.

DECLARE @UserId int = ##UserId##

Select u.Id , 
   (sum(coalesce(len(p.Body),0))) as "Char count"
from Users as U, Posts as P
Where u.ID=@UserID AND p.OwnerUserId = u.Id
Group By U.ID

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results