I'll also add that 60 minute sessions just aren't long enough to do the job right for a lot of sessions.  If the 60 minutes on/15 minutes between thing is...

Awesome, Tom.  Thanks.

You're still hitting the table twice, though. 😉

And, yeah... I don't normally do the "right alignment" junk.  I was just demonstrating that it could be done if SQL Server was...

Many virtual events are being shared, here are some links that should help you:

List of virtual data saturday's here: https://datasaturdays.com/ There's also a list of data community events here:...

You might also want to look into the correct use of sp_execute for such things.

I wouldn't use DDM as a "security feature" to save my soul because of the very problem that you state.  If you need to make it so someone can't actually...

Possibly... what is the size of your largest database?

Hi guys

hope you are all well

I am struggling to write a sql code which will pick up the sales  value of the  last date of each month.

I have this...

The New England SQL...

I agree that "if you build it, they will come".  It does take a bit of advertising and one popular way to do that is to schedule regular meetings/events on...

I'm not looking for a job and I live across "the pond" but I wanted to thank you for posting a job here in these trying times.

Put yourself in my place and pretend you know absolutely nothing about the problem that you just described and then read what you just posted and compare that to the...

Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:04:49 Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19042: )

I...

Totally agreed... even when a time isn't included. 😀  There's this funny little line called the "International Date Line" that people seem to forget about.

Heh... and there was a response in the morning's email right next to this one that drives the point home for the bottom line above.  The "devil's in the data". ...