I think the [ ] were the problem... when I removed it from the reasons table I got the following error for each of the rows in the reasons table....:

Could...

Hi,

First - thanks alot for this quick response!

The reasons table is dynamic (we add reasons once in a while) and I'm making a summary of this into a report. the...

Jeff Moden (6/15/2008)

---

Then the XML solution will work.

Just curious... why did you post on a 2k forum instead of a 2k5 forum? Folks wouldn't have wasted their...

I'm using SQL 2005 😎

Thanks!!

the XML solution was very helpfull 🙂

Thanks, I've made some adjustments and this is working !!!

much more simple than I thoguht 🙂

thanks again

Good Night,

Adi

thanks for that! I'll test it and let you know:)

Hi,

this is the query I wrote, this is the first time I write these kind of queries..... 🙁

I have 2 tables, both have EE_ID as the unique identifer, both have...