Difference between revisions of "Notes"
m |
m |
||
| Line 14: | Line 14: | ||
*UpdateQuota: update all RPQs' quotas status | *UpdateQuota: update all RPQs' quotas status | ||
| − | == Testing tips == | + | == Testing tips == |
=== Questionnaire Property === | === Questionnaire Property === | ||
| Line 20: | Line 20: | ||
CREATE TABLE #Questionnaire_Property(<br>P_Id int,<br>P_Description nvarchar(50)<br>) | CREATE TABLE #Questionnaire_Property(<br>P_Id int,<br>P_Description nvarchar(50)<br>) | ||
| − | <br>INSERT INTO #Questionnaire_Property VALUES(1,'Required')<br>INSERT INTO #Questionnaire_Property VALUES(2,'RandomizeAnswerOptions')<br>INSERT INTO #Questionnaire_Property VALUES(3,'RotateAnswerOptions')<br>INSERT INTO #Questionnaire_Property VALUES(4,'Maximum')<br>INSERT INTO #Questionnaire_Property VALUES(5,'Minimum')<br>INSERT INTO #Questionnaire_Property VALUES(6,'Dummy')<br>INSERT INTO #Questionnaire_Property VALUES(7,'NoMulti')<br>INSERT INTO #Questionnaire_Property VALUES(8,'End')<br>INSERT INTO #Questionnaire_Property VALUES(9,'Sound')<br>INSERT INTO #Questionnaire_Property VALUES(10,'Step')<br>INSERT INTO #Questionnaire_Property VALUES(11,'Discrete')<br>INSERT INTO #Questionnaire_Property VALUES(12,'Direction')<br>INSERT INTO #Questionnaire_Property VALUES(13,'MinimumText')<br>INSERT INTO #Questionnaire_Property VALUES(14,'MaximumText')<br>INSERT INTO #Questionnaire_Property VALUES(15,'Reverse')<br>INSERT INTO #Questionnaire_Property VALUES(16,'AllRequired')<br>INSERT INTO #Questionnaire_Property VALUES(17,'NotRequired')<br>INSERT INTO #Questionnaire_Property VALUES(18,'BackButtonVisible')<br>INSERT INTO #Questionnaire_Property VALUES(19,'BackButtonText')<br>INSERT INTO #Questionnaire_Property VALUES(20,'CloseButtonVisible')<br>INSERT INTO #Questionnaire_Property VALUES(21,'CloseButtonText')<br>INSERT INTO #Questionnaire_Property VALUES(22,'NextButtonVisible')<br>INSERT INTO #Questionnaire_Property VALUES(23,'NextButtonText')<br>INSERT INTO #Questionnaire_Property VALUES(24,'RandomizeSubQuestions')<br>INSERT INTO #Questionnaire_Property VALUES(25,'RotateSubQuestions')<br>INSERT INTO #Questionnaire_Property VALUES(26,'MinimumScaleValue')<br>INSERT INTO #Questionnaire_Property VALUES(27,'MaximumScaleValue')<br>INSERT INTO #Questionnaire_Property VALUES(28,'MinimumMultiValue')<br>INSERT INTO #Questionnaire_Property VALUES(29,'MaximumMultiValue')<br>INSERT INTO #Questionnaire_Property VALUES(30,'MinimumNumberValue')<br>INSERT INTO #Questionnaire_Property VALUES(31,'MaximumNumberValue')<br>INSERT INTO #Questionnaire_Property VALUES(32,'Script')<br>INSERT INTO #Questionnaire_Property VALUES(33,'OpenAnswerOptions')<br>INSERT INTO #Questionnaire_Property VALUES(34,'QuestionnaireNotOpenText')<br>INSERT INTO #Questionnaire_Property VALUES(35,'QuestionnaireUnauthorizedAccessText')<br>INSERT INTO #Questionnaire_Property VALUES(36,'QuestionnaireClosedText')<br>INSERT INTO #Questionnaire_Property VALUES(37,'QuestionnaireEndText')<br>INSERT INTO #Questionnaire_Property VALUES(38,'QuestionnairePausedText')<br>INSERT INTO #Questionnaire_Property VALUES(39,'QuestionnaireCompletedText')<br>INSERT INTO #Questionnaire_Property VALUES(40,'QuestionnaireBeforeStartDateText')<br>INSERT INTO #Questionnaire_Property VALUES(41,'QuestionnaireAfterEndDateText')<br>INSERT INTO #Questionnaire_Property VALUES(42,'NotRequiredAll')<br>INSERT INTO #Questionnaire_Property VALUES(43,'ResetButtonVisible')<br>INSERT INTO #Questionnaire_Property VALUES(44,'ResetButtonText')<br>INSERT INTO #Questionnaire_Property VALUES(45,'Layout')<br>INSERT INTO #Questionnaire_Property VALUES(46,'Impsys')<br>INSERT INTO #Questionnaire_Property VALUES(47,'QuestionnaireRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(48,'QuestionnaireMinRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(49,'QuestionnaireMaxRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(50,'QuestionnaireNumberRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(51,'QuestionnaireMinValRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(52,'QuestionnaireMaxValRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(53,'QuestionnaireNoFloatValText')<br>INSERT INTO #Questionnaire_Property VALUES(54,'QuestionnaireNumberOverflow')<br>INSERT INTO #Questionnaire_Property VALUES(55,'QuestionnaireInGridRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(56,'QuestionnaireMinInGridRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(57,'QuestionnaireMaxInGridRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(58,'QuestionnaireIllegalTypeText')<br>INSERT INTO #Questionnaire_Property VALUES(59,'EndPoints')<br>INSERT INTO #Questionnaire_Property VALUES(60,'PointText')<br>INSERT INTO #Questionnaire_Property VALUES(61,'Unit')<br>INSERT INTO #Questionnaire_Property VALUES(62,'DefaultAnswerOption')<br>INSERT INTO #Questionnaire_Property VALUES(63,'Compact')<br>INSERT INTO #Questionnaire_Property VALUES(64,'AutoArrangeAnswerOptions')<br>INSERT INTO #Questionnaire_Property VALUES(65,'AnswerOptionColumns')<br>INSERT INTO #Questionnaire_Property VALUES(66,'AnswerOptionRows')<br>INSERT INTO #Questionnaire_Property VALUES(67,'QuestionnaireCatiMode')<br>INSERT INTO #Questionnaire_Property VALUES(68,'Countdown')<br>INSERT INTO #Questionnaire_Property VALUES(69,'AnswerOptionUniqueChoice')<br>INSERT INTO #Questionnaire_Property VALUES(70,'QuestionStylesheet')<br>INSERT INTO #Questionnaire_Property VALUES(71,'FlashPath')<br>INSERT INTO #Questionnaire_Property VALUES(72,'FlashHeight')<br>INSERT INTO #Questionnaire_Property VALUES(73,'FlashWidth')<br>INSERT INTO #Questionnaire_Property VALUES(74,'QuestionnaireOnBegin')<br>INSERT INTO #Questionnaire_Property VALUES(75,'QuestionnaireOnCompleted')<br>INSERT INTO #Questionnaire_Property VALUES(76,'RPQStatus')<br>INSERT INTO #Questionnaire_Property VALUES(77,'ImpSysRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(78,'ImpSysSelectionText')<br>INSERT INTO #Questionnaire_Property VALUES(79,'ImpSysChoiceText')<br>INSERT INTO #Questionnaire_Property VALUES(80,'ImpSysGender')<br>INSERT INTO #Questionnaire_Property VALUES(81,'AllowDecimals')<br>INSERT INTO #Questionnaire_Property VALUES(82,'AllowDecimalsInterval')<br>INSERT INTO #Questionnaire_Property VALUES(83,'NumericalInterval')<br>INSERT INTO #Questionnaire_Property VALUES(84,'ExportPosition')<br>INSERT INTO #Questionnaire_Property VALUES(85,'ExportLength')<br>INSERT INTO #Questionnaire_Property VALUES(86,'OpenAnswerRequired')<br>INSERT INTO #Questionnaire_Property VALUES(87,'AlphabeticalTab')<br>INSERT INTO #Questionnaire_Property VALUES(88,'RepresentAsDropDown')<br>INSERT INTO #Questionnaire_Property VALUES(89,'IsShadowQuestion')<br>INSERT INTO #Questionnaire_Property VALUES(90,'QuestionInCludeInPage') | + | <br>INSERT INTO #Questionnaire_Property VALUES(1,'Required')<br>INSERT INTO #Questionnaire_Property VALUES(2,'RandomizeAnswerOptions')<br>INSERT INTO #Questionnaire_Property VALUES(3,'RotateAnswerOptions')<br>INSERT INTO #Questionnaire_Property VALUES(4,'Maximum')<br>INSERT INTO #Questionnaire_Property VALUES(5,'Minimum')<br>INSERT INTO #Questionnaire_Property VALUES(6,'Dummy')<br>INSERT INTO #Questionnaire_Property VALUES(7,'NoMulti')<br>INSERT INTO #Questionnaire_Property VALUES(8,'End')<br>INSERT INTO #Questionnaire_Property VALUES(9,'Sound')<br>INSERT INTO #Questionnaire_Property VALUES(10,'Step')<br>INSERT INTO #Questionnaire_Property VALUES(11,'Discrete')<br>INSERT INTO #Questionnaire_Property VALUES(12,'Direction')<br>INSERT INTO #Questionnaire_Property VALUES(13,'MinimumText')<br>INSERT INTO #Questionnaire_Property VALUES(14,'MaximumText')<br>INSERT INTO #Questionnaire_Property VALUES(15,'Reverse')<br>INSERT INTO #Questionnaire_Property VALUES(16,'AllRequired')<br>INSERT INTO #Questionnaire_Property VALUES(17,'NotRequired')<br>INSERT INTO #Questionnaire_Property VALUES(18,'BackButtonVisible')<br>INSERT INTO #Questionnaire_Property VALUES(19,'BackButtonText')<br>INSERT INTO #Questionnaire_Property VALUES(20,'CloseButtonVisible')<br>INSERT INTO #Questionnaire_Property VALUES(21,'CloseButtonText')<br>INSERT INTO #Questionnaire_Property VALUES(22,'NextButtonVisible')<br>INSERT INTO #Questionnaire_Property VALUES(23,'NextButtonText')<br>INSERT INTO #Questionnaire_Property VALUES(24,'RandomizeSubQuestions')<br>INSERT INTO #Questionnaire_Property VALUES(25,'RotateSubQuestions')<br>INSERT INTO #Questionnaire_Property VALUES(26,'MinimumScaleValue')<br>INSERT INTO #Questionnaire_Property VALUES(27,'MaximumScaleValue')<br>INSERT INTO #Questionnaire_Property VALUES(28,'MinimumMultiValue')<br>INSERT INTO #Questionnaire_Property VALUES(29,'MaximumMultiValue')<br>INSERT INTO #Questionnaire_Property VALUES(30,'MinimumNumberValue')<br>INSERT INTO #Questionnaire_Property VALUES(31,'MaximumNumberValue')<br>INSERT INTO #Questionnaire_Property VALUES(32,'Script')<br>INSERT INTO #Questionnaire_Property VALUES(33,'OpenAnswerOptions')<br>INSERT INTO #Questionnaire_Property VALUES(34,'QuestionnaireNotOpenText')<br>INSERT INTO #Questionnaire_Property VALUES(35,'QuestionnaireUnauthorizedAccessText')<br>INSERT INTO #Questionnaire_Property VALUES(36,'QuestionnaireClosedText')<br>INSERT INTO #Questionnaire_Property VALUES(37,'QuestionnaireEndText')<br>INSERT INTO #Questionnaire_Property VALUES(38,'QuestionnairePausedText')<br>INSERT INTO #Questionnaire_Property VALUES(39,'QuestionnaireCompletedText')<br>INSERT INTO #Questionnaire_Property VALUES(40,'QuestionnaireBeforeStartDateText')<br>INSERT INTO #Questionnaire_Property VALUES(41,'QuestionnaireAfterEndDateText')<br>INSERT INTO #Questionnaire_Property VALUES(42,'NotRequiredAll')<br>INSERT INTO #Questionnaire_Property VALUES(43,'ResetButtonVisible')<br>INSERT INTO #Questionnaire_Property VALUES(44,'ResetButtonText')<br>INSERT INTO #Questionnaire_Property VALUES(45,'Layout')<br>INSERT INTO #Questionnaire_Property VALUES(46,'Impsys')<br>INSERT INTO #Questionnaire_Property VALUES(47,'QuestionnaireRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(48,'QuestionnaireMinRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(49,'QuestionnaireMaxRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(50,'QuestionnaireNumberRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(51,'QuestionnaireMinValRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(52,'QuestionnaireMaxValRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(53,'QuestionnaireNoFloatValText')<br>INSERT INTO #Questionnaire_Property VALUES(54,'QuestionnaireNumberOverflow')<br>INSERT INTO #Questionnaire_Property VALUES(55,'QuestionnaireInGridRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(56,'QuestionnaireMinInGridRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(57,'QuestionnaireMaxInGridRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(58,'QuestionnaireIllegalTypeText')<br>INSERT INTO #Questionnaire_Property VALUES(59,'EndPoints')<br>INSERT INTO #Questionnaire_Property VALUES(60,'PointText')<br>INSERT INTO #Questionnaire_Property VALUES(61,'Unit')<br>INSERT INTO #Questionnaire_Property VALUES(62,'DefaultAnswerOption')<br>INSERT INTO #Questionnaire_Property VALUES(63,'Compact')<br>INSERT INTO #Questionnaire_Property VALUES(64,'AutoArrangeAnswerOptions')<br>INSERT INTO #Questionnaire_Property VALUES(65,'AnswerOptionColumns')<br>INSERT INTO #Questionnaire_Property VALUES(66,'AnswerOptionRows')<br>INSERT INTO #Questionnaire_Property VALUES(67,'QuestionnaireCatiMode')<br>INSERT INTO #Questionnaire_Property VALUES(68,'Countdown')<br>INSERT INTO #Questionnaire_Property VALUES(69,'AnswerOptionUniqueChoice')<br>INSERT INTO #Questionnaire_Property VALUES(70,'QuestionStylesheet')<br>INSERT INTO #Questionnaire_Property VALUES(71,'FlashPath')<br>INSERT INTO #Questionnaire_Property VALUES(72,'FlashHeight')<br>INSERT INTO #Questionnaire_Property VALUES(73,'FlashWidth')<br>INSERT INTO #Questionnaire_Property VALUES(74,'QuestionnaireOnBegin')<br>INSERT INTO #Questionnaire_Property VALUES(75,'QuestionnaireOnCompleted')<br>INSERT INTO #Questionnaire_Property VALUES(76,'RPQStatus')<br>INSERT INTO #Questionnaire_Property VALUES(77,'ImpSysRequiredText')<br>INSERT INTO #Questionnaire_Property VALUES(78,'ImpSysSelectionText')<br>INSERT INTO #Questionnaire_Property VALUES(79,'ImpSysChoiceText')<br>INSERT INTO #Questionnaire_Property VALUES(80,'ImpSysGender')<br>INSERT INTO #Questionnaire_Property VALUES(81,'AllowDecimals')<br>INSERT INTO #Questionnaire_Property VALUES(82,'AllowDecimalsInterval')<br>INSERT INTO #Questionnaire_Property VALUES(83,'NumericalInterval')<br>INSERT INTO #Questionnaire_Property VALUES(84,'ExportPosition')<br>INSERT INTO #Questionnaire_Property VALUES(85,'ExportLength')<br>INSERT INTO #Questionnaire_Property VALUES(86,'OpenAnswerRequired')<br>INSERT INTO #Questionnaire_Property VALUES(87,'AlphabeticalTab')<br>INSERT INTO #Questionnaire_Property VALUES(88,'RepresentAsDropDown')<br>INSERT INTO #Questionnaire_Property VALUES(89,'IsShadowQuestion')<br>INSERT INTO #Questionnaire_Property VALUES(90,'QuestionInCludeInPage') |
| − | DROP TABLE #Questionnaire_Property | + | DROP TABLE #Questionnaire_Property |
| − | === | + | <br> |
| + | |||
| + | === Questionnaire's Question === | ||
| + | |||
| + | DECLARE @Q_Id INT<br>SET @Q_Id = '3424' | ||
| + | |||
| + | SELECT q.*, <br>(<br>CASE q.[Question_Type]<br>WHEN 1<br>THEN (SELECT 'Single')<br>WHEN 2<br>THEN (SELECT 'Multi')<br>WHEN 3<br>THEN (SELECT 'Number')<br>WHEN 4<br>THEN (SELECT 'Text')<br>WHEN 5<br>THEN (SELECT 'Open')<br>WHEN 6<br>THEN (SELECT 'SingleGrid')<br>WHEN 7<br>THEN (SELECT 'MultiGrid')<br>WHEN 8<br>THEN (SELECT 'TextGrid')<br>WHEN 9<br>THEN (SELECT 'Page')<br>WHEN 10<br>THEN (SELECT 'Multimedia')<br>WHEN 11<br>THEN (SELECT 'Scale')<br>WHEN 12<br>THEN (SELECT 'ScaleGrid')<br>ELSE ''<br>END<br>) AS [Type_Description],<br>qq.[Question_Index]<br>FROM [Question] q INNER JOIN<br>[Questionnaire_Question] qq ON q.[id] = qq.[Question_Id]<br>WHERE qq.[Questionnaire_Id] = (SELECT [Questionnaire_Id] FROM [Project_Questionnaire] WHERE [Id] = @Q_Id)<br>ORDER BY qq.[Question_Index]Copying Project Questionnaire | ||
Revision as of 09:06, 5 March 2009
Quota
RPQ is registered in the quota_resource_project_questionnaire table when:
- checkAllQuotas() cgs function is called.
- UpdateQuota function on quota tab is called
- User moves to the last question of the rpq. In this case, rpq must be completed to be in the quota_resource_project_questionnaire table. However, if user moves to the previous question from the last question, the rpq is still in the table even though it is not completed.
The difference between checkAllQuotas(), CGS function, and UpdateQuota, GUI feature:
- CheckAllQuotas(): update the RPQ's quotas status.
- UpdateQuota: update all RPQs' quotas status
Testing tips
Questionnaire Property
CREATE TABLE #Questionnaire_Property(
P_Id int,
P_Description nvarchar(50)
)
INSERT INTO #Questionnaire_Property VALUES(1,'Required')
INSERT INTO #Questionnaire_Property VALUES(2,'RandomizeAnswerOptions')
INSERT INTO #Questionnaire_Property VALUES(3,'RotateAnswerOptions')
INSERT INTO #Questionnaire_Property VALUES(4,'Maximum')
INSERT INTO #Questionnaire_Property VALUES(5,'Minimum')
INSERT INTO #Questionnaire_Property VALUES(6,'Dummy')
INSERT INTO #Questionnaire_Property VALUES(7,'NoMulti')
INSERT INTO #Questionnaire_Property VALUES(8,'End')
INSERT INTO #Questionnaire_Property VALUES(9,'Sound')
INSERT INTO #Questionnaire_Property VALUES(10,'Step')
INSERT INTO #Questionnaire_Property VALUES(11,'Discrete')
INSERT INTO #Questionnaire_Property VALUES(12,'Direction')
INSERT INTO #Questionnaire_Property VALUES(13,'MinimumText')
INSERT INTO #Questionnaire_Property VALUES(14,'MaximumText')
INSERT INTO #Questionnaire_Property VALUES(15,'Reverse')
INSERT INTO #Questionnaire_Property VALUES(16,'AllRequired')
INSERT INTO #Questionnaire_Property VALUES(17,'NotRequired')
INSERT INTO #Questionnaire_Property VALUES(18,'BackButtonVisible')
INSERT INTO #Questionnaire_Property VALUES(19,'BackButtonText')
INSERT INTO #Questionnaire_Property VALUES(20,'CloseButtonVisible')
INSERT INTO #Questionnaire_Property VALUES(21,'CloseButtonText')
INSERT INTO #Questionnaire_Property VALUES(22,'NextButtonVisible')
INSERT INTO #Questionnaire_Property VALUES(23,'NextButtonText')
INSERT INTO #Questionnaire_Property VALUES(24,'RandomizeSubQuestions')
INSERT INTO #Questionnaire_Property VALUES(25,'RotateSubQuestions')
INSERT INTO #Questionnaire_Property VALUES(26,'MinimumScaleValue')
INSERT INTO #Questionnaire_Property VALUES(27,'MaximumScaleValue')
INSERT INTO #Questionnaire_Property VALUES(28,'MinimumMultiValue')
INSERT INTO #Questionnaire_Property VALUES(29,'MaximumMultiValue')
INSERT INTO #Questionnaire_Property VALUES(30,'MinimumNumberValue')
INSERT INTO #Questionnaire_Property VALUES(31,'MaximumNumberValue')
INSERT INTO #Questionnaire_Property VALUES(32,'Script')
INSERT INTO #Questionnaire_Property VALUES(33,'OpenAnswerOptions')
INSERT INTO #Questionnaire_Property VALUES(34,'QuestionnaireNotOpenText')
INSERT INTO #Questionnaire_Property VALUES(35,'QuestionnaireUnauthorizedAccessText')
INSERT INTO #Questionnaire_Property VALUES(36,'QuestionnaireClosedText')
INSERT INTO #Questionnaire_Property VALUES(37,'QuestionnaireEndText')
INSERT INTO #Questionnaire_Property VALUES(38,'QuestionnairePausedText')
INSERT INTO #Questionnaire_Property VALUES(39,'QuestionnaireCompletedText')
INSERT INTO #Questionnaire_Property VALUES(40,'QuestionnaireBeforeStartDateText')
INSERT INTO #Questionnaire_Property VALUES(41,'QuestionnaireAfterEndDateText')
INSERT INTO #Questionnaire_Property VALUES(42,'NotRequiredAll')
INSERT INTO #Questionnaire_Property VALUES(43,'ResetButtonVisible')
INSERT INTO #Questionnaire_Property VALUES(44,'ResetButtonText')
INSERT INTO #Questionnaire_Property VALUES(45,'Layout')
INSERT INTO #Questionnaire_Property VALUES(46,'Impsys')
INSERT INTO #Questionnaire_Property VALUES(47,'QuestionnaireRequiredText')
INSERT INTO #Questionnaire_Property VALUES(48,'QuestionnaireMinRequiredText')
INSERT INTO #Questionnaire_Property VALUES(49,'QuestionnaireMaxRequiredText')
INSERT INTO #Questionnaire_Property VALUES(50,'QuestionnaireNumberRequiredText')
INSERT INTO #Questionnaire_Property VALUES(51,'QuestionnaireMinValRequiredText')
INSERT INTO #Questionnaire_Property VALUES(52,'QuestionnaireMaxValRequiredText')
INSERT INTO #Questionnaire_Property VALUES(53,'QuestionnaireNoFloatValText')
INSERT INTO #Questionnaire_Property VALUES(54,'QuestionnaireNumberOverflow')
INSERT INTO #Questionnaire_Property VALUES(55,'QuestionnaireInGridRequiredText')
INSERT INTO #Questionnaire_Property VALUES(56,'QuestionnaireMinInGridRequiredText')
INSERT INTO #Questionnaire_Property VALUES(57,'QuestionnaireMaxInGridRequiredText')
INSERT INTO #Questionnaire_Property VALUES(58,'QuestionnaireIllegalTypeText')
INSERT INTO #Questionnaire_Property VALUES(59,'EndPoints')
INSERT INTO #Questionnaire_Property VALUES(60,'PointText')
INSERT INTO #Questionnaire_Property VALUES(61,'Unit')
INSERT INTO #Questionnaire_Property VALUES(62,'DefaultAnswerOption')
INSERT INTO #Questionnaire_Property VALUES(63,'Compact')
INSERT INTO #Questionnaire_Property VALUES(64,'AutoArrangeAnswerOptions')
INSERT INTO #Questionnaire_Property VALUES(65,'AnswerOptionColumns')
INSERT INTO #Questionnaire_Property VALUES(66,'AnswerOptionRows')
INSERT INTO #Questionnaire_Property VALUES(67,'QuestionnaireCatiMode')
INSERT INTO #Questionnaire_Property VALUES(68,'Countdown')
INSERT INTO #Questionnaire_Property VALUES(69,'AnswerOptionUniqueChoice')
INSERT INTO #Questionnaire_Property VALUES(70,'QuestionStylesheet')
INSERT INTO #Questionnaire_Property VALUES(71,'FlashPath')
INSERT INTO #Questionnaire_Property VALUES(72,'FlashHeight')
INSERT INTO #Questionnaire_Property VALUES(73,'FlashWidth')
INSERT INTO #Questionnaire_Property VALUES(74,'QuestionnaireOnBegin')
INSERT INTO #Questionnaire_Property VALUES(75,'QuestionnaireOnCompleted')
INSERT INTO #Questionnaire_Property VALUES(76,'RPQStatus')
INSERT INTO #Questionnaire_Property VALUES(77,'ImpSysRequiredText')
INSERT INTO #Questionnaire_Property VALUES(78,'ImpSysSelectionText')
INSERT INTO #Questionnaire_Property VALUES(79,'ImpSysChoiceText')
INSERT INTO #Questionnaire_Property VALUES(80,'ImpSysGender')
INSERT INTO #Questionnaire_Property VALUES(81,'AllowDecimals')
INSERT INTO #Questionnaire_Property VALUES(82,'AllowDecimalsInterval')
INSERT INTO #Questionnaire_Property VALUES(83,'NumericalInterval')
INSERT INTO #Questionnaire_Property VALUES(84,'ExportPosition')
INSERT INTO #Questionnaire_Property VALUES(85,'ExportLength')
INSERT INTO #Questionnaire_Property VALUES(86,'OpenAnswerRequired')
INSERT INTO #Questionnaire_Property VALUES(87,'AlphabeticalTab')
INSERT INTO #Questionnaire_Property VALUES(88,'RepresentAsDropDown')
INSERT INTO #Questionnaire_Property VALUES(89,'IsShadowQuestion')
INSERT INTO #Questionnaire_Property VALUES(90,'QuestionInCludeInPage')
DROP TABLE #Questionnaire_Property
Questionnaire's Question
DECLARE @Q_Id INT
SET @Q_Id = '3424'
SELECT q.*,
(
CASE q.[Question_Type]
WHEN 1
THEN (SELECT 'Single')
WHEN 2
THEN (SELECT 'Multi')
WHEN 3
THEN (SELECT 'Number')
WHEN 4
THEN (SELECT 'Text')
WHEN 5
THEN (SELECT 'Open')
WHEN 6
THEN (SELECT 'SingleGrid')
WHEN 7
THEN (SELECT 'MultiGrid')
WHEN 8
THEN (SELECT 'TextGrid')
WHEN 9
THEN (SELECT 'Page')
WHEN 10
THEN (SELECT 'Multimedia')
WHEN 11
THEN (SELECT 'Scale')
WHEN 12
THEN (SELECT 'ScaleGrid')
ELSE
END
) AS [Type_Description],
qq.[Question_Index]
FROM [Question] q INNER JOIN
[Questionnaire_Question] qq ON q.[id] = qq.[Question_Id]
WHERE qq.[Questionnaire_Id] = (SELECT [Questionnaire_Id] FROM [Project_Questionnaire] WHERE [Id] = @Q_Id)
ORDER BY qq.[Question_Index]Copying Project Questionnaire
