Now if i could only figure out how to close this topic...

A short poem if I may:

Books have knowledge.

To apply knowledge is wisdom.

One must learn to apply this subtle truth,

by those that teach, who've climbed the mountain

of independent...

Thank you Craig. While useless, you have helped me. 🙂

Now if i could only remember how to mark threads as solved. :-/

haha. No textbook. My boss wants an explanation of what this does.

Yes thanks so much Wayne! I appreciate all the help you have given me!!

I just didn't understand the CTE (N). Not sure what that is. 🙂

Wow, that looks awesome.

What does it do? lol

Honestly you blasted way past me with your SQL knowledge. You went to the moon and

im still stuck in Rhode Island.

I should add that @STARTDATE is assigned to GETDATE

Oh, my bad.

Thanks Scott! 🙂

Awesome, thanks SSC. Your second thought was correct. There was an instance where there was no apartment in the string. That was the error. Its an invalid length because its...