Share this Hotel


 
Arithmetic overflow error converting nvarchar to data type numeric.select name, tipo = case when [type] = 'Institution' OR [type] = 'Park' OR [type] = 'Marina' OR [type] = 'Museum' OR [type] = 'Stadium or Arena' OR [type] = 'Popular Area' OR [type] = 'Beach' OR [type] = 'District' OR [type] = 'Attraction' then 1when [type] = 'Business Area' OR [type] = 'Convention Centre' then 2 else 3 end, url from CityLocations where CityID = 11401 and Latitude < 10.115663 and Latitude > 9.955663 and Longitude < 105.865835 and Longitude > 105.705835 order by tipo