Home Forums SQL Server 2005 T-SQL (SS2K5) column update based on calculation and group by RE: column update based on calculation and group by

  • April 25, 2013 at 5:26 am

    #1609877

    Thanks Abu,

    But I need the Perc column to be updated to 67 where DeliveryDate = '2013-04-25'

    because ((2/3) * 100) = 66.6666 (rounded = 67).

    Thanks for your help though, 🙂