USP_DATALIST_SELECTPARTFOREDIT

create procedure dbo.USP_DATALIST_SELECTPARTFOREDIT(@PARTID int)
as
    set nocount on;

      Select SC.Title As PartName, SP.PageName As PageName, CS.Name As SiteName, CT.Name As ContentType
          from PageContent PC 
                 Inner Join SitePages SP on SP.ID = PC.SitePagesID
                 Inner Join SiteContent SC on PC.SiteContentID = SC.ID
                 Inner Join ClientSites CS on SC.ClientSitesID = CS.ID
                 Inner Join ContentTypes CT on CT.ID = SC.ContentTypesID
           where SC.ID = @PARTID