Hi thanks for reply.

Yes you are right the comparison is in between @testname & testname.

The sp which I have written will fine upto tbltest and tbltestquestion but coming...

Hi, Thanks for quick reply.

Values for testName(this will be unique that i will pass), duration, and totalQuestion will be the same of existing test details base don testId i will...

Thanks I got it

Thanks

Thats Wonderful...First time i came here and i got Result..Good Work..

I don't know how to mark as answer..

Thanks For Supporting

I wants that the Output should come like

http://social.msdn.microsoft.com/Forums/getfile/160768

This is the output for a single Student(EnrolmentId)..I need the same Output for all the Student (EnrolmentId) in this...

Ok for that i have created a Single table..In this table there is a data of all the students of one class.. Now plz tell me that how to...

Thanks for Co-operating

I tried alot but my Output is not coming

Actually i have an Stored procedure and i am passing three parameters the one is classid second is session...

Hii Thanks for Reply,, This is the query when i run this query i will get the output

Declare @Table Table

(

EnrolmentId Int,

Amount Int,

HeadName Varchar(30),

Concession Int,

Billamount Int

)

Insert @Table

Select 14408,4950,'Tution',0,4950 Union...