SQL example to testing data - Revision history

Wikicatglobe at 10:14, 16 October 2013

2013-10-16T10:14:49Z

← Older revision		Revision as of 10:14, 16 October 2013
Line 1:		Line 1:
	<accesscontrol>~~Administrators,,Cem,,Maysunshine~~</accesscontrol>		<accesscontrol>Main:MyGroup</accesscontrol>
	[[Category:Miscellaneous]]		[[Category:Miscellaneous]]
	=== Version 5.8 ===		=== Version 5.8 ===

2011-10-24T10:21:02Z

← Older revision		Revision as of 10:21, 24 October 2011
Line 1:		Line 1:
	<accesscontrol>Administrators,,Cem,,Maysunshine</accesscontrol>		<accesscontrol>Administrators,,Cem,,Maysunshine</accesscontrol>
	[[Category:~~Guidelines~~]]		[[Category:Miscellaneous]]
	=== Version 5.8 ===		=== Version 5.8 ===
	<source lang="sql">		<source lang="sql">

2011-10-04T10:33:21Z

← Older revision		Revision as of 10:33, 4 October 2011
Line 1:		Line 1:
			<accesscontrol>Administrators,,Cem,,Maysunshine</accesscontrol>
			[[Category:Guidelines]]
	=== Version 5.8 ===		=== Version 5.8 ===
	<source lang="sql">		<source lang="sql">

2009-12-10T04:03:14Z

Version 5.6

@@ Line 73: / Line 73: @@
 select top 100 id,option_number,[value],answer_option_id,question_id,[user_id],resource_project_questionnaire_id from data
 where resource_project_questionnaire_id = 20595518
 </source>

2009-12-10T04:02:58Z

Version 5.5

@@ Line 107: / Line 107: @@
 where resource_project_questionnaire_id = 18104534
 </source>
 === get PQ has many RPQ ===

2009-12-10T04:02:04Z

Version 5.8

← Older revision		Revision as of 04:02, 10 December 2009
Line 33:		Line 33:
	select top 100 id,option_number,[value],answer_option_id,question_id,[user_id],resource_project_questionnaire_id from data		select top 100 id,option_number,[value],answer_option_id,question_id,[user_id],resource_project_questionnaire_id from data
	where resource_project_questionnaire_id = @RPQ_id		where resource_project_questionnaire_id = @RPQ_id
			</source>

			=== get all cati appointments ===
			<source lang="sql">
			select top 100 * from resource_project_questionnaire
			where next_contact_datetime is not null and deleted_date is null and cati_list = 3
			and dedicated_user_id = 9328774
			and project_questionnaire_id = 5028
	</source>		</source>

2009-11-10T08:13:35Z

← Older revision		Revision as of 08:13, 10 November 2009
Line 149:		Line 149:

	select top 10 * from project_questionnaire_resource where questionnaire_id = 5517		select top 10 * from project_questionnaire_resource where questionnaire_id = 5517
			</source>

			=== get PQ has many question & many rpq ===

			<source lang="sql">
			select top 100 count(id),project_questionnaire_id
			from resource_project_questionnaire
			where project_questionnaire_id in
			(
			select id from project_questionnaire_resource
			where questionnaire_id in (
			SELECT questionnaire_id
			FROM question q, questionnaire_question qq
			WHERE q.id = qq.question_id
			group by qq.questionnaire_id
			having count(qq.questionnaire_id ) > 500
			)
			)
			group by project_questionnaire_id
			order by count(id) desc
	</source>		</source>

2009-11-02T08:19:56Z

@@ Line 137: / Line 137: @@
 group by project_questionnaire_id
 order by count(id) desc
 </source>

2009-08-24T04:11:20Z

← Older revision		Revision as of 04:11, 24 August 2009
Line 137:		Line 137:
	group by project_questionnaire_id		group by project_questionnaire_id
	order by count(id) desc		order by count(id) desc
			</source>

			=== Update XML from one DCS to another DCS ===
			<source lang="sql">
			update data_cache_specification
			set [xml] = (select [xml] from data_cache_specification where resource_id = 33625464)
			where resource_id = 34793015
	</source>		</source>

2009-05-29T09:37:20Z