spLoadRecord_SiteCodeTables

        CREATE PROCEDURE [dbo].[spLoadRecord_SiteCodeTables]
        (
            @PKID int
        )
        AS
        BEGIN
            set nocount on

            -- result set #1
            SELECT ID, Name 
            FROM dbo.SiteCodeTables 
            WHERE ID = @PKID 

            -- result set #2
            SELECT TE.ID, TE.CodeTablesID, TE.Description, TE.EntryGUID
            FROM dbo.SiteCodeTables T
                INNER JOIN dbo.SiteCodeTableEntries TE 
                ON TE.CodeTablesID = T.ID
            WHERE T.ID = @PKID 
            ORDER BY TE.ID

        END