Data Links

Permanently deleted user

April 13, 2016 17:38

Trying to get this SQL query to run. It is supposed to run an intersect on mapapp quads and assesor quads and return a value in the field PDFWebPath in the assessor quads field. My data link query is working with another data set so i know the data connection setup on SQL db is good. Can anyone spot an error in my sql query? Any help is appreciated

 

_img_ alt="User-added image" src="https://latitudegeo--c.na53.content.force.com/servlet/rtaImage?eid=906600000004InU&feoid=Body&refid=0EM600000004YGH" _/_img_

 

SELECT s.PDF_WEB_PATH  AS Assessor Maps

 

FROM   [SCD_GIS_PUBLISH].[SCD_GDBA].AGOL__ASSESSOR_QUADS s,

 

              [SCD_GIS_PUBLISH].[SCD_GDBA]. AGOL__mapapp_quads  p  

 

WHERE p.Shape.STIntersects(s.Shape) = 1

 

AND p.LABEL = @Label

0

• 

  Tom Neer

  April 13, 2016 17:49

  Shouldn't Assessor Maps be in quotes? 

  0
• 

  Permanently deleted user

  April 13, 2016 17:55

  That did it Tom! Thanks so much for the help.

  0

Please sign in to leave a comment.