Unable to Create Query

• mumairkhan

  Newbie

  Points: 3

  More actions

  December 22, 2010 at 12:28 am

  #244652

  I have scenario for which i am unable to create query.

  I have to upate last 2 columns of table BluePoints using 1 update query, provided that i already have a function that returns distance between two points dbo.getdistance(x1,y1,x2,y2)

  for every blue point there is a nearest red point in table red points. how can i Update blue Points table respectively?

  table bluePoints

  PointName------x--------y--------distancefromNearestRedPoint---------redPointName

  AAA---------------7--------6--------NULL--------------------------------NULL

  AAB---------------6--------3--------NULL--------------------------------NULL

  AAC---------------4--------2--------NULL--------------------------------NULL

  AAD---------------9--------4--------NULL--------------------------------NULL

  AAE---------------5--------9--------NULL--------------------------------NULL

  table redPoints

  PointName-----x--------y

  ABA--------------6--------3

  ABB--------------5--------2

  ABC--------------4--------6

  ABD--------------8--------5

  ABE--------------2--------8

• sturner

  SSC-Insane

  Points: 22411

  More actions

  December 22, 2010 at 7:24 am

  #1265516

  sounds like a homework assignment.

  The probability of survival is inversely proportional to the angle of arrival.