Add datatable .

Question

Hi ..

i have a datatable like this whit values

Key  v1  v2   v3

Mic    1    2    3

Jav    1    2    3

Ora   2    3    4

Jav    4    3    2

Mic    2    2    2

now i need to change it like this in another datatable in button click

Key   Mic  Jav  Ora

v1     3      5      2

v2     4      5      3

v3     5      5      4

I have to create like this and add the repeated value please help me..

Answer 1

Guys.. really sorry...for asking this,,

I was stuck and cant able to think..

I got it my self..

Answer 2

Hello,

Being Glad to hear that you have found a solution. If it is possible, please share your solution with us so that someone who has the same issue will be happy to see it.

And for this issue, it seems that you want do conversion operations in SQLServer. There is an UNPIVOT command. You can have a try, too.

Have a nice day!

Regards.

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.