If you can change what your input parameters mean you will have a much simpler time querying your data in my opinion. Let's say we changed it to mean this...

chumphrey 12211 (4/6/2012)

---

I am a newbie!!! I have a 2008 R2 Standard Ed server with a database that is in Simple Recovery. The database had a large amount...

You've got several concepts going on here that you need to learn before you can get all the way through the task. Here are a couple videos that cover some...

Not sure, but your registered SPNs may need to be updated after the rename if the FQDNs change with the rename.

OK, I think I ruled out the block-level copy step as a possible problem. I just successfully restored the supposedly problematic-backup to a different 2008 R2 server in the remote...

Here's the equivalent T-SQL solution:

WITH cte

AS (

...

You're sample data is still causing trouble...but I polished it a little to the point where it will at least run. here is a sample using the SQLCLR Aggregate:

IF EXISTS...

I wish I could...the 2005 and 2008 R2 data centers are geo-separated and...

No worries on the name, happens all the time.

Did you see Gail's post? I think she is onto something 😉

The RESTORE VERIFYONLY returned clean:

Can you post the DDL for DateL2?

This part of your update statement will not tolerate NULLs:

WHERE CollectionPrefix = @CollectionPrefix

...

GilaMonster (4/6/2012)

---

I can pretty much tell you that it is not a corrupt page in the source DB. There is no page 0:0 in a database, and if page 1:0...

We must have been typing at the same time...ditto to everything Lynn said. In order to help further we need to see DDL (i.e. CREATE TABLE statements), DML to create...

kpwimberger (4/6/2012)

---

Thanks SS:

That makes sense. But what can be done about the loop issue, then? It seems to me that the call to:

UPDATE #temp SET Processed = 1 WHERE Foo...

I am running the verify now...will post back when complete.

When was the last time...