Change in Query

• Dohsan

  SSCrazy

  Points: 2972

  More actions

  May 13, 2015 at 7:47 am

  #1797544

  I'm guessing it's due to the underlying columns being of INT datatype

  SELECTServerName = @@SERVERNAME,

  TotalSpaceMB = SUM(CA1.total_bytes),

  AvailableSpaceMB = SUM(CA1.available_bytes),

  --Integer Maths will return 0

  SUM(CA1.available_bytes) / SUM(CA1.total_bytes),

  --Decimal

  SUM(0E + CA1.available_bytes) / SUM(0E + CA1.total_bytes),

  SUM(0E + CA1.available_bytes) / SUM(0E + CA1.total_bytes) * 100

  FROMmaster.sys.master_files AS MF

  CROSSAPPLYmaster.sys.dm_os_volume_stats(MF.database_id, MF.file_id) AS CA1;

• serg-52

  SSCrazy Eights

  Points: 9913

  More actions

  May 13, 2015 at 7:52 am

  #1797550

  See the difference

  DECLARE

  @total INT = 5

  ,@free INT = 4

  SELECT @free/@total*100 AS INTEGER_ARITHM

  , (0.+@free)/@total*100 AS NUMERIC_ARITHM

  You also may convert it explicitly using exactly precsion you need.

• Sgar...

  SSCarpal Tunnel

  Points: 4409

  More actions

  May 13, 2015 at 8:55 am

  #1797574

  Thank you Very Much. It worked.

  Sagar Sonawane
  ** Every DBA has his day!!:cool: