Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE tblModules
- (
- Module_ID nvarchar(10) PRIMARY KEY,
- Module_Title nvarchar(MAX) NOT NULL
- );
- CREATE TABLE tblQuestions
- (
- Q_ID int PRIMARY KEY IDENTITY(1,1),
- Question_Text varchar(1000) NOT NULL
- );
- CREATE TABLE tblFeedback
- (
- Submission_ID int PRIMARY KEY IDENTITY(1,1),
- Username varchar(100) NOT NULL,
- Domain varchar(50) NOT NULL,
- DateTime_Submitted datetime NOT NULL
- Module_ID nvarchar(10)
- FOREIGN KEY (Module_ID) REFERENCES tblModules (Module_ID);
- );
- CREATE TABLE tblAnswers
- (
- Q_ID int NOT NULL,
- Submission_ID int NOT NULL,
- Answer_Text varchar(max),
- FOREIGN KEY (Q_ID) REFERENCES tblQuestions(Q_ID),
- FOREIGN KEY (Submission_ID) REFERENCES tblFeedback(Submission_ID)
- );
- SELECT
- *
- FROM
- tblQuestions Q
- WHERE
- EXISTS (SELECT *
- FROM
- tblAnswers A
- JOIN
- tblFeedback F ON A.Submission_ID = F.Submission_ID
- WHERE
- Q.Q_ID = A.Q_ID AND F.Module_ID = @moduleID)
- SELECT Q_ID, Question_Text tblQuestions a
- WHERE EXISTS (SELECT NULL FROM tblAnswers a WHERE a.Q_ID = q.Q_ID)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement