Scott, the Transactions table is the parent and ID is its primary key and clustered index. ID is the foreign key in TransactionDetails pointing to Transactions so it is...

Excellent. That looks just right. Thanks!

Exactly what I needed. Simple and effective. Thanks!

Thanks Keith. I watched Kendra's videos. Good stuff. I will work on implementing this solution.

I did go ahead and try this with SSIS. I think I realized the answer to my problem. There is no such thing as the null value in...

Perfect. thanks much

Understood. I won't add any more requirements.

The table:

Some data:

INSERT INTO Table_1

(Curr_date,Action,Duration)

SELECT 'Mar 29 2013 7:05AM','SignOn ...

I want to push my luck and add one more wrinkle. Say the Curr_Date column is DATETIME and the output of the MyAverage CTE express is grouped by HourOfDay...

That's nice and elegant. Thanks!

Starting a sql statement with WITH is new to me. I will have to look into that closer but it works great.

Thanks for that thought. I do already have a final step in the SSIS job that deletes these temp files. My problem was, while the job ran, the...

This is resolved. Someone suggested I simply logon to the server with the account that runs SQL, open IE, and change the folder for Temp Internet Files to a...

That worked like a charm. I logged on to the server with the SQL process account and changed the IE cache folder to a larger drive. Thanks for...

Thanks. I will be trying this. Actually I think I won't need that article's Solution 1 or Solution 2. I can logon to the server with the...

Thanks for this article. It may be a while before my company is ready to use AO groups but I will definitely refer to your article when that time...

Thanks for the response. Yes, the FTP task within the SSIS package writes the temp files to the account's IE temp folder. I do not know why the...