Hi guys =D im having a trouble in finding median (in a monthly basis) with sql with microsoft sql server... can someone kindly help me =D because im stuck with this part =( below are my tables NSWVIC TABLE Region DateNum day_id month_id yearNum time_id TotalDemand RRP PeriodType Month Table Month_ID MonthName Thanks for the help =D Regards Jo