All
Accepted answers
Jose Ruperez · Oct 13, 2016 go to post

I can reproduce. Like someone said before, I get one message going from the business service to the MPI manager and then a second one, exactly the same, from the MPI manager to the HSPI operation. Nothing strange.

Jose Ruperez · Oct 12, 2016 go to post

I came up with this using the SAMPLES database:

SELECT Description,  TicketsSold, Total, (TicketsSold/Total) as Percentage FROM 

(

SELECT TOP 15 Description, TicketsSold, SUM(TicketsSold) as Total  

FROM Cinema.Film

ORDER BY TicketsSold DESC

)