Basic totals query. Give it a try. Not like you can break anything.

Not sure who told you to put NO LOCK in all your queries, but don't unless you like...

(Maybe the OP should watch Grant Fritchey's videos on backup and restore on Youtube).

Seriously, though... if you don't understand how backups and restores and log files are related, you're in...

If you want people on here to do your work for you, are you willing to send your paycheck to them?

I can't see your data, so it's hard to tell. Can you post some sample data... CREATE TABLE script, INSERTS... so we have some idea what your data looks like?

Because someone who shouldn't have had rights to execute his own SQL statements instead of being limited to existing, properly written stored procedures etc?

Pretty sure you can tell Steve is joking when he says "Power BI".

(That said, I guess that explains why there's no section here for it)...

Forget about loops for a minute. What are you actually trying to accomplish? Please explain.

How to Resize tempdb — DatabaseJournal.com

Okay, I'm super confused. If your data is already in a tabular model, don't you use DAX (or maybe MDX) to query it? If the issue is DAX, read Rob...

So you create a statement on top of what you have and then get an average of the datediff results.

AFAIK, you'd have to roll your own median function. I'm sure...

Could you post some sample data and expected results?

I'd use a Calendar table for this kind of thing.

As it wasn't my database, I would assume FIFO, but then I could be wrong. <g>

Frederico, any pointers on how to do it without a cursor? The only way I...

Correct me if I'm wrong, but if I'm processing a series of work orders for products I need to build, then the only way to do it seems to be...

This gets the "new" customers.  Then you'd just join this back to the Transactions/Sales table and do a simple sum.

SELECT CustomerID
FROM Customer c
WHERE NOT EXISTS (SELECT 1
FROM...

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

Thanks... I think I'm going to read Itzik's book and watch some of Kendra Little's T-SQL courses on indexing and querying.

(Good time to have a normal job where people come...