err#-2147467259
err desc:Transaction (Process ID 705) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
sql:SELECT ID FROM PropertiesFreeholdAndCondos WHERE Board IN(35) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-81.0190200805664 46.662043437704384,-80.97558975219727 46.66004060920042,-80.97713470458984 46.636354482873884,-81.00030899047852 46.63670808339624,-81.00374221801758 46.624684369375444,-81.00940704345703 46.6226801573477,-81.01764678955078 46.6227980542268,-81.01507186889648 46.64696149343766,-81.0190200805664 46.662043437704384)))', 4326).STIntersects(Geometry::STGeomFromText('POINT(' + CAST(Longitude AS VARCHAR(20)) + ' ' + CAST(Latitude AS VARCHAR(20)) + ')', 4326))=1) AND Status='A' AND IDX_Approved=1
Query String: PageAction=ViewSubCat&URL=/communities/valley-east/
Script Name: /index.asp