Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 This works but....

Author  Topic 

karuna
Aged Yak Warrior

582 Posts
Posted - 2006-03-08 : 06:17:39
This query does what I want

SELECT * FROM 
(
SELECT VW.QuestionID, VW.MessageID, VW.QsetID, VW.SlNumber, VW.QuestionDetail, VW.AnswerID, VW.Answer, VW.QuestionTypeID,
VW.IsMandatory, VW.PageBreak, VW.NoOfSelections, VW.UserAnswer, 
VW.UserID, VW.Completed,VW.DescriptiveAnswer from vwgetquestions VW 
WHERE QSETID = 99 AND USERID = 7
UNION ALL
SELECT QD.QuestionID,0 AS MessageID, QD.QsetID, QD.SlNumber, 
QL.QuestionDetail, AL.AnswerID, AL.Answer, QL.QuestionTypeID, 
QL.IsMandatory, QL.PageBreak, QL.NoOfSelections, Null AS UserAnswer,
Null AS UserID, Null AS Completed, Null AS DescriptiveAnswer FROM 
dbo.QsetDetail AS QD INNER JOIN dbo.QuestionLibrary AS QL ON QD.QuestionID = QL.QuestionID 
INNER JOIN dbo.AnswerLibrary AS AL ON QL.QuestionID = AL.QuestionID where QD.QSETID = 99 AND
AL.ANSWERID NOT IN (SELECT ANSWERID FROM VWGETQUESTIONS WHERE QSETID = 99 AND USERID = 7)
)T  ORDER BY SLNUMBER


Is there any other better way I can rewrite this

Thanks

Karunakaran

spirit1
Cybernetic Yak Master

11752 Posts
Posted - 2006-03-08 : 07:15:45
how many results does it return?
in some cases rewriting not in to either left joi or not exists help.
but mostly proper indexing will help you the most here.

Go with the flow & have fun! Else fight the flow
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts
Posted - 2006-03-08 : 08:16:01
Please make an effort to help us help you; it is pretty lazy to just post what you have and ask "can someone re-write this for me?" Please explain what you have, what it should be doing, what you need, give some sample data, etc. Not only does that help us to help you out, but it ensures that you will understand your own problem and it ensures that you will get a good answer.
Go to Top of Page

karuna
Aged Yak Warrior

582 Posts
Posted - 2006-03-08 : 23:32:14
Will this help?

Table Scripts:

CREATE TABLE [dbo].[QuestionLibrary](
	[QuestionID] [int] NOT NULL,
	[QuestionDetail] [varchar](1000) NOT NULL,
	[CategoryID] [int] NOT NULL,
	[GroupID] [int] NOT NULL,
	[QuestionTypeID] [int] NOT NULL,
	[ClientID] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[IsMandatory] [smallint] NOT NULL,
	[NoOfSelections] [smallint] NOT NULL,
	[PageBreak] [tinyint] NOT NULL)


CREATE TABLE [dbo].[QsetProject](
	[MessageID] [int] NOT NULL,
	[QsetID] [int] NOT NULL
) 

CREATE TABLE [dbo].[QsetResponse](
	[MessageID] [int] NULL,
	[QuestionID] [int] NOT NULL,
	[AnswerID] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[Completed] [smallint] NOT NULL,
	[DescriptiveAnswer] [varchar](4000) NOT NULL,
	[QsetID] [int] NOT NULL
) 

CREATE TABLE [dbo].[QsetDetail](
	[QsetID] [int] NOT NULL,
	[QuestionID] [int] NOT NULL,
	[SlNumber] [int] NOT NULL
) 

CREATE TABLE [dbo].[AnswerLibrary](
	[AnswerID] [int] NOT NULL,
	[QuestionID] [int] NOT NULL,
	[Answer] [varchar](100) NOT NULL,
	[Score] [smallint] NOT NULL) 


CREATE VIEW [dbo].[vwGetQuestions]
AS
SELECT QP.MessageID, QD.QsetID, QD.QuestionID, QD.SlNumber, QL.QuestionDetail, AL.AnswerID, AL.Answer, QL.QuestionTypeID, 
                      QL.IsMandatory, QL.PageBreak, QL.NoOfSelections, QR.AnswerID AS UserAnswer, QR.UserID, QR.Completed, QR.DescriptiveAnswer
FROM         dbo.QsetDetail AS QD INNER JOIN
                      dbo.QuestionLibrary AS QL ON QD.QuestionID = QL.QuestionID INNER JOIN
                      dbo.AnswerLibrary AS AL ON QL.QuestionID = AL.QuestionID LEFT OUTER JOIN
                      dbo.QsetProject AS QP ON QD.QsetID = QP.QsetID LEFT OUTER JOIN
                      dbo.QsetResponse AS QR ON QR.MessageID = QP.MessageID AND QR.QuestionID = QL.QuestionID AND QR.AnswerID = AL.AnswerID


Datascripts


INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (210, 134, 't', 1)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (211, 134, 'fa', 2)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (212, 135, 'False', 1)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (213, 135, 'True', 2)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (214, 136, 'Yes', 1)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (215, 136, 'No', 2)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (216, 136, 'Yes/No', 3)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (217, 136, '<FONT face=0 size=5>Yes & No</FONT>', 0)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (218, 136, 'EWREWR', 1)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (219, 136, 'Bwer', 2)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (221, 140, 'yes ', 1)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (222, 140, 'no', 1)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (223, 140, 'not possible', 1)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (224, 140, 'possible', 1)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (225, 141, '', 1)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (226, 142, '', 1)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (227, 143, 'type 3 option 1', 1)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (228, 143, 'type 3 option 2', 1)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (229, 143, 'type 3 option 3', 1)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (230, 143, 'type 3 option 4', 1)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (231, 143, 'type 3 option 5', 1)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (232, 145, 'yes ', 1)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (233, 145, 'no', 1)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (234, 146, 'Yes', 1)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (235, 146, 'No', 0)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (236, 149, '', 0)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (237, 144, '', 0)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (238, 150, '', 0)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (239, 147, '', 0)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (240, 148, '', 0)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (241, 151, '', 0)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (244, 151, 'New Question', 99)
INSERT INTO [dbo].[AnswerLibrary] ([AnswerID], [QuestionID], [Answer], [Score]) VALUES (245, 151, 'New Question', 99)

INSERT INTO [dbo].[QsetProject] ([MessageID], [QsetID]) VALUES (7, 65)
INSERT INTO [dbo].[QsetProject] ([MessageID], [QsetID]) VALUES (8, 65)
INSERT INTO [dbo].[QsetProject] ([MessageID], [QsetID]) VALUES (11, 100)
INSERT INTO [dbo].[QsetProject] ([MessageID], [QsetID]) VALUES (12, 106)
INSERT INTO [dbo].[QsetProject] ([MessageID], [QsetID]) VALUES (14, 105)
INSERT INTO [dbo].[QsetProject] ([MessageID], [QsetID]) VALUES (0, 95)
INSERT INTO [dbo].[QsetProject] ([MessageID], [QsetID]) VALUES (0, 96)
INSERT INTO [dbo].[QsetProject] ([MessageID], [QsetID]) VALUES (0, 97)
INSERT INTO [dbo].[QsetProject] ([MessageID], [QsetID]) VALUES (0, 98)
INSERT INTO [dbo].[QsetProject] ([MessageID], [QsetID]) VALUES (0, 99)
INSERT INTO [dbo].[QsetProject] ([MessageID], [QsetID]) VALUES (0, 101)
INSERT INTO [dbo].[QsetProject] ([MessageID], [QsetID]) VALUES (0, 102)
INSERT INTO [dbo].[QsetProject] ([MessageID], [QsetID]) VALUES (0, 103)
INSERT INTO [dbo].[QsetProject] ([MessageID], [QsetID]) VALUES (0, 104)
INSERT INTO [dbo].[QsetProject] ([MessageID], [QsetID]) VALUES (15, 99)
INSERT INTO [dbo].[QsetProject] ([MessageID], [QsetID]) VALUES (0, 100)

INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (108, 136, 1)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (95, 134, 1)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (95, 137, 2)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (95, 135, 3)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (95, 136, 4)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (106, 141, 9)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (61, 4, 1)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (61, 8, 2)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (106, 134, 1)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (106, 147, 3)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (106, 148, 4)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (106, 149, 5)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (106, 150, 6)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (61, 14, 4)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (106, 135, 7)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (61, 17, 5)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (106, 136, 8)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (61, 24, 6)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (106, 142, 10)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (106, 143, 11)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (106, 144, 12)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (106, 145, 13)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (106, 140, 15)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (108, 141, 2)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (108, 142, 3)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (108, 143, 4)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (108, 144, 5)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (65, 134, 12)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (65, 135, 23)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (65, 136, 34)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (108, 145, 6)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (108, 135, 7)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (108, 151, 8)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (108, 150, 9)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (108, 149, 10)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (108, 148, 11)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (108, 147, 12)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (61, 9, 3)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (104, 149, 3)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (104, 134, 1)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (104, 146, 2)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (104, 148, 4)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (105, 150, 4)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (105, 134, 1)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (105, 146, 2)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (105, 149, 3)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (105, 142, 5)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (105, 144, 7)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (105, 143, 6)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (96, 134, 1)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (96, 137, 2)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (96, 135, 3)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (96, 136, 4)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (96, 140, 5)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (97, 134, 1)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (97, 135, 2)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (97, 136, 3)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (97, 141, 4)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (97, 140, 5)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (98, 134, 1)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (98, 135, 2)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (98, 136, 3)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (98, 141, 6)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (98, 142, 4)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (98, 140, 5)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (99, 134, 1)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (99, 135, 5)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (99, 143, 2)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (99, 140, 3)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (99, 136, 4)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (99, 141, 6)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (99, 142, 7)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (100, 134, 1)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (100, 136, 2)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (100, 143, 3)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (100, 141, 4)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (100, 140, 5)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (100, 142, 6)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (100, 144, 7)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (100, 135, 8)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (101, 145, 1)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (101, 134, 2)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (101, 135, 3)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (101, 141, 4)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (101, 143, 5)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (101, 144, 6)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (101, 140, 7)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (101, 142, 8)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (101, 136, 9)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (102, 134, 1)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (102, 135, 2)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (102, 136, 3)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (102, 141, 4)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (102, 142, 5)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (102, 143, 6)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (102, 144, 7)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (102, 145, 8)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (102, 140, 9)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (103, 146, 1)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (103, 147, 2)
INSERT INTO [dbo].[QsetDetail] ([QsetID], [QuestionID], [SlNumber]) VALUES (106, 146, 2)

INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (0, 143, 228, 2, 0, '', 100)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (11, 143, 229, 6, 0, '', 100)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (11, 142, 226, 6, 0, 'ssss', 100)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (14, 143, 230, 6, 0, '', 105)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (15, 134, 211, 6, 0, '', 99)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (11, 135, 212, 6, 0, '', 100)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (7, 135, 213, 6, 0, '', 65)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (14, 144, 237, 6, 0, 'xxxxx', 105)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (15, 142, 226, 6, 0, 'sssss', 99)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (15, 143, 228, 6, 0, '', 99)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (11, 143, 230, 6, 0, '', 100)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (14, 134, 211, 6, 0, '', 105)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (14, 146, 235, 6, 0, '', 105)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (15, 143, 229, 6, 0, '', 99)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (15, 140, 222, 6, 0, '', 99)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (0, 145, 232, 2, 0, '', 102)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (15, 136, 217, 6, 0, '', 99)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (0, 146, 234, 2, 0, '', 104)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (0, 134, 211, 7, 0, '', 99)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (0, 143, 230, 7, 0, '', 99)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (14, 143, 231, 6, 0, '', 105)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (11, 134, 210, 6, 0, '', 100)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (0, 140, 223, 2, 0, '', 100)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (0, 142, 226, 2, 0, 'aaaa', 100)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (0, 144, 237, 2, 0, 'aaaa', 100)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (7, 136, 214, 6, 0, '', 65)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (14, 149, 236, 6, 0, 'pp', 105)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (0, 143, 229, 2, 0, '', 100)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (0, 149, 236, 2, 0, 'klklklk', 104)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (0, 134, 210, 2, 0, '', 100)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (0, 143, 227, 7, 0, '', 99)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (7, 134, 211, 6, 0, '', 65)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (0, 141, 225, 2, 0, 'aaaa', 98)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (14, 150, 238, 6, 0, 'lllll', 105)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (14, 142, 226, 6, 0, 'llll', 105)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (11, 136, 214, 6, 0, '', 100)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (11, 140, 222, 6, 0, '', 100)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (0, 136, 218, 2, 0, '', 100)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (15, 135, 213, 6, 0, '', 99)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (15, 144, 237, 6, 0, 'ssss', 100)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (0, 135, 212, 2, 0, '', 102)
INSERT INTO [dbo].[QsetResponse] ([MessageID], [QuestionID], [AnswerID], [UserID], [Completed], [DescriptiveAnswer], [QsetID]) VALUES (11, 144, 237, 6, 0, 'sssss', 100)

INSERT INTO [dbo].[QuestionLibrary] ([QuestionID], [QuestionDetail], [CategoryID], [GroupID], [QuestionTypeID], [ClientID], [UserID], [IsMandatory], [NoOfSelections], [PageBreak]) 
VALUES (134, 'New for User 6', 1, 1, 1, 1, 6, 0, 1, 0)
INSERT INTO [dbo].[QuestionLibrary] ([QuestionID], [QuestionDetail], [CategoryID], [GroupID], [QuestionTypeID], [ClientID], [UserID], [IsMandatory], [NoOfSelections], [PageBreak]) 
VALUES (135, 'New', 2, 1, 1, 1, 6, 1, 1, 1)
INSERT INTO [dbo].[QuestionLibrary] ([QuestionID], [QuestionDetail], [CategoryID], [GroupID], [QuestionTypeID], [ClientID], [UserID], [IsMandatory], [NoOfSelections], [PageBreak]) 
VALUES (136, 'Question?', 3, 1, 4, 1, 6, 1, 1, 1)
INSERT INTO [dbo].[QuestionLibrary] ([QuestionID], [QuestionDetail], [CategoryID], [GroupID], [QuestionTypeID], [ClientID], [UserID], [IsMandatory], [NoOfSelections], [PageBreak]) 
VALUES (140, 'Question 2 ?', 4, 5, 2, 1, 6, 1, 1, 1)
INSERT INTO [dbo].[QuestionLibrary] ([QuestionID], [QuestionDetail], [CategoryID], [GroupID], [QuestionTypeID], [ClientID], [UserID], [IsMandatory], [NoOfSelections], [PageBreak]) 
VALUES (141, 'Comments?', 3, 5, 7, 1, 6, 0, 1, 1)
INSERT INTO [dbo].[QuestionLibrary] ([QuestionID], [QuestionDetail], [CategoryID], [GroupID], [QuestionTypeID], [ClientID], [UserID], [IsMandatory], [NoOfSelections], [PageBreak]) 
VALUES (142, 'Question type 5?', 3, 5, 5, 1, 6, 1, 1, 1)
INSERT INTO [dbo].[QuestionLibrary] ([QuestionID], [QuestionDetail], [CategoryID], [GroupID], [QuestionTypeID], [ClientID], [UserID], [IsMandatory], [NoOfSelections], [PageBreak]) 
VALUES (143, 'Question type 3?', 3, 5, 3, 1, 6, 1, 2, 1)
INSERT INTO [dbo].[QuestionLibrary] ([QuestionID], [QuestionDetail], [CategoryID], [GroupID], [QuestionTypeID], [ClientID], [UserID], [IsMandatory], [NoOfSelections], [PageBreak]) 
VALUES (144, 'Question type 6?', 3, 5, 6, 1, 6, 1, 1, 1)
INSERT INTO [dbo].[QuestionLibrary] ([QuestionID], [QuestionDetail], [CategoryID], [GroupID], [QuestionTypeID], [ClientID], [UserID], [IsMandatory], [NoOfSelections], [PageBreak]) 
VALUES (145, 'Question type 1?', 3, 5, 1, 1, 6, 1, 1, 1)
INSERT INTO [dbo].[QuestionLibrary] ([QuestionID], [QuestionDetail], [CategoryID], [GroupID], [QuestionTypeID], [ClientID], [UserID], [IsMandatory], [NoOfSelections], [PageBreak]) 
VALUES (146, 'Testing Qset 103 - Q1', 1, 1, 1, 1, 6, 1, 1, 1)
INSERT INTO [dbo].[QuestionLibrary] ([QuestionID], [QuestionDetail], [CategoryID], [GroupID], [QuestionTypeID], [ClientID], [UserID], [IsMandatory], [NoOfSelections], [PageBreak]) 
VALUES (147, 'Testing Qset 103 - Q2 - Comment', 1, 1, 7, 1, 6, 1, 1, 1)
INSERT INTO [dbo].[QuestionLibrary] ([QuestionID], [QuestionDetail], [CategoryID], [GroupID], [QuestionTypeID], [ClientID], [UserID], [IsMandatory], [NoOfSelections], [PageBreak]) 
VALUES (148, 'test comment for answer insert', 1, 1, 7, 1, 6, 1, 1, 1)
INSERT INTO [dbo].[QuestionLibrary] ([QuestionID], [QuestionDetail], [CategoryID], [GroupID], [QuestionTypeID], [ClientID], [UserID], [IsMandatory], [NoOfSelections], [PageBreak]) 
VALUES (149, 'question 6?', 1, 1, 6, 1, 6, 1, 1, 1)
INSERT INTO [dbo].[QuestionLibrary] ([QuestionID], [QuestionDetail], [CategoryID], [GroupID], [QuestionTypeID], [ClientID], [UserID], [IsMandatory], [NoOfSelections], [PageBreak]) 
VALUES (150, 'Question test 6 type?', 1, 1, 5, 1, 6, 1, 1, 1)
INSERT INTO [dbo].[QuestionLibrary] ([QuestionID], [QuestionDetail], [CategoryID], [GroupID], [QuestionTypeID], [ClientID], [UserID], [IsMandatory], [NoOfSelections], [PageBreak]) 
VALUES (151, 'comment 2.', 1, 1, 7, 1, 6, 0, 1, 1)


Karunakaran
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site