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 5 years, 9 months ago by pietlinden.

Yeah I get that this is a "Course requires Prerequisite" question, generally speaking. But what's your question?

how about explaining the real-world scenario you're trying to figure out? Something like "I'm...

And a whiteboard, while I'm thinking my way through it.  But #1 tool is my brain.

Check this out on Andy's website, CozyRoc

https://cozyroc.com/ssis/edi

EMail him and ask him if his EDI solution stuff will solve your problem. See if you can test it out. I just can't...

If you have some money, buy Andy Leonard's SSIS stuff that does this already. Then just use his. It would be hard to find someone that knows much more about...

There's nothing attached. But if it works when you run it under your account and not when it runs under a system account, there's likely a permissions issue causing the...

Maybe this will help:

https://www.databasejournal.com/features/mssql/article.php/3441031/SQL-Server-Undocumented-Stored-Procedures-spMSforeachtable-and-spMSforeachdb.htm

What if you create a dataset of (Strategic Shift,1)(Day case,2), (Same day EC,3), (Elective,4), (Emergency,5), (Non-Elective,6) and then sort by that? (Maybe you need to create a calculated column in...

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

Besides being out of support? (or is that 2008?) Kind of depends on how you use/what you use SQL Server for. Some of the new features may be part of...

WHERE datediff (YY, birthdate , Getdate()) % 4 = 0 ?