Insert id, name of column and value into a Table SQL Server?

If you are using SQL Server 2008, the you can use UNPIVOT and dynamic SQL so you don't have to write every column on your own (Before using dynamic SQL take a look at this link ). Try this.

You need to do a cross-tab query to transform from a row with many columns to a number of rows with a couple of columns, good example in this article. Or in Celko's fantastic Sql For Smarties Book.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions