Not looping is "always" (yes, I know, there are some exceptions) faster than looping. If Kevin, Magoo, and Phil had not already posted their thoughts on this, I would have...

szejiekoh (3/30/2016)

---

I just got skeptical when committed data (though its previous versions) now are store in temp. Didn't want temp to grow bigger (just worried if there might be some...

Neither of these two forms is guaranteed to be faster than the other. But the plans will be different.

If you already have the values in a table, use form 1...

What Luis says. Create a small set of test data that illustrates the problem you are having. Anything above say a dozen rows is an indication that you either post...

$ecuR3

Option 1: (If the reports are SSRS reports)

Schedule them as subscriptions in SSRS

Option 2: (If the reports are not real reports but SQL stored procedures)

Schedule them as jobs in SQL...

I agree with what Jon says. The time data type is intended to store a time-of-day, not a duration. (I once worked for an employer who payd double for work...

To get a period of 100 days starting "now" (whenever now is), use a range that starts at "CAST(CURRENT_TIMESTAMP AS date)" and ends just before "DATEADD(day, 100, CAST(CURRENT_TIMESTAMP AS date))".

To...

I must admit that I did not fully analyze your tables. I will also add that I know nothing about how the UK police are organized.

But I did take a...

This sounds as if you're trying to build your own version of SSRS.

Why not use what is already there?

Frankly, I don't understand why anyone would be interested to compare performance between two queries that do not return the same results. At most one of them can be correct....

doasidont (3/29/2016)

---

Thanks. I'm very new to SQL Server and want to do this right to get the help I very much need. Where is the Text Mode of...

Would you have skipped to page 3 if they had mentioned CURRENT_TIMESTAMP instead of getdate()?

pietlinden (3/29/2016)

---

If you can, buy a copy of SQL Server Developer. It costs about $60 US, which is an absolute steal. While there is a cap on the size...

Because if you do, the question does not become whether someone will end up...