Thanks, I had to detect this recently and needed to look up whether the current value was the last one or next one.

I don't mind time tracking for clients, but I hate it internally. I used to do this for a employer and tried to enter time according to major projects. Then,...

Sorry, didn't quite read the entire thread. You could do some manipulation with datetimefromparts, but the easiest way might be this:

declare @dt datetime  = getdate()
, @time...

My page URL for page 15 is: https://www.sqlservercentral.com/forums/user/steve-jones-ssc-editor/replies/page/15

You don't see pages at the top?

I completely gave up, which might have been the winning strategy this week.

In any case, good luck to the chapionship bracket.

If I forget things, send me your email via private...

Got my career started. I...

Confused author. Was thinking one thing and working on another.

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...