USE [AIADatabaseV5]
GO
/****** Object:  StoredProcedure [dbo].[DA_GetBackGroundArtList]    Script Date: 2/1/2018 12:15:55 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DA_GetBackGroundArtList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DA_GetBackGroundArtList]
GO

CREATE  PROCEDURE [dbo].[DA_GetBackGroundArtList] 
	-- Add the parameters for the stored procedure here
@body_view_id int , 
@sex char
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	SELECT
	(
	SELECT [Id] as Id
      ,[DissectibleBodyViewId] as voId
      ,[DissectibleRegionId] as brId
      ,[IsForeground] as isfr
      ,[Zoom] as zm
      ,[IsBetadine] as isbt
      ,[SkinTone] as sktn
      ,[Sex] as gr
      ,[LayerNumberStart] as lns
      ,[LayerNumberEnd] as lne
      ,[OffsetX] as ox
      ,[OffsetY] as oy
      ,[ImageId] as imId
	FROM [DissectibleBodyViewBackgroundArt] as it where 
	IsBetadine='N' 
	and Sex=@sex 
	and DissectibleBodyViewId=@body_view_id
	For XML AUTO )
	as XMLString 

END

GO