Unfortunately I am totally dumb when it comes to programming, and very new to databases (mainly because I studied geography), so :
I have a Microsoft SQL Database Server, and a ArcSDE geodatabase. I made a view in SQL Server Manager, which I can see it in my geodatabase (in ArcCatalog), as a table. Which is great. But I also need the geographic information not just the data from the tables.
So how can I create a feature class in my geodatabase from a view that I created in SQL Server Manager. I did select the "shape" field, but sadly it's not that simple:P
I use: Microsoft SQL Server 2008, ArcGIS 10.0, ArcGIS Server 10.
Thank you for you answers.