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, 11 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).

What if you modified the search to be something like

WHERE [TrackDate] > @SomeDateTime1 AND [TrackDate] <= DATEADD(day,1,@SomeDateTime1) 
OR [TrackDate] > @SomeDateTime2 AND [TrackDate] <= DATEADD(day,1,@SomeDateTime2) 

Then wouldn't you get...

Not sure what's wrong. I get what you're doing... Get the "start date" and "end date" sizes for each database on a given server, subtract, and get the growth.

Can you...

Where's your CREATE PROCEDURE statement? Sounds like you're trying to create a stored procedure that has a few parameters...

Where's your CREATE PROCEDURE statement? Sounds like you're trying...

How about a CREATE TABLE script and maybe some sample data?

How about posting the query? Pin the tail on the donkey isn't that much fun.

Please read this article:

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

Your post lacks several things that enable folks like me to help you:

1. CREATE TABLE and INSERT scripts so that we can see what you see.
2.  Given...

• This reply was modified 6 years ago by pietlinden.