spShoppingCartParts

            create procedure dbo.spShoppingCartParts(@ClientSitesID int) as
                set nocount on
                select -1 ID, '<please select>' [Name]
                union all
                select cart.ID, sc.Title
                from dbo.ShoppingCartPart cart
                inner join dbo.SiteContent sc on sc.ID=SiteContentID
                where Active=1 and sc.ClientSitesID=@ClientSitesID;