spGetSiteCodeTableEntriesByCodeTableGuid

      CREATE PROCEDURE dbo.spGetSiteCodeTableEntriesByCodeTableGuid(@CodeTableGuid uniqueidentifier)
           AS
           declare @codetableid int
            select @codetableid=id from dbo.sitecodetables where guid=@CodeTableGuid
           SELECT ID, CodeTablesID, Description, EntryGuid
           FROM dbo.SiteCodeTableEntries
           WHERE CodeTablesID=@codetableid