*** FOR DEBUG ONLY ***
MyCountryCode=NotSet Companies=-2147483648 DoCompaniesHaveExpiredMembership=False Contact=-1 MyMemberType=Unknown MyMemberLocalizationType=Unknown MyMemberStatus=NonMember
SELECT * FROM [tblNAsProgramCodes] WHERE [TimeFlag] = @TimeFlag1 AND [FormatCode] = @FormatCode2 AND [Code1] = @Code13 AND [HotKey] = @HotKey4 AND [HotKey] NOT IN ('StuAffilN','StuAffil','StuAffilR','IntAffilN','IntAffil','IntAffiRetd','IntAffilR','IntAffiRetd','RIntAffilR','UPGMembStu','UPGMembAsso','UPGIntlAffStu','UPGIAffAsso','UPGAssoIAff') AND [Retired] = @Retired6 AND [Code2] NOT IN ('E','G') ORDER BY [SortOrder] ASC,[Description] ASC