Advertisement
Guest User

Untitled

a guest
Aug 5th, 2015
168
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. CREATE TABLE tblModules
  2. (
  3. Module_ID nvarchar(10) PRIMARY KEY,
  4. Module_Title nvarchar(MAX) NOT NULL
  5. );
  6.  
  7. CREATE TABLE tblQuestions
  8. (
  9. Q_ID int PRIMARY KEY IDENTITY(1,1),
  10. Question_Text varchar(1000) NOT NULL
  11.  
  12. );
  13.  
  14. CREATE TABLE tblFeedback
  15. (
  16. Submission_ID int PRIMARY KEY IDENTITY(1,1),
  17. Username varchar(100) NOT NULL,
  18. Domain varchar(50) NOT NULL,
  19. DateTime_Submitted datetime NOT NULL
  20. Module_ID nvarchar(10)
  21. FOREIGN KEY (Module_ID) REFERENCES tblModules (Module_ID);
  22. );
  23.  
  24. CREATE TABLE tblAnswers
  25. (
  26. Q_ID int NOT NULL,
  27. Submission_ID int NOT NULL,
  28. Answer_Text varchar(max),
  29. FOREIGN KEY (Q_ID) REFERENCES tblQuestions(Q_ID),
  30. FOREIGN KEY (Submission_ID) REFERENCES tblFeedback(Submission_ID)
  31. );
  32.  
  33. SELECT
  34. *
  35. FROM
  36. tblQuestions Q
  37. WHERE
  38. EXISTS (SELECT *
  39. FROM
  40. tblAnswers A
  41. JOIN
  42. tblFeedback F ON A.Submission_ID = F.Submission_ID
  43. WHERE
  44. Q.Q_ID = A.Q_ID AND F.Module_ID = @moduleID)
  45.  
  46. SELECT Q_ID, Question_Text tblQuestions a
  47. WHERE EXISTS (SELECT NULL FROM tblAnswers a WHERE a.Q_ID = q.Q_ID)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement