Hi lmu92,

thanks for your answer!

This way I get the "value" column filled, but the id and name column stays empty...(of course, there is no sql:field property for them)

If I replace

<ElementType...

I don't want to update the primary keys but the foreign keys.

But I really don't want to do that, I just want to update my data conveniently.

Let's use my example...

Thanks for telling me the correct name.

We use a mixed enviroment with 7, 2000 and 2005 servers and I thought it was a 2005 server.

If it bothers you so much...

Hi,

thanks for you answers! Unfortunately we are still using MSSQL2000 so I have to use PIVOT tables like this:

SELECT

mana,

SUM(CASE WHEN abna='NW' THEN pro ELSE 0 END) AS...