topic Re: Is it possible to join spatial features to a MS SQL view table? in New to GIS Questions https://community.esri.com/t5/new-to-gis-questions/is-it-possible-to-join-spatial-features-to-a-ms/m-p/134088#M336 <HTML><HEAD></HEAD><BODY><P>It looks like I must have been doing something wrong before, because I couldn't get it working at all last week. But, when I tried it this morning, and everything worked as it should! I didn't even have to export it.</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 17 Oct 2016 19:49:41 GMT EricHeinrichs 2016-10-17T19:49:41Z Is it possible to join spatial features to a MS SQL view table? https://community.esri.com/t5/new-to-gis-questions/is-it-possible-to-join-spatial-features-to-a-ms/m-p/134086#M334 <HTML><HEAD></HEAD><BODY><P>I am wanting to run a join from my spatial data (parcels) to a SQL view table (attributes for the parcels). Is this something that's doable, or would I have to try and figure something else out?</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 17 Oct 2016 12:10:04 GMT https://community.esri.com/t5/new-to-gis-questions/is-it-possible-to-join-spatial-features-to-a-ms/m-p/134086#M334 EricHeinrichs 2016-10-17T12:10:04Z Re: Is it possible to join spatial features to a MS SQL view table? https://community.esri.com/t5/new-to-gis-questions/is-it-possible-to-join-spatial-features-to-a-ms/m-p/134087#M335 <HTML><HEAD></HEAD><BODY><P>Yes it is doable as long as you have a matching attribute to link the two data sources to each other. It is possible once you get the SQL table in the GIS, you might have to export it to a .dbf or geodatabase table for the join to work correctly, but it is possible.</P></BODY></HTML> Mon, 17 Oct 2016 12:50:11 GMT https://community.esri.com/t5/new-to-gis-questions/is-it-possible-to-join-spatial-features-to-a-ms/m-p/134087#M335 RyanUthoff 2016-10-17T12:50:11Z Re: Is it possible to join spatial features to a MS SQL view table? https://community.esri.com/t5/new-to-gis-questions/is-it-possible-to-join-spatial-features-to-a-ms/m-p/134088#M336 <HTML><HEAD></HEAD><BODY><P>It looks like I must have been doing something wrong before, because I couldn't get it working at all last week. But, when I tried it this morning, and everything worked as it should! I didn't even have to export it.</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 17 Oct 2016 19:49:41 GMT https://community.esri.com/t5/new-to-gis-questions/is-it-possible-to-join-spatial-features-to-a-ms/m-p/134088#M336 EricHeinrichs 2016-10-17T19:49:41Z Re: Is it possible to join spatial features to a MS SQL view table? https://community.esri.com/t5/new-to-gis-questions/is-it-possible-to-join-spatial-features-to-a-ms/m-p/134089#M337 <HTML><HEAD></HEAD><BODY><P>Glad it worked! Sometimes if I do an attribute join and don't export the SQL table first, it will match the records, but all of the matched records will be null values for the attributes. But if I do a simple export, it works perfectly!</P></BODY></HTML> Mon, 17 Oct 2016 20:08:13 GMT https://community.esri.com/t5/new-to-gis-questions/is-it-possible-to-join-spatial-features-to-a-ms/m-p/134089#M337 RyanUthoff 2016-10-17T20:08:13Z Re: Is it possible to join spatial features to a MS SQL view table? https://community.esri.com/t5/new-to-gis-questions/is-it-possible-to-join-spatial-features-to-a-ms/m-p/134090#M338 <HTML><HEAD></HEAD><BODY><P>That's what was happening to me, as well. I want to maintain a "live" connection, so that every time something changes in the SQL database, my parcel attributes are instantly updated. I was able to run the join and publish the parcels, and it maintains all the attributes. Not sure why it worked this time, but I'm glad that it did!</P></BODY></HTML> Mon, 17 Oct 2016 20:14:23 GMT https://community.esri.com/t5/new-to-gis-questions/is-it-possible-to-join-spatial-features-to-a-ms/m-p/134090#M338 EricHeinrichs 2016-10-17T20:14:23Z