The AVI format is very flexible because you have a choice of several different compressors to balance file size against quality. This article discusses three popular file formats, and some ways in which you can significantly reduce file sizes using Digital Media Converter Pro.ĪVI stands for Audio Video Interleaved. Today, there are lots of video formats available. Though the Internet bandwidth available is always increasing, and storage devices like large hard drives and DVDs become less expensive every year, a typical video continues to take up 'too much space'. They can also be almost impossible to distribute over the Internet. They fill up your hard disk, slow down your PC, and gets too big to copy to other computers. Video files are among the largest files there are on a PC. These three words ring especially true for video files. 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 kommentar(er)
