thanks a lot Vedran Kesegic and CELKO. 🙂

thanks Taylor for your valuable reply and appreciate a lot. by the way me also tried some other way something similar to you and the implementation as below:

CREATE TABLE LeaveRequest(

LeaveID...

thanks a lot. 🙂

GSquared (12/1/2009)

---

I'm assuming you're talking about a "one-true-lookup-table" solution. Your sample doesn't include any values, just column names, but the usual thing in this case is that you'd have...

Garadin (12/1/2009)

---

You're missing a ton of information here. Where are the values coming from?

FullName Address City Country

Ravi aaaaa aaa aa

Andy bbbbb bbb bb

Apollo ccccc ccc cc

Sounds like an EAV...