If I pull data from SQL server can that help in calculation speed? I mean is it faster then excel?
How hard is to write complex excel formula like: sumproduct on 100 cells pulling that from 200,000 rows on 4 sheets in SQL Language?
If I pull data from SQL server can that help in calculation speed? I mean is it faster then excel?
How hard is to write complex excel formula like: sumproduct on 100 cells pulling that from 200,000 rows on 4 sheets in SQL Language?
Last edited by jimstrongy; 04-23-2012 at 11:07 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks