Dear All,
I have a survey application consists of 36 questions with options as
|
Strongly Agree(5)
|
Agree(4)
|
Neutral(3)
|
Disagree(2)
|
Strongly Disagree(1)
|
Sample table:
CREATE TABLE [dbo].[survey](
[Emp_Id] [varchar](50) NOT NULL,
[Question1] [int],[Question2] [int],[Question3] [int],[Question4] [int],[Question5] [int] ,[Question6] [int] ,
[Question7] [int] ,[Question8] [int] ,[Question9] [int] ,[Question10] [int], [Question11] [int], [Question12] [int] ,
[Question13] [int], ) ON [PRIMARY]
GO
Result:
|
11111
|
5
|
5
|
5
|
5
|
5
|
5
|
5
|
5
|
5
|
5
|
5
|
5
|
5
|
I want to display the survey result as options selected by the user’s percentage.
Question 1
Option selected (5) by 80%
Option selected (4) by 90%
Option selected (3) by 70%
Option selected (2) by 60%
Option selected (1) by 10%
Thanks
