In Sql I am getting the result like below format. Totally i have 6 columns. in 1st row 6th column contains the value and 2nd row 5th & 6th contains the value. But i need to check the every cells if previous column doesn't contain the value means i need that in 1st column.
Actual Result
a b c d e f
1
1 2
1 2 3
Expected Result:-
a b c d e f
1
1 2
1 2 3
Kindly post some Good answers (I am using SQL server 2008-R2)
See Question&Answers more detail:os