HaveTrouble
Programmer
I want to pull a report that will join multiple tables (around 4 tables. some from same database and some from different databases) and perform some simple calculation such as field A * field B. Say there are 50,000 entries in the main table. Which way is the most efficient way to pull report from ASP ? Should I just add the fields I need into the main table or create a view for it ? My main goal is not to stress out SQL server and achieve the maximum result. Any suggestion ?