Drew - my thoughts were to limit the query results a unique path, where no one node appears more than twice to keep this from happening.

That being said, the data...

I do apologize for the extraneous commas in the insert statements !

scott.pletcher (9/9/2010)

---

I don't think SQL 80 will accept any type of "CROSS APPLY", so that will be limited.

As I mentioned, it oddly enough allows the CROSS JOIN just fine as...

I did try this, and it had no effect / same error

I should have elaborated...

the database is provided by and supported by a vendor. for various reasons, they have not yet fixed everything in it that requires it to [still] be...

Level 90;

nope.

I'm guessing based on some searching I did and your question, that that be why !

Darn it. I am unable to change the compatibility level on this db....

Just to beat the dead horse deader.......

Since we were talking about logic on the application side vs. logic on the db side...

seems I always end up in some argument...

Sure, I get it !

"circular reference" was a poor choice of words...

I think what GSquared was talking about was not necessarily a trigger, but nesting the insert/transaction, checking @@rowcount...

Thanks I'll try that.

I'm very open to other suggestions...

the reason for trying the BCP option, is that it has been a small version of hell working with SSIS and it's...

It seems like you answered your own question...

>>>>The Invoices row is inserted/updated first (it must exist before a InvoiceLines row can be inserted)

Does that mean you have a foreign key...

btw - I am assuming it's complaining about the "must declarescalar var..." - because of SCOPE...

And that is my question... it obviously parses the param string well enough to...