I am developing a sophisticated search engine for my website
which would aggregate complex data that is stored in various tables in a SQL
Server database. OLAP is out of question due to budgeting constrains, so we
consider developing our own stored procedures and implement reports with SSRS.
I am unable to find on the Internet a code generator which would let us explore
with our client various data retrieval scenarios. Has anyone come across a code
generator that can serve my purpose? Thanks in advance!

herman_joe said:

I am developing a sophisticated search engine for my website
which would aggregate complex data that is stored in various tables in a SQL
Server database. OLAP is out of question due to budgeting constrains, so we
consider developing our own stored procedures and implement reports with SSRS.
I am unable to find on the Internet a code generator which would let us explore
with our client various data retrieval scenarios. Has anyone come across a code
generator that can serve my purpose? Thanks in advance!

Hello! I am also a web developer and I was looking for a
code generator when I had to develop a database intensive project. I decided to
use OxyGen Code (http://www.techinceptions.com/codegenerator.html)
to generate our stored procedures and the data access layer. OxyGen Code gave
us a much needed productivity boost so we were able to focus on the business
rules and the UI rather than writing SQL and data retrieval logic. I would suggest
downloading OxyGen Code and giving it a try! Happy holidays!