spShoppingCartSummaryParts

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