I'm a sql developer who hasn't used GIS before.
From what I can tell MapInfo (Exponare) keeps it's data in tab files.
I need to write views (in SQL Server) that will take 95% of it's info from a sql table but needs to join to the mapping data to collect the other 5%
The 2 datasets have a common key so that is fine.
Writing a query in mapinfo that selects data from a sql table is fine (via odbc) but the other way around?
Where would I start?
Linked tables within SQL (that isn't a sql table)??
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes. We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.