question

I have a partition file for a table that does not have an index. Unfortunately, I have reused the Partition Function to create several other partitioned tables with the same index field. Lesson learned... I need to be able to switch out the partitions to a table or somehow truncate the data that is in the partitioned heap without removing the other indexed and partitioned data. I have read a ton about this subject online but have not found a solution that will remedy this situation. Situation: I have Table1 with a YearMonth field and there are 2 different Partition files and the Primary associated to the table. When I look up the list of partition numbers, they are repeated (1-97) for both files, so I am afraid that if I try to switch out Partition # 1 that it will grab data from both tables. Any ideas on how I can fix this mess? Thanks, Scott