First of all, there have been religious wars over code formatting.  Even the original post contains a possible declaration of such a war where the OP works.

I'm NOT trying to...

If you know the date the principal was created AND you have a log file that spans that date, you can find it in the log file.  I don't have...

If your dates have...

Instead of making 2 passes through the table, use a CROSS APPLY to do the "unpivot".  There IS an UNPIVOT operator but I don't care for it.

...

Iwas Bornready (9/15/2016)

---

ChrisM@Work (9/15/2016)

---

Interesting. It does a lot of work for the result. Have you speed-tested it against the house splitter? Here's one I knocked up in a couple...

To continue the math behind all of this and what the verbal description of what the code actually does, run the following code and let me know what number it...

Remember what I said about the DW datepart and DATEFIRST?  What happens to the output when you change DATEFIRST and how does it relate to DATEFIRST insofar as the first...

Don't apologize for the question. You got a good part of it right.  Just not the "fine point".  Very specifically, which part of last week does it ALWAYS show?

Gosh, Jeremy.  Put a SELECT on it, run it, and see.  If you can't guess that, then break out pieces and see what it comes up with for values.  If...

When I do a search for "Querying SQL Course", I get a ton of returns from different sites and none of...

In reponse to Jo

I agree with Jeff, the applications seems to use a single connection sequentially.

So if i understand correctly, within the software, when they launch a query, the...

Hi jeff thanks for advice , i went by website you suggested geeks for geeks and i found it to more for programmers . .I didnt...

If such a savings makes such shutdowns "worth doing", you...

Hello. I keep reading that to check the expiration date for the AWS Free Tier, you need to check the first month that appears in your "Billing" section. Problem...

You could create a separate stored procedure that accepts a spid as an input parameter. The stored proc would be a simple WAITFOR command that waits for a period...