For me is very important to have the right order in the table.

For the first record I must to have the value of the first field of my original table, in the last record I must to have '8 S' that indicates me I have the fix value I put (but for the last record).

Is it possible to put another field (count) :1, 2, 3 etc?

val count

1 cod 1 1

1 des1 A1 2

1 des2 A2 3

8 S 4

1 cod 2 5

1 des1 B1 6

1 des2 B2 7

8 S 8

When I have many records I am not sure I have the right sorting.

I insert the result of the query in a table and when I call "select top 100 percent * from table" I don't have '8 S' on the last record.