quote:

---

Originally posted by X002548

POST DDL

Sample Data in DML Form (check, already done, I Guess)

Post Expected Results

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

---

quote:

---

Originally posted by GilaMonster

He's asking for table definitions (DDL). The CREATE TABLE statements.

Also, I'm not clear what you're asking

--
Gail Shaw
SQL Server MVP

---

quote:

---

Originally posted by GilaMonster

By the way, that looks like some form of EAV design (entity, attribute, value). Those kinds of design are typically a nightmare to work with, to query and are hell on performance.

--
Gail Shaw
SQL Server MVP

---

quote:

---

Originally posted by GilaMonster

Exactly what I said.

This looks like a type of EAV table. (google for details of EAV if you don't know what I'm talking about). EAV tables are generally a pain to work with. They generally are harder to query than a properly designed table and perform worse. They can look very promising to people who don't know that much about database design, they appear to be a excellent solution to all sorts of problems (unknown attributes being the main one), but they don't live up to that promise.

--
Gail Shaw
SQL Server MVP

---

quote:

---

Originally posted by GilaMonster

Exactly what I said.

This looks like a type of EAV table. (google for details of EAV if you don't know what I'm talking about). EAV tables are generally a pain to work with. They generally are harder to query than a properly designed table and perform worse. They can look very promising to people who don't know that much about database design, they appear to be a excellent solution to all sorts of problems (unknown attributes being the main one), but they don't live up to that promise.

--
Gail Shaw
SQL Server MVP

---