Friday 27 December 2013

SQL SERVER Query

select max(a) from
(
Select
(
  SELECT Max(v)
     FROM (VALUES (Theatre), (ClassRoom), (UShape),(Cabaret),(
DinnerDance),(Reception))
   AS value(v))as a
FROM PropertyMeetingRoom
)t