Lynn, in my opening question, I tried to show what I was doing. I cannot show table names/column names, due to the sensitivity of what I work on. ...

I have a table that has hierarchical data in it. Small amounts...but I am trying to filter on a piece of data that has children. I was reading...

HI...I used the second example and just needed to tweak it a bit and IT WORKED!! Thank you!!!

ok, the concept seems clear, yet I am having issues. First I created a #temp table

then tried building the CTE and inserting into the #temp Table. It says...

THANK YOU!!!

Kenneth, that is what I want to do, I just don't know the syntax! Never written to a file before....

thank you to both of you for the good ideas!! I will read the articles in the am.

In this instance, all I want to do is check to see...

AWESOME!!!!!! Thank you for sharing this!!

Merry Christmas!!

thank you! I knew it was an easy one, but everything I was looking it was so complicated and didn't address JUST ONE!!

Merry Christmas!!

SWEET!!!!!!!!!!!!!

Thanks Steve!!

I have this goofy guy that runs a dept next to me that poses questions to STUMP ME! This one did. The answer I gave him was BCP...

Sorry about my silly query, it was not complete...my bad. You explained it so I can understand it, and I thank you all for helping me out here. ...

Fair enough....I would like to re-write it, but I am not sure what '=*" means??

It is in this context in my query:

select

something s

from

somewhere...

Thanks Steve. So, how do I go about fixing this problem? Re-install SQL 2005? I work for a company where the SE's do all that stuff, so...

thank you David!!