Okay, thanks!  (Finally got the e-mail from my database!... where do they go when they get lost between my computer and gmail?) So I know the code works...
Guess...

I'll have a read. From a quick scan, I'd basically have to use a unique subject and search for that and the recipient's e-mail in the table, and if not...

like this?
CREATE TABLE [dbo].[ProductCodes](
    [F_Product] [char](1) NOT NULL,
    [F_TextCode] [char](7) NOT NULL,
    [F_Phrase] [varchar](5) NOT NULL
);
GO

INSERT INTO ProductCodes VALUES
('A','MANU001','TEST1'),
('A','MANU002','TEST2'), ...

no. my requirement was super simple. Essentially, when an employee is assigned a task/drug protocol/whatever, send him an e-mail advising him of it. I had asked about this maybe pre-Service...

Maybe they're waiting for you to post your plan for them to comment on?

Got context?

Oh, okay. That's what I was wondering. Thanks for the explanation. I was reading the documentation and it wasn't totally clear.

Thanks, Lowell (and everybody). That answers my question.

There query appears to be missing an alias:
SELECT o2a.SOURCE_ID source_id, o2a.VALUE 
FROM CR2Copy..OBJECT_TO_ATTRIBUTE

should be
SELECT o2a.SOURCE_ID source_id, o2a.VALUE 
FROM CR2Copy..OBJECT_TO_ATTRIBUTE AS o2a

How about some data? CREATE TABLE and INSERT scripts?
Why not do the CASE statement in an inner query, and then pivot that result?

DISTINCT is going to be brutal slow.
AND o2a.STATUS_ID = 33000000000001 AND o2a.PROPERTY_ID = 1000000060338
AND o2a.SOURCE_ID
and then are those columns indexed? (maybe included in PK index?)

Wait, if you want a cumulative sum, your formula is wrong. There's no ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW in there... Is there are hierarchy in this? Can you...

Go back and ask said DBA why he wants this. Sounds absurd. The nice thing about stored procedures is that you can assign rights to them. you can't do that...

If you have a Calendar table, this is infinitely easier. You would outer join Calendar to your Trips table and then aggregate on columns in the Calendar table (Year, Month,...

You need to calculate the month from the date. A date is just a number...

SELECT MONTH(start_date), COUNT(*) AS Count
FROM trips
WHERE YEAR(start_date) = 2016
GROUP BY MONTH(start_date);