What exactly are the details you want copied? Could you post the expected results of the copy process based on the sample data you provided?

It seems that you just want to insert into tblTest a copy of a row already in tblTest, but then populate questions and answers differently for the new test?

If the new test has different questions and answers, should the values for testName, duration, and totalQuestion be the same?

In principle this should be a fairly simple INSERT INTO...SELECT FROM, but if a bunch of the details are going to be different, I'm not sure why the test information needs to be copied from an existing one.

What is the stored procedure solution you've attempted so far, and what were the issues you encountered?

I know I asked a lot of questions, but knowing exactly what you've tried and what you want to do will help greatly.

Cheers!