Pivot can be use when creating TableAdapter

[ad]

I use the new feature of TableAdapter of VS2005.
I want to use PIVOT in ths SQL when I create a TableAdapter, but it fail.
The system told me the PIVOT is not supported.

How can I do?

 

[Otis Mukinfus]

I use the new feature of TableAdapter of VS2005.
I want to use PIVOT in ths SQL when I create a TableAdapter, but it fail.
The system told me the PIVOT is not supported.

How can I do?

Use a stored procedure and code the PIVOT there (if the SQL engine you are using
supports it).

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com