I wrote an algorithm that maximized profitability based on the sum of independent variables (sale items) that equaled a particular goal.  For example, I want a 5% increase in my gross...

I am using Reporting Services.  It's not bad.  It has some limitations as it a "version 1" from Microsoft and cannot directly hold up to Crystal Reports.

However, I like that...

I agree with Aaron.  See if the application is sending one insert at a time with an open and close connection for each insert.  That will defintely slow things down. ...

What account do you have SQL Agent running under?  Is it running under a local administrator account or a windows domain adminstrator account?

I wonder (and this is just a guess)...

Check the data types of each field.  You may have implicit conversion going on here where the minus operator is not performing a math function.

Yes, this can be done.

You need to have the OLEDB provider for Exchange and create a remote server connection to Exchange from SQL Server. 

start here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/wss_references_wss.asp

I'm not sure about what you can configure.  Check there first.  If you cannot, here's my two cents on it...

I think you will most likely have to write your own aspx/asp...

Here's my code for calling CDONTs from SQL Server.  I wrote this a long time ago, so it may not be the best code.  Feel free to optimize it.

First, I created...

One thing to try is to create a stored procedure that calls CDONTs and sends the mail.  This way, you can schedule it to run as a job async and...

Triggers are a great way to enforce data rules that are difficult to enforce via constraints, unique indexes, or default values.

You can use stored procedures for this, as well.  But,...

I needed a similar function where I used DTS to let users of a VB.Net application import Excel or text files into tables. 

Instead of writing scripts for each table,...

I am not sure I totally understand you schema.

However, you may want to simply add a field into the table as an identity column.  SQL Server will auto increment that...

Check to see what account SQL Agent runs under.  Most likely, it does not have permission to execute the job.