New motto: hidden feature, crouching bug

I guess it is that time of the year

!Rant .. I need some quick help and didnt know where to go.. so fellow ranters please help...

So I have created an sql trigger which is supposed to add a kill to a doctor whenever one of his patients changes state to "killed" . But I dont know how to just get the one row that is updated. As it looks now : The doctor get patientKilled ++ for every patient he ever had before as well... How can I solve this ?

USE [AD17_Hospital]
GO
/****** Object: Trigger [dbo].[PatientKilled] Script Date: 2017-10-21 19:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[PatientKilled] ON [dbo].[Patient]
AFTER UPDATE
AS
BEGIN
declare

SET NOCOUNT ON;
UPDATE Doctor set PatientsKilled+=1

FROM Doctor d
INNER JOIN inserted p
ON d.DoctorId= p.DoctorId
where p.PatientState='Killed'
END

I have a pun ban on work this week, apparently I have used it all up. They are always bringing me down..

Mr Null, please stop using my app.

Still missing my devRant sticker...

Hate working Mondays because I can't be any where near people or social media due to spoilers of got.....

!rant

What's your definition of brogrammers?

It should be illegal to have a 12 year old documentation for an c++ API... even though it's my fault I suck at c++ ...

Bluesoleil , the only Bluetooth you are giving me is a rather unpleasant story..

Facebook.
I fucking hate Facebook now.
Adding ads to all their videos, real classy.
Especially when it can show the same ad twice in the same video...
Facebook, I AM OUT.

!devrant

What the fuck is wrong with walking deads CGI??? Did they lose all their budget or something?

DEER WALKING DEAD DIE

Reading devrants all day about what not to do!

Where can I find some brogrammers?

Its time.

Just met an old friend for lunch, and after telling her about my new app she asked if I can make websites and stuff....

Throwback - don forget when CSI showed us how to protect us from being hacked!

https://youtube.com/watch/...

Is it socially accepted to develop Android apps on a Mac?

Asking for a friend

Facebook messenger app be like:

"Something went wrong, please try again"

No shit,when you r trying too make another snapchat app...

I had a teacher telling me I was not allowed to Google in my Android project....