Does the following give you the same error?

WITH CTE(n) AS(SELECT 1 UNION ALL SELECT 1),

CTE2(n) AS (SELECT 1 FROM CTE x, CTE y),

CTE3(n) AS (SELECT 1 FROM CTE2 x, CTE2...

PaulB-TheOneAndOnly (2/6/2012)

---

Assuming you are talking about deleting the whole population of a table it doesn't matter if it's Oracle, SQL Server, DB2 or whatever...

And to help us out, how about showing us what you have tried so far.

Hey, I needed to see what is what first. Please don't get impatient. We are volunteers.

surma.sql (5/2/2012)

---

see

one teacher

teacher school code

steve ulman 151

steve ulman ...

From what you posted, nope.

Please read the first article I reference below in my signature block. It will walk you through what we need and how to post it.

And this is why you shouldn't cross post. We have discussions and answers split across threads.

And this is why you shouldn't cross post. We have discussions and answers split across threads.

Gus, use the other one.

NevaMind (5/2/2012)

---

Thanks Lynn. School...

blandry (5/2/2012)

---

Sorry - back at the desk for a short while...

If you look at the LEFT OUT JOIN, its the DATEADD four lines down from that.

PADL is a custom implementation...

Now we have a circular loop. Talk about fragmenting answers.

Please do not cross post, it will only fragment the answers you get.

Please post all answers here.

First, found another function that needs to be defined: dbo.PADL(sf.ImportId, 2, '0').

Second, as I went through the code manually I found 4 lines with the DATEADD code. Really need...

The problem here is that we can't see what you see. What little you have provided only allows us to take wild shots in the dark and hope the...