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

How about :

;

With cteDocCounter

as (

...

Check out Jeff Moden's wonderful "DelimitedSplit8K" http://www.sqlservercentral.com/Forums/Topic943562-338-1.aspx#bm944589

It will get you started on resolving your quest 😎

I would create a synonym in the database, referring to the table in the other database.

Check "CREATE SYNONYM" in books online

ps I prefer still leaving a trace in the naming...

SQLRNNR (9/15/2011)

---

Tom.Thomson (9/15/2011)

---

Steve Jones - SSC Editor (9/15/2011)

---

Please let's not have quotes of every post that counts down from 95, 94, 93.

I'm going out of town for a few days....

Make up your mind. No guessing 😉

Jeff Moden (9/14/2011)

---

ALZDBA (9/14/2011)

---

jcrawf02 (9/14/2011)

---

Grant Fritchey (9/14/2011)

---

mtillman-921105 (9/14/2011)

---

Grant Fritchey (9/14/2011)

---

Changing the topic for a moment, I'd like to beg some ideas from the group, again.

I'm tasked with writing another article....

jcrawf02 (9/14/2011)

---

Grant Fritchey (9/14/2011)

---

mtillman-921105 (9/14/2011)

---

Grant Fritchey (9/14/2011)

---

Changing the topic for a moment, I'd like to beg some ideas from the group, again.

I'm tasked with writing another article. This one is...

Grant Fritchey (9/14/2011)

---

Changing the topic for a moment, I'd like to beg some ideas from the group, again.

I'm tasked with writing another article. This one is all about the scary,...

Perry Whittle (9/14/2011)

---

Unless you're using...

This is a great recognition and thank you for all time, energy en knowledge Jeff developed and shares !

Congratulations, Jeff

We get to hear "Ho, ho, hoo" at SQLPASS 2011 !!!!

http://www.sqlservercentral.com/articles/Exceptional+DBA+Awards/75988/

Congratulations Jeff !!

Jan Van der Eecken (9/13/2011)

---

ALZDBA (9/13/2011)

---

I...

just saying ..

Would your business clients appreciate the apps not working whilest some one consumes historic data and scans all your lovely large tables pushing regular oltp stuff out of...

I think he's expecting to host...