I've been using something similar to your query for a while now, but I hadn't known about the option to convert to varchar(max) and get rid of the tokens. ...

CTEs. Output clause!!

And goodness, I can't believe no one has mentioned table-result User Defined Functions. What heaven.

When we get to SQL Server 2008, I know...

This was new to me and you did an excellent job of explaining how it works. I was with you every step of the way. 5 stars.

I can testify to the potential hit on checking for...

Sounds like a fantastic idea to me.

Yikes! I definitely feel your pain there.

Hugo wrote:

And consider what so many people call a junction table - a table that represents the many-to-many relationship between two tables. I will usually model these as just the...

It's still not there. And you are right, there is a whole lot left to be desired about ERwin. The glaring lacks are shocking really, given the software...

Could you comment on how RAP may or may not use datamodels? I currently have a love-hate relationship with ERwin. But I can't really imagine wanting to start...

I had two thoughts after reading about the idea of leaving a hard drive of personal files at a friend or relatives house:

1) It's like leaving a house key with...

While I too had trouble with the analogy and remain a bit sceptical, I think the idea has merit and is worth exploring. I hope to keep an open...

wildh: thanks for looking those links up. One of those was very helpful to me! Why re-invent the wheel.

peterzeke: I agree with everything you say.

I'll add two (or three) more of my cents: There are two stories here (no doubt out of thousands everywhere) of people who...

I'm saddened by all the replies that do not understand why payment was not involved. The whole point of a volunteer is that you do not get paid. ...

Stephen Hirsch (7/14/2010)

---

James Goodwin (7/14/2010)

---

I think the moral of the story is: What the requirements say the customer needs, and what the customer says that they need and what...