I have inherited a website and porting to .net. this site queries some large census tables and then if requested by the user exports the data to excel. this was done originally with a lot of asp writes to excel looping through the dataset created by the query. I would like to just export straight from sql 2k5 when I pass the query.
I know some geniuses up here can tell me how to do that.