Can you post a CREATE TABLE script and the INSERT scripts for this?
And maybe fix up your SQL so we can read it?

This should get you started. Since you're new here, I created your table and added some data. If you want a tested answer, you should provide this.
CREATE...

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...