sql server - SQL- Inserting a row in sql query result -

how can achieve this? example have query result:

idno price  001   5  002   5  003   5  004   5  005   5

then want add every id no price this:

idno price  001   5  001   10  002   5  002   10  003   5  003   10  004   5  004   10  005   5  005   10

thanks in advance

insert yourtable select idno,10 yourtable   select * yourtable order idno

Silver