Hi

I have to reply with text, in this machine i don't have any sql server installed.

So if i run the above code i get something like this:

Num Name 1 2 3 4 5 ---> Column Names

1 User1 2 0 0 0 0

1 User1 0 0 0 0 0

1 User1 0 0 1 0 0

1 User1 0 0 0 4 0

1 User1 0 0 0 0 0

and something equal for the other users...

WHat i'm trying to achieve it's to only have one row for each user like this:

Num Name 1 2 3 4 5 ---> Column Names

1 User1 2 0 1 4 0