I don't know how to do it!!

Hello Jeff,

I try your code and found it not really do what I want because if you have this (the following show the 10 last exam result code of a...

Hi Jeff

I am glad you had fun with the article. I am surely not at this level!

I cannot give you a lot more information on the purpose of my...

It's for statistics purpose to analyse the tendencies of students.

Thanks for the solution, it's not simple, I will try it.

Yesterday I browse the web to find by myself a solution...

Sure

I have a Student table in relation with an exam table. So each student has done n exams.

Each exam has a final cote (the result code in my initial...

oh great thank you

Do I have to worry about performance with this kind of Select Statement?

Thanks

Martin

In gact I need each count in variables for further treatment.

I know I can do 6 Select statements

Set @Status1 = Select count(*) from TableA Where idStatus = 1

Set @Status2 =...

Thanks for you answer

The 2 minutes execution was just for the purpose of the question, to help to figure the meaning of the question.

I know a trigger shouldn't be that...

no no

the query is in a stored procedure, it's used to duplicate some rows and affected id to a new foreign key.

The trigger is used to log...

I don't , the query I use is the one stated in my initial post.

Thanks to Lynn and Gail for the tips

Martin