>Sorry , i also find a question . i use vb.net and Dataset. In Dataset, i use tihs sql statement . But error message.
>(The UNPIVOT SQL construct or statement is not supported.) Is unpivot command can't to support dataset.
>I go to sqlserver to run is no problem , how can i do?

Sorry, I don't know. May be you can try to create this statement as a stored procedure and see if you can use it with the DataSet?