Hello,

Thanks for your help. I should be able to do as you have suggested.

Thanks

I've not used Express, only Standard, but assuming that the SQL version isn't the cause of the issue then the following information might help identify the cause of the problem:

All,

Thanks for your help. Sorry for missing something so basic. I generally use ascending so I've never noticed my error before.

Thanks

Hello,

Thank you for the suggestion. In the full version the pivot columns are created with dynamic sql so the pivot will be easier if I can get it...

Thank you

Hello,

Thanks. Your right about needing enough data to identify an individual. Postcode was just an example column of the columns.

I think always encrypted would give me...

Hello,

Thanks for the advice. I will take a look at disk encryption as well.

Part of my reason for thinking about column level encryption is that most...

Deleted - incorrect info

Hello,

Thanks for your help on this (and on my other numerous questions 🙁 )

I'm also looking at that. I wanted to encrypt the live server data...

Thanks. That makes sense. I knew I'd missed something but couldn't work out what.

Hello,

Thank you for your help.

I completely missed the fact that TDE isn't in Standard.

Thanks

I haven't been using SSMS that long so I can't give a definite answer but I suspect this is an issue with the SSMS install, possibly user permissions or clash...

Hello,

Thanks, your example made me understand the issue. Logdate can't be referenced in the select (because, as you said, it's being used for the pivot) but I can...

Hello,

Thanks for your help. I hadn't thought of that.

However if I remove logdate from the select then it runs but there is no pivot. I just...

All,

Thanks for your help.

Andrew