How can you get a non whole number answer if everything starts and ends on the hour? Because each room is effectively for two meetings at once?

Andy,

I created the table and added the insert scripts... (although the table really needs indexing!)

If you really need help, help us help you. Read this link: How to post code...

• This reply was modified 5 years, 8 months ago by pietlinden. Reason: my code was wrong

Like this?

SELECT dbname
 , [type]
 , CAST( ((SUM(Size)* 8) / 1024.0) AS DECIMAL(18,2) ) AS SizeMB
FROM
(SELECT DB_NAME(database_id) as dbname,
  [Type] = CASE WHEN Type_Desc = 'ROWS' THEN 'Data File(s)'
      WHEN Type_Desc =...

StopType is either (P)ick or (D)rop

(That's why I was doing the CASE WHEN StopType = 'D' THEN -1 ELSE 1 END part... to convert those pickups to positive numbers and...

So you just want a total number of passengers picked up during the whole route - doesn't matter when they get on or off? then you'd just count the PassengerIDs...

It's the "who's the conductor of the train?" joke, but you really want the number of passengers on the train at any point.

I wouldn't count the bit column, personally. I'd...

I guess I answered this question, the one you explicitly asked instead of the one you intended:

I'm trying to get a running total of how many riders are on the...

• This reply was modified 5 years, 8 months ago by pietlinden.

Not a clue what Modulo has to do with this. Sounds like you want a running total of riders boarding minus a running total of riders leaving the bus.  Maybe...

Post your SQL statements here... nobody's going to download files from people they don't know.

How about doing something like BCP OUT to write the records to some manageable number of text files, and then use BULK INSERT to insert each file of, say, 100K...

Couldn't you use TOP with OFFSET to get a fixed size chunk of records and insert that way? (So modify to do the insert in chunks?

use AdventureWorks2017;
GO
DECLARE...

Jo,

It was in a painfully obvious place. Right-click on the gray area (not on the report), and select "Report Properties" from the context menu. It's under there.

So then you can...

Oh, they hid the variable declaration stuff... I should have known. Good to know it's there...

Why not schedule a job and have it run in the middle of the night when nobody's using the database?

You can run R code from within SQL Server (Python too, now).