USP_DATALIST_SITECONTENT

create procedure dbo.USP_DATALIST_SITECONTENT(@XML xml)
as
    set nocount on;

  declare @SiteContentIDS table ([ID] int)

  insert into @SiteContentIDS select IDS.ID.value('.', 'int') from @XML.nodes('/SiteContent/id') IDS(ID)

    select SITECONTENT.ID,
           SITECONTENT.[GUID],
           SITECONTENT.CONTENTTYPESID           
    from @SiteContentIDS SCI inner join dbo.SITECONTENT on SCI.ID = SITECONTENT.ID
    left outer join dbo.CONTENTTYPES on CONTENTTYPES.ID= SITECONTENT.CONTENTTYPESID