why what works? The ROW_NUMBER() OVER (PARTITION...) part?
PARTITION OVER is super simple - it's analogous to grouping in a totals/aggregate query, but you still get the individual records, which...

I find it hard to believe you've been coding this long (and asking questions) and can't write a simple correlated subquery.

Say I want to show all the details...

You could use
WHERE EXISTS  and correlated subqueries. It will slow things down, but right answers are better than fast answers.

Do you inherit these stored procedures or...

Thanks Sue. I'll have a look.
I may not have been thinking... probably the really simple answer is "Mark the optional parameters as optional!"  Yeah, "here's my sign!" =)

Could you explain what this does? (Is this Oracle?)
SELECT
@Od = :a2,
@Do = :a3,
@TipSobe = :a1,
@KodaCenika = :a4;

It's probably not a syntax issue. It's a permissions issue. If it were a syntax issue, the code would stop and you'd get an error message that the T-SQL "statement...

Welcome aboard!
since you appear to be new here, you owe it to yourself to read this article: 

December 31, 2017 at 12:33 am

#1973991

Note to self: last status check per computer
Without data, it's harder to see what's going on, but you could try this pattern.  I'm using AdventureWorks2014 for data.

Why would you want to do that? I can see shrinking a database if you have to move it and space is at a premium. But that's hopefully a rare...

Remove the s.StateDuration from the GROUP BY. You're SUMMING that... Your query should look like this:
SELECT s.AgentName
  , s.ReasonCode
  , Sum(s.StateDuration) AS 'StateDuration'
FROM (

Maybe this article by Jeff Moden will help...

This sounds like something you'd want to schedule with a job instead of using a trigger... well, at least to my mostly ignorant way of thinking. Then you could find...

I just did this earlier today. I downloaded the most popular firstnames and lastnames from some website... so they're in their own tables.  Then I did this (appended a partial...