USE [AIADatabaseV5] GO /****** Object: StoredProcedure [dbo].[DA_GetStructureList] Script Date: 2/1/2018 12:15:55 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: magic -- Create date: 25/4/2009 -- Description: Get Term Number from DissectibleStructures -- ============================================= if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DA_GetStructureList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[DA_GetStructureList] GO CREATE PROCEDURE [dbo].[DA_GetStructureList] -- Add the parameters for the stored procedure here @dissectible_struct_group_id int, @vocab_lexicon_id int AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; SELECT ( SELECT distinct it.TermNumber as tn,vt.TermText as tt FROM [DissectibleStructures] AS it inner join vocabterms vt on it.TermNumber = vt.TermNumber WHERE it.DissectibleStructureGroupId=@dissectible_struct_group_id and vt.VocabLexiconId=@vocab_lexicon_id order by vt.TermText FOR XML AUTO) AS XMLString END GO