rolinoberto (3/6/2015)

---

Hi to every ones,

I am new to this forum and to SQL world.

I need your help to find a solution for my headache, my question is:

I am using SQL SERVER 2012

I have the following table:

tbtab1

| A | B | C |

| 1 | Pluto | NULL |

| 2 | Pippo | NULL |

| 3 | Rossi | NULL |

I want to creare a new empy table with the columns name contained into the column B of the first table; the following shold my results:

tbtab2

| Pluto | Pippo | Rossi |

Colud you hel on this task?

Thanks