I used to have an AV system that needed periodic cleaning.

Account cleanup is a good idea. Most places we've had good separation processes for this, but certainly some accounts don't...

Redshift is a data warehouse. That is all over the marketing and documentation. It is not available on-premises, nor is 100% compatible with PostgreSQL. I'll alter the question to note...

Good point. There shouldn't be a need to scroll over for the counter. I suspect they have forgotten to put the page numbers in a table or div that keeps...

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