the solution was not efficient, for that reason, I put the script here with the solution, thanks for your help and I hope this works for someone in the future.

SELECT...

To show the user the information as requested in the front end one pivot table so presented as requested is generated, clarified that it is with programming code. Turned out...

I appreciate your all your answers, I've already solved the problem, just to clarify something, I do not have the data stored in this way, it is the result of...

I appreciate your response, it was very useful because we had completed something similar, only we needed to confirm with an expert like you.

Thanks again.

Thanks, I've found the solution and my SP run correctly, i got a sintax error. Thanss everybody again...

Dial.

I'm runnin in XP

Sorry, my english isn't good, but, thanks, I was resolved my problem.