HnD | Pivot Table, Page 1

Pivot Table

Posts

Ian
User

Posts: 511
Joined: 01-Apr-2005

# Posted on: 08-Oct-2006 00:40:17

Hi,

If I create a pivot table using a view in SQL Server, would the corresponding LLBLGen entity be updatable as per normal?

Cheers, I.

Chester
Support Team

Posts: 223
Joined: 15-Jul-2005

# Posted on: 08-Oct-2006 18:16:12

PIVOT queries are aggregate queries, so updating the underlying data isn't possible.

Ian
User

Posts: 511
Joined: 01-Apr-2005

# Posted on: 11-Oct-2006 20:16:37

Did it with triggers.

bclubb
User

Posts: 934
Joined: 12-Feb-2004

# Posted on: 12-Oct-2006 02:56:27

indeed.