If that's happening, then you've left something out of your post because, according to the code you've posted, it cannot happen.

If you want some help on this, I'm thinking that you simply haven't posted enough information about what you've done for anyone to help.

Google is your friend here.  Pick your poison.

https://www.google.com/search?q=get+list+of+long+running+queries+SQL+Server

https://duckduckgo.com/?q=use+sp_whoisactive+to+find+longest+running+query&t=newext&atb=v278-1&ia=web

https://www.brentozar.com/archive/2010/09/sql-server-dba-scripts-how-to-find-slow-sql-server-queries/

The question was about how to find rows in a table based on the current...

I just noticed timers on the jpg's with just a couple of hours left.  If it were me, I'd go with interpreting the word "respective" as meaning the professor and...

I'm the same way until I have two 12 ouncers of coffee under my belt. 😀

Sorry... I made a mistake and had to rewrite this post.

Please see the post above.  The word "respective" needs to be clarified because there are two possible solutions depending on...

• This reply was modified 4 years, 2 months ago by Jeff Moden. Reason: Rewrote the post because of an ambiguity in the word "respective"

I did a misread on the requirements because there are actually two possible answers according to the posted requirements and so had to rewrite this post.

Still, there is no need...

• This reply was modified 4 years, 2 months ago by Jeff Moden. Reason: Rewrote the post because of an ambiguity in the word "respective"

So just to clarify. if i have a clustered index on say contactid and invoiceid however none of the updates are on those columns then there wouldn't be a...

THE PREVIOUS CODE I HAD POSTED PRODUCED THE WRONG VALUES FOR THE 1st ROW OF FEDERALTAX OF THE "XX" ROWS.  I HAD COPIED YOUR FORMULA WITHOUT REALIZING THERE WAS A...

• This reply was modified 4 years, 2 months ago by Jeff Moden. Reason: Repair a formula in the code

Building your own sequential numbers is a sure fire way to generate duplicates by accident.  Even Des Norton notes that for his code.

Please explain why you're trying to avoid an...

Neither set of code is coming up with a meaningful result set, not sure where the disconnect here is, but I'll try again:

If a row contains: koagvakjnonsenseajg4648.dbo.RandomTableForSSChahfhaijfhfhf5664646

I want to...

You can modify the date created by copying a file. The file's created date becomes the modified date and the current date when the file is copied becomes the...

K... just remember that's not my first choice.  For me personally, it wouldn't be a choice.  Like I said,...

Sorry my post is confusing. I wasn't really sure how elaborate on it. Yes, we are having performance issues and it mainly looks like disk IO latency. We have...