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

Not really. As a matter of fact, you don't need SQL Server at all to do any of this - as long as the data is already in Excel. The...

There's a standard way to deal with a many-to-many relationship - a junction table. Think Invoices and Invoice LineItems and Products.

CREATE TABLE LineItem(
    InvoiceNo INT,
    ProductID...

Sounds like you need something like
(Kid LEFT JOIN Suggestions) LEFT JOIN Complaints

But then you'd need KidID in Suggestions AND in Complaints. Otherwise, how do you know which...

I think I should be able to do this with SQL Server Express (provided I could even install it somewhere there). 10GB of space should be plenty for bare minimum...

Just a guess, but maybe because the file SSRS outputs is likely an XML file, so it's converting Word to a real Word file when it saves?

Okay, got it.  Thanks! I'll watch a video or two until I get my head around it. Just want to have some idea of what I might be doing before...

Matt,
Thanks for the pointers!

Okay, so I could basically use Access as a temporary "container" for the data, and then do something like...
1. export from SAP to...