Question: I wanted to know if some of you have already tried to produce animated bliking text in email html body content.

As we know mail clients do not support **< style>** tag, it's not possible to set css animation keyframe attributes inline, because the animation should be declared. Like this :

```
 @keyframes colorblink { 
  0% { }
  50% { color:black; } 
 }

```

before being called.

How to achieve this for an email html body content? Or you think it's not possible at all?

Answer: 
you can try like below, i think there is column of values which contain city,hotel .. values

```
select * from 
(
select * from query
) src
pivot
 (max(values) for Question in ([City],[Hotel],[Rating],[Comments],[TransportationMode])
 ) pvt

```
You can try this following query:

```
 SELECT DISTINCT t.ReportNumber, t.Datecreated, t.Name, p.City, p.Hotel, p.Rating,
 p.Comments, p.TransportationMode
 FROM tablename t
 PIVOT (MAX(Datecreated)
 FOR Question IN ([City], [Hotel], [Rating], [Comments], [TransportationMode])) AS P

```