Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [BD_RESS]
- GO
- SELECT [sendID]
- ,[nombre]
- ,[asunto]
- ,[inicioEnvio]
- ,CONVERT(SMALLDATETIME, RIGHT(LEFT(inicioEnvio, 10), 4) + '-' + RIGHT(LEFT(inicioEnvio, 5), 2) + '-' + LEFT(inicioEnvio, 2) + ' ' + TRIM(RIGHT(inicioEnvio, 8))) AS inicioEnvio
- ,[finEnvio]
- ,[enviados]
- ,[entregados]
- ,[noEntregados]
- ,[clicks]
- ,[clicksUnicos]
- ,[aperturasUnicas]
- ,[desuscritos]
- ,[quejasSpamUnicas]
- ,[quejasSpamAcumuladas]
- ,[indiceEntregados]
- ,[indiceAperturas]
- ,[indiceRebotes]
- ,[indiceDesuscritos]
- ,[proporcionClicksUnicos]
- FROM [dbo].[RESS]
- ORDER BY CONVERT(SMALLDATETIME, RIGHT(LEFT(inicioEnvio, 10), 4) + '-' + RIGHT(LEFT(inicioEnvio, 5), 2) + '-' + LEFT(inicioEnvio, 2) + ' ' + TRIM(RIGHT(inicioEnvio, 8))) DESC;
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement