in table @Response

in this table @Response the record id was caled two time

u will find column Response and record

943B4955-BF16-4DC8-869F-9907DFC95AF7 DF8BC368-68D7-4EC3-9E9A-5A4B19A6C323

A70FC1C6-8ED5-4777-9535-D8FB18146D17 DF8BC368-68D7-4EC3-9E9A-5A4B19A6C323

depend on the Response the @Responsechoice

follow a same questionid is choosen but diffrent choice are added

in @Responsechoice

1,'943B4955-BF16-4DC8-869F-9907DFC95AF7',1,1,1

4,'A70FC1C6-8ED5-4777-9535-D8FB18146D17',1,1,1

passing same questionid and same choice id

the reponse 2 for question choice id thats what i is placed 100%

but for this

2,'943B4955-BF16-4DC8-869F-9907DFC95AF7',1,3,1 it is place 50%

it depends upon the response for a question

plz watch this percentage i mentioned in this

and iam trying to get output like this

record QuestionId questiondetailindexnumber Choiceidchoicedetailcountpercentage

DF8BC368-68D7-4EC3

-9E9A-5A4B19A6C3231serader 1 1a 2100

DF8BC368-68D7-4EC3

-9E9A-5A4B19A6C3231serader 3 3other 1 50

CBC0CFE1-3EE9-4444

-A6DA-C5B9554FF25D4rader1 1 7asertin 1 100