Hi...

I wonder if this would be helpful. I looked for system views that displayed this information, and I couldn't find any.

I did a google search and came across a few...

I discovered that the queries in question were victims because of SQL jobs running causing them to die. Just seems odd that the duration would go so long. I can't...

Very good advice. I love this site and the books offered for free have helped my knowledge tremendously. Dissecting SQL Execution Plans.... Perfect for tuning SQL.

No cursors were used. 150,000+ records took an hour to change, yup, bad, bad, bad. Those 150,000 could have had many more charges associated with the records. Both tables that...

I rewrote the script.

Got it down to an hour. 🙂

I will put your advice to good work. It is very good.

Thank you for the help. I appreciate it.

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[test]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[test]

GO

CREATE TABLE [dbo].[test] (

[order] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[year] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS...

That is a great example for how to accomplish something I described without a cursor.

Here we write cursors because it is pre-determined and believed that it keeps better data...

The idea is to originally grab all duplicates in the users table and then scan through the financial_Reports and replace the value of the identified duplicate users highest ID with...

After some thought... I been thinking about that myself but haven't been able to figure out how to identify myself...

It's best to say we want the lowest ID... So...

The problem had to do with a bad implementation. That root cause was identified and resolved. There is a lot of data pointing to old users that no longer use...

Here's where you give us a verbal description of how we can logically get to the answer. Given the example results you want to get, what makes your final result...

I didn't mean to upset anyone. My goal is to become a more efficient SQL programmer. I have a difficult time explaining myself as it is. I apologize.

Say a user exists two times 'John Doe'.

Someone does a accounting review for a customer and a report is generated, there is a window when you search for the...

The result I would like to see is:

For every ID where exist in one of the five columns a 1 and a 2, I want to replace the value with...