![]() ![]() The resolution has nothing to do with how much data is used, it only impacts the number of points of data which are encoded (and thus determines part of the quality of the video output for a given bitrate). The bitrate determines how much data is used per second. Thank you so much guys.You are using the same bitrate for each video. Hi vijay and peso, both method worked for me. SO i changed it to"sum(cast(filesize AS Numeric(15,4))/1024/1024/1024)as totalsize"now im getting the result as 4.0863381167859435519sorry to ask again, how can i round it up to 2 decimal point as in 4.08. Before i saw your post i tried something like this"sum((cast(filesize as decimal))/1073741824)as totalsize" and my result was like 4.08633808563I tried your query and there was a bracket missing. Sum(cast(filesize AS Numeric(15,4)/1024/1024/1024)as totalsizeWithout brackets, your query was first dividing by 1024 then multiplying by 1024-Gail ShawSQL Server MVP I need to sum up the filesize of users and display the sum.How can i convert and display the sum of 4387672143 as 4.38 GBPlease help as im stuck.The sql i have now is SELECT top 15 a.domainname,a.transferdomainname, sum(cast(filesize/1024*1024 as bigint))as totalsize FROM tbl_mediafiles m,tbl_useraccounts a where a.accountid=m.createdby GROUP BY a.domainname,a.transferdomainname order by totalsize descAnd my results for filesize is in this format43844956162149193728 Can this be achieved in one sql using cast or i need to get this value and do a convert in asp.net. Hi, I have problem in converting a filesize field that stores file sizes in bytes. We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |