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

Sounds like you need this article: Crosstabs and Pivots by Jeff Moden...

db_owner is a ROLE, not a schema.
https://technet.microsoft.com/en-us/library/ms180977(v=sql.90).aspx

The default SCHEMA is dbo.

Having a "date purchased" column in Stores doesn't make any sense, unless you were recording the date the store was purchased. Normally, if a column doesn't describe the "subject" of...

Maybe watch this video... I watched it several times when trying to get my head around subreports. You can download their sample database so you can work along with the...

here's one solution using LAG. Requires SQL Server 2012 and later.

use tempdb;
go

create table #data(ProductID INT
                , LocationID CHAR(4)
                , EventDate DATE
                , Qty...

Couple things jump out as odd... First:
dt_close_time VARCHAR(23)

Why not use a DATETIME datatype?
Second, there seem to be only two records that meet the criteria (or did...

Use ROUND?
SELECT Amount,ROUND(Amount,0) AS rounded
FROM Green;