First, no one is going to read that mess.  Use the "SQL Code" tag at the bottom of the posting box to include formatted SQL code.

Second, GET RID...

Spam reported.

The error message you get tells you exactly what the problem is

Drew

Your history table seems to be missing an entry for attr5.  You have entries for all other attributes when they were changed from NULL to something.

The following gives...

You haven't given us nearly enough information to provide you a meaningful solution.  Please provide table definitions, sample data, and expected results.  Follow the first link in my signature to...

It's because you're using the wrong formula for the path in recursive part of the rCTE.  I've commented out the incorrect line and added the correct line.

[code...

It's pretty simple, really.  SQL sorts character by character and left to right.  The character by character evaluation...

So we had a problem updating a record in our third party product.  I opened a case on the vendor's website and detailed the steps that I took to create...

People usually approach these problems the wrong way.  They try to determine if someone falls within a certain...

That error is returned by the parser, so no.

Drew