You also can use DateTimeFromParts()

https://docs.microsoft.com/en-us/sql/t-sql/functions/datetimefromparts-transact-sql?view=sql-server-ver15

Please send examples to webmaster@sqlservercentral.com, so we know where this might not be working.

Rod, hope I don't upset you,  but this is a "you" problem. You are...

And a funny thing actually happened along with all that. We were actually able to put code out more quickly than ever because we weren't bogged down...

Again, not sure why. This seems like either a personal project or a way to extract some data value.

I could see some wider value in showing popular items in a...

I can't make this change immediately, nor do I have access to get this data easily. I can submit a ticket, but I'm not sure what the purpos here is...

Not so much dependency with change management, but more that some applications, and some situations, require you ensuring no one person can act too indepedently. I wouldn't want this to...

That is a great graphic. I'm going to save it as well.

And if you want to write up something on how you used it in a specific situation, I bet...

Ha, I'm much more likely to help you get a first round bye.

Congrats, John

Ah, so filter by some amount of reads. Not sure how easy this is, but we might be able to sort by this. Filtering is definitely more work.

I had that happen with SQL Saturday. In setting up new accounts, the...

Two people authenticate a process. For example, I want to turn auditing off, but I can't do it alone. I ALTER AUDIT SET OFF, but until another admin does this,...

I'm not sure what you mean by "how much fews has a script"

I don't have a way to easily correct that. I can't mark two answers as correct in an either or scenario.

Ha, I should try some in C#. After lots of daily work in PoSh and some Python, I find the idea of working in C# cumbersome.