there are 10 kinds of people: the one understands binary and other who does not!

PRINT '==>USER VISIT BAR CHART DB DIV5<=='
SELECT TOP 10* FROM
(
SELECT CONVERT(DATETIME,CONVERT(VARCHAR,[LoginDate],101)) LoginDate
,COUNT(*) LoginFreq
,LoginChart
=CASE
WHEN SUBSTRING(REPLACE(SPACE(COUNT(*)/10),' ','|'),1,200) =''
THEN '|'
ELSE
SUBSTRING(REPLACE(SPACE(COUNT(*)/10),' ','|'),1,200)
END
FROM [DB].[dbo].[UserLoginView]
WHERE
Application='DB'
AND MONTH(LoginDate) = MONTH(GETDATE())
AND YEAR(LoginDate)=YEAR(GETDATE())
GROUP BY CONVERT(DATETIME,CONVERT(VARCHAR,[LoginDate],101))
--ORDER BY 1 DESC
)X
ORDER BY 1 DESC