pivot

Comparing values between two rows of data and only showing the columns that are different

In a previous application version we were using a particular field for a primary key, but because the field may represent different identities across various systems we have made it a non significant field(ie not a primary key or part of a composite primary) however since we dont have another system yet users still use that field as a pr...

MVVM Light EventToCommand doesn't work inside WP7 Pivot DataTemplate

Hi everybody, I have very strange issue. In my WP7 app I have a pivot control and an item template defined inside it(or in the resources, I have tried both ways, but still same issue). In the template I have a regular button with EventToCommand defined(EventName="Click"). I also have the same copy-pasted button outside the Pivot. The pr...

How to Collapse MySQL Rows to Columns Result

There's a query where I want to get the: Username of the user attached to the current opportunity record Sales Stage associated with each opportunity record Dollar amount associated with opportunity record I want to: Take the current IF STATEMENT result, and collapse it Current Query: $sql = "SELECT u.user_name as USER, ...