Clay Passick
Clay.Passick at minneapolis.edu
Thu Jan 20 14:24:24 CST 2005
Is there a way in SQL 2000 to unormalize data that exist. I have done this in MS Access but never with SQL. The fields are in the same table. I have used views to some extent but my experience with sprocs is rather limited. The data is being viewed on the web. The following is a quick example of what I would like to do. >From this: Objective Task A 1 A 2 B 1 B 2 B 3 To this: Objective Task A 1 2 or 1,2 B 1 2 3 or 1,2,3 TIA Clay