Thanks all. This gives me several ways to approach the problem.

Obsolete objects is such a huge issue. Is it technically feasible to track the last time any object was used or would the overhead of doing so be just too...

I think what you are doing is completely reasonable, you can certainly insert your relevant statistics into a table and email them yourself. I didn't meant to overwhelm you, just...

The sessions I create and initialize every time the procedure runs. It facilitates logging if you want to record the history of the process.

I do tend to do this...

If its more of an import status/validation I would go for the suggestion above by foxxo to use sp_send_dbmail.

Generally I use this pattern within a stored procedure.

-create an entry in...

I wish there was a 'retract my post function'....

How embarassing! Sorry to be a nuisance.

Excellent, I understand the code and the role of the the tally table. Thanks.

Thanks Jeff, when I don't understand the code I prefer that it performs well and is concise.

txtPost_CommentEmoticon(':-)');

Thank you all again. I had never used a tally table.

Please allow me to ask a question which will clearly demonstrate I am still trying to understand the solution.

What's the...

Sorry to answer my own question. I really did google this and I read the first 5 pages. On the sixth page I found

WHERE MyDate = DATEADD(dd, -DAY(DATEADD(m,1,MyDate)), DATEADD(m,1,MyDate))

Thanks all. I'll pursue the role based approach.

Thanks. This is resolved and the world has been spared a bit of duplicative data entry.

How can I incorporate this into a query?

CREATE TABLE #MyCalendar

(

YearMonth char(6),

BinaryCode int

)

INSERT INTO #MyCalendar VALUES ('201205',235673648)

CREATE TABLE #MyData

(

MyDate datetime,

MyData int

)

INSERT INTO #MyData VALUES ('5/1/2012',1)

INSERT INTO #MyData VALUES ('5/5/2012',5)

INSERT INTO #MyData...

Brilliant Mr. Miller you are exactly right.