Out of four option choose the one answer agnist the question

Debasis Mohapatra

7y795

I have three table

stype table,question table and the final table is fivesquestiondetails.

both the primay key id i have inserted in fivesquestiondetails table. Please check the my below store procedure code.

CREATE PROCEDURE [dbo].[questionrecords]
AS
SET NOCOUNT ON
BEGIN
BEGIN TRY
BEGIN
select distinct q.question_name as 'Question',qd.question_option as 'Option',s.name from [dbo].[five_s_question] q inner join
[dbo].[five_s_question_details] qd on q.id=qd.question_id inner join [dbo].[five_s_sitetype] s on s.id=qd.stype_id
END
END TRY
BEGIN CATCH
DECLARE @ErrorMessage VARCHAR(MAX);
SELECT @ErrorMessage ='There was a problem trying to Retrieve Course Type'
+ Char(13) + Char(10) + 'The error was: ' + Char(13) + Char(10) + ERROR_MESSAGE()
RAISERROR (@ErrorMessage, 16, 1)
END CATCH
END
--exec questionrecords

three tables

[dbo].[five_s_sitetype]

id, name, cbu, doc, mbu, dom

[dbo].[five_s_question]

id, question_name, weightage, stype_id, cbu, doc, mbu, dom, qstatus

[dbo].[five_s_question_details]

id, question_id, question_option, details_weightage, stype_name, stype_id, cbu, doc, mbu, dom

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Debasis Mohapatra7y ago
Eaither i can do with MVC with eninty frmae work or i can do another way through repository. once the procedure will done the i will make it the project in MVC
0
Debasis Mohapatra7y ago
The design will be when the user select stype in the drop of box s1 the question will display with 4 option.

my table is there

stype_id - FK
question_id-FK

final table is [dbo].[five_s_question_details]
0
Debasis Mohapatra7y ago
Query is that i want to write a store procedure to display the

question 1. what is your name.

Option: X
Option Y
Option Z
Option D

once the query will procedure will done i will implate in the MVC code to display the view part.
0
Shweta Lodha7y ago
What is your query?
0