Dynamic User Directory simple altering of SQL proc to work with DNN 7.4 and higher that stores Region and Country profiles as EntryID numbers
The attached code is a simple way to also include Region and Country Text and Values so you can use them in DUD item list and detail template:
LI.Text as CountryText,LI2.Text as RegionText,LI.Value as CountryValue,LI2.Value as RegionValue
1) make a backup of the stored proc [DataSprings_RetrieveDNNUserProfileData3]
using sql management studio and create it with a backup name
2) copy the following attached SQL data provider file and run it under Host / SQL of your site
3) then go to host/schedule and run the DUD scheduler
4) edit your DUD template and use RegionText / CountryText / RegionValue / CountryValue