sqlfriends@sql.com (8/17/2012)
Hi Experts;Good Thanks for all support
ChrisM : we don't have using any control to design this table.
Thanks
FAJ
What you have there is an EAV (entity-attribute-value) table. Simple-talk (site currently down) have an excellent discussion of the pitfalls of this design.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden