LutzM, I just read your articles on crosstabs. I am sure I'm just being thick-headed, but I cannot wrap my brain around how it applies to my situation because I don't have any data to aggregate. I'm not trying to sum anything. I just want to re-arrange existing data.

I also found and read the Simple-Talk article. I think I'm closer to understanding, but again, I'm thrown by the fact that all these scenarios have something to sum and I don't have that.

I need to create a view with separate columns. The business case is that we have an application with an extremely limited reporting module. I'm hoping to create a custom view the user can join to on people_code_Id that will already have the childname columns listed out in a single row by people_code_Id.

I know the goal of this forum is to provide tools and get readers to do the thinking for themselves. I really am trying. It's not a case of laziness here. Could somebody just write the pivot or cross-tab statement based on the data in my table example above? If I can just see it, I think I can handle the dynamic piece. Thanks in advance!