Sunday, March 11, 2012

Dynamically Creating "Features" Grid

I was given what at first seemed a simple task (and maybe it is, but with everything else on my plate, I can't seem to get my head wrapped around this)...create a grid or table something similar to below:

Plan A Plan B PlanC PlanD

Item1 yes yes no no

Item2 yes yes no no

Item3 yes no yes no

etc....

The "plans" are stored in one db table, the "items" in another. What I can't seem to get straight in my mind is how to relate the yess and nos and then generate a tabular layout similar to the above.

I don't need anyone to do it for me, but a push in the right direction would sure be nice (using SQL 2005) Thanks!

Try googling for SQL Server 2005's PIVOT and UNPIVOT functions.

Here's onearticle I found that should point you in the right direction.|||Yes...a day away and a quick read of the link you provided cleared the cobwebs. Thanks!

No comments:

Post a Comment