autoexcrement (6/6/2014)
I understand. I will try to come up with some good sample DDL. Thanks nonetheless for your efforts.
Here is a start.
create table scratch
(
Col1 bit
,Col2 int
,Col3 varchar
,Col4 varchar
,Col5 varchar
,Col6 varchar
,Col7 varchar
,Col8 varchar
)
create table live
(
Col1 bit
,Col2 int
,Col3 varchar
,Col4 varchar
,Col5 varchar
,Col6 varchar
,Col7 varchar
,Col8 varchar
,Col9 varchar
,Col10 varchar
)
Now we just some sample data and what you are expecting as a result.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/