spMerchantAccountContentTypes

            CREATE  PROCEDURE [dbo].[spMerchantAccountContentTypes]
            (
            @ClientsID    int
            )
            as

            declare @availableTypes table([ID] int, [Name] nvarchar(200), [VersioningSupported] bit, [RealmTypeID] int, [Description] nvarchar(500))            
            insert into @availableTypes
            exec dbo.spAvailableContentTypes  @ClientsID, 1

            select AT.name, AT.ID
            from @availableTypes AT
            where AT.ID in (45,47,59,69,92,112,114,117,9102)
            ORDER BY AT.Name