We have an auditing system which logs all the changes that occur in all the system tables. Basically, this is how the AuditLog table looks like:

![enter image description here](https://i.stack.imgur.com/XU4tv.png)

Currently I am creating a couple of sql views to query different kind information. Everything is ok except for one point. If you take a look at the image again, you will see I have a SubscriptionMetadata table which is a key-value pairs table with 2 fields (MetaName and MetaValue). What the immage shows is that the subscription has a new watermark which value is 'Licensed copy: Fullname, Company, V...'.

What I need is transform, in my view, these two rows in just one with the following form:

```
41 - Insert - SubscriptionMetadata - 2012-10-19 - 53DA4XXXXXX - Watermark -  Licensed copy: Fullname, Company, V...

```

I really cannot imagine how I can do it or search for it neither.

There is another problem (I think), these rows comes always in that order: MetaName first and then MetaValue. That´s the only way to know they are related.

Could you help me, please?