SQLTeam.com | Weblogs | Forums

Limit output remove '0'

tsql
sql2008
sql2012
sql2014
sql2008r2

#1

I have the following SQL Script, Is there a way of changing it so that I do not get back any file on the list that is less then filesize 1024

select Sys.Name0, Sys.User_Name0, SF.FilePath, SF.Filename,

Sum(SF.FileSize/1024/1024) as 'Used Space'
from v_R_System Sys INNER JOIN v_GS_SoftwareFile SF on
Sys.ResourceID = SF.ResourceID
where SF.FilePath like '%'+'Users'+'%'
and SF.FileSize > 1024
AND RIGHT(FileName,4) NOT IN('.exe', '.dll', '.ico', 'msi', '.ini', '.log', '.xml', 'reg' )
Group by Sys.Name0, Sys.User_Name0, SF.Filename, SF.FilePath


#2

Are you saying that your "SF.FileSize > 1024" filter isn't working?