Assume I have a query like select firstname, email from person. and the list I want to wrap into html and email to someone else. And I want to send it at 11:00 pm daily. In the condition, what is the best method I can use?
My database is SQL Server 2012 and I do have IIS.
I know asp.net/c# languages, and of course I can write Stored Procedures.