Please describe in more detail what you want to achieve.
Include an idea of what the data source and destination are - is this all in SQL Server?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin