|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Pivot can be use when creating TableAdapterI 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? On Tue, 21 Feb 2006 16:46:33 +0800, "ad" <fly***@wfes.tcc.edu.tw> wrote: Use a stored procedure and code the PIVOT there (if the SQL engine you are using>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? > supports it). Otis Mukinfus http://www.arltex.com http://www.tomchilders.com  |
|||||||||||||||||||||||
Other interesting topics