Clever Geek Handbook

Distance charts between links in SQL Server 2008 or Excel?

I would like the cross-reference to build a distance chart like the one shown (example is a road cross-reference chart) and ideally store the data in SQL Server 2008 (Express version preferred). He needs these properties / abilities.

  • Each column has a corresponding row with the same name (i.e. not misspelled like my example).
  • Changing the value at one intersection of the Row-Column will update the intersection of the mirrors (Column-Row), or the mirror data may be ignored.
  • Distance values ​​must be editable by end users.
  • The end user should be able to add, remove or rename a column / row pair.
  • The end user should be able to sort columns and automatically move rows.
  • There could be hundreds of pairs.
  • the search query should find the distance given for start and destination (row and column)

Distance chart is simple enough to implement in Excel. With that in mind, I'm better off ...

  • Using Excel as UI and then updating the SQL 'thing' with new data?
  • Using Excel as a data source even if it means performance issues when querying the data?
  • Using the yet undisclosed genius stroke detailed here in the answer?
0


source to share


1 answer


Of course it looks like an Excel application to me, start at the end. (Heh)



I can't imagine your users collecting enough data to improve performance. Excel will only accept 32757 rows by columns. If that's enough, I'd say you're golden.

+1


source






More articles:


All Articles