Also, I could swear that in some previous version there was an option to stop a job if it ran over a certain definable period of time. It would be...

You could also use the OUTPUT clause for the first INSERT statement. Check out this article:

 

https://www.sqlservercentral.com/articles/the-output-clause-for-insert-and-delete-statements

 

I think the notifications and operators need to be updated. For the "Pager On Duty Schedule" of the operator, currently you can't have it go from night to morning, since...

Was this resolved? I'm seeing the same issue

I'm really surprised that no one mentioned Microsoft doing this (date and/or time as INT) in the msdb database.

SELECT * FROM dbo.sysjobhistory

Complete pain to convert that...

Seriously though, thanks. That's a lot to pour over. I will definitely test this out and see if it's something that we can use.

Rich Mechaber (2/23/2016)

---

Hi, Alan, o/p here, and I've enjoyed the follow-on conversation I started.

This aspect of NTILE() is an eye-opening piece of information, thank you for posting it....

So, to dig even further...

If your table had 92 million records, and you had 9 different "Val" columns, would you still use the same code? Or do it differently?

I'm wondering,...

Alan, I agree with you, if you're just wanting one ranking. If we expand upon the Original Posters issue (which is what I was facing) and say that you want...

No, that's not quite what I was trying to do.

The problem I had (which lead me to this post via Google) was that I had several different rankings dependent upon...

Maybe a work around would be something like this:

SELECT *,

CASE WHEN val IS NULL THEN 0 ELSE 1 END,

NTILE(4) OVER (PARTITION BY CASE WHEN val IS NULL THEN 0 ELSE...

Patrick,

I know it's been a long time since this post, but did you find a solution? I'm experiencing the same issue.

Ok, finally got a resolution on this. We actually had to call Microsoft. In my 18 years in IT, this is the first time I've ever had to do that.

Turns...

Ah, thanks. It appears this is an issue of .Net. It was installed, but the drive no longer exits. I'll try reinstalling the .Net libraries, and try it again.