I have a prototype ASP/Access website that needs to be redesigned for SQL Server. There are 3 stored procedures needed that can support thousands of users. The queries seek to find connections between users (so user A knows user B who knows user C, so therefore user C knows user A _via_ user B in 2 steps). It's a bit like the game six degrees of kevin bacon (see [url removed, login to view])
While not particularly tricky, it does require a history of designing databases for large sites and familiarity with recursive / tree-walking type queries.
The attached zip file contains a Word document ([url removed, login to view]) outlining the necessary queries, sample data, expected results and so forth.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
ASP + MS SQL Server