Trey Staker (9/16/2011)

---

GSquared (9/16/2011)

---

GilaMonster (9/16/2011)

---

I suspect this got lost in all the 'helping Grant abuse SQL' posts...

Another request:

I'm bunking tonight and starting the rewrite of my rather old (and second-ever)...

I don't think I understand if the data you included in your post is the actual data in your table or the output of the query you posted.

Can you post:

1)...

calvo (9/16/2011)

---

Gianluca Sartori (9/16/2011)

---

I'm installing an instance for a new third party software and I would really appreciate your advice on the instance name.

In this shop each instance name must...

Brandie Tarvin (9/16/2011)

---

Gianluca Sartori (9/16/2011)

---

WayneS (9/16/2011)

---

Question for those that blog (preferably with WordPress) and post code on their blog - what code syntax tool do you use? I'm using WP-SynHighlight,...

I'm installing an instance for a new third party software and I would really appreciate your advice on the instance name.

In this shop each instance name must start with a...

WayneS (9/16/2011)

---

Question for those that blog (preferably with WordPress) and post code on their blog - what code syntax tool do you use? I'm using WP-SynHighlight, but I'm not completely...

Self join, I mean something like this:

SELECT A.*

FROM SomeTable AS A

INNER JOIN SomeTable AS B

ON A.SomeColumn = B.SomeOtherColumn

Yes, definitely. Use a self join.

Can you post table script and tell us a bit more about your issue?

You can use DBCC OPENTRAN() WITH TABLERESULTS and pipe it to a table.

ALZDBA (9/16/2011)

---

edited ... removed the quoted text :blush:

Can you use Row_Number() over ( partition by yourdatecol order by yourdatecol ) as RwNumber

and add that ( - 1)

e.g.

update x

set...

Well, things don't change without a reason, check that everything is really back as it was before.

However I would not focus on that ...

Now your plan sucks and it used...

aaa-322853 (9/16/2011)

---

Sure there are several indexes on the target table and they have always been there.

My point is that now everything is structurally the same, the data is the same,...

And what if the modified time (+1 min) is duplicate as well?

aaa-322853 (9/16/2011)

---

Hi sorry, forgot to mention I had already carried out a global update stats on the staging database.

And there was one thing which did change - this was...

Is this Oracle SQL?