spGetSiteCodeTableCategoryList

                CREATE PROCEDURE [dbo].[spGetSiteCodeTableCategoryList]
        AS
        BEGIN
            set nocount on
            SELECT sctc.[ID], sctc.[DESCRIPTION] FROM dbo.SiteCodeTableCategories sctc
            inner join dbo.INSTALLEDPRODUCTLIST ipl on sctc.Flag = ipl.ID
            ORDER BY [DESCRIPTION]
            SELECT st.GUID, tc.Description 'Category', st.Name 'CodeTableName', st.ID 'TableID'
            FROM dbo.SiteCodeTables st 
            INNER JOIN dbo.SiteCodeTableCategories tc ON tc.ID = st.CategoryID
            inner join dbo.INSTALLEDPRODUCTLIST ipl on tc.Flag = ipl.ID
            ORDER BY st.Name
        END