Vortex

Seems like wasted effort to me. You already have this in...

Ed Wagner (10/8/2014)

---

Why do you need to change it to a single CTE? Cascading CTEs exist so you can accomplish things you can't do with one query. It's...

Ed Wagner (10/8/2014)

---

GilaMonster (10/8/2014)

---

Sean Lange (10/7/2014)

---

Oh no. I assumed he must...

SQListic (10/7/2014)

---

Try this link

http://sqlism.blogspot.com/2014/09/script-to-delete-millions-of-records.html

Delete records without increasing your log space

------------------------------------------------------------------

DECLARE @continue INT

DECLARE @rowcount INT

SET @continue = 1

WHILE @continue = 1

BEGIN

PRINT GETDATE()

SET ROWCOUNT 10000 --Replace...

gremlin

Ed Wagner (10/7/2014)

---

Sean Lange (10/7/2014)

---

Ed Wagner (10/7/2014)

---

djj (10/7/2014)

---

Ed Wagner (10/7/2014)

---

Daniel Bowlin (10/7/2014)

---

djj (10/7/2014)

---

Stuart Davies (10/7/2014)

---

SQLRNNR (10/7/2014)

---

Ed Wagner (10/7/2014)

---

TomThomson (10/7/2014)

---

whereisSQL? (10/7/2014)

---

Ed Wagner (10/7/2014)

---

crookj (10/7/2014)

---

Ed Wagner (10/7/2014)

---

BWFC (10/7/2014)

---

Ed Wagner (10/7/2014)

---

djj (10/7/2014)

---

Ed Wagner...

Ed Wagner (10/7/2014)

---

djj (10/7/2014)

---

Ed Wagner (10/7/2014)

---

Daniel Bowlin (10/7/2014)

---

djj (10/7/2014)

---

Stuart Davies (10/7/2014)

---

SQLRNNR (10/7/2014)

---

Ed Wagner (10/7/2014)

---

TomThomson (10/7/2014)

---

whereisSQL? (10/7/2014)

---

Ed Wagner (10/7/2014)

---

crookj (10/7/2014)

---

Ed Wagner (10/7/2014)

---

BWFC (10/7/2014)

---

Ed Wagner (10/7/2014)

---

djj (10/7/2014)

---

Ed Wagner (10/6/2014)

---

whereisSQL? (10/6/2014)

---

Sean Lange (10/6/2014)

---

SQLRNNR...

Ed Wagner (10/7/2014)

---

Sean Lange (10/7/2014)

---

That has been going on...

Oh no. I assumed he must be working backwards. Then again...

Herpington_McDerpington (10/7/2014)

---

Sean Lange (10/7/2014)

---

Let me see if I understand your request here. You have 13,000 tables in your database with specific naming convention. You then need to look at every...

Herpington_McDerpington (10/7/2014)

---

Apologies for the lack of clarity folks.

In the simplest of terms I am trying to retrieve a list of tables, but only tables that meet a condition.

DB1 has 13,000...

thedavegray (10/7/2014)

---

Hi,

I have access to an unknown database via a third party ODBC driver, but can't get a response (two weeks and counting) from the company which host the...

That has been going on for a couple of...

You definitely do not want a cursor here. It sounds like you need to look at cross tabs. If the number of steps is known you can use a static...