Showing related tags and posts across the entire site.
-
on the web portal, some "donors" appear as numeric values. discovered that we have .. 551 that have this condition.. select donorid , description -- 551 rows returned from donor where 1=1 and isnumeric(description) = 1 they are also in the DesigDonor table.. select * -- 556 rows returned. from...
-
Hi Troy, We could try that but we have many users in this situation. Would it be feasible or advisable to take a snapshot, delete the data server and re sync/re import using our custom access database that we have set up? Basically deleting all designations in the sql data base and re syncing. Thanks...
-
My apologies good sir! I'm not that familiar with Sql and am working with a more experienced senior member to resolve this issue. We can now see from the below screenshots that there are errors with the Sql database and that the TNT sync is not working to remove them. Screenshot #1: Sql Full Join...
-
Hi Troy, Correct me if I'm wrong but we believe this might be a problem with the TNT application itself not querying the Sql database properly? We believe this because: 1. We've pumped Web Users and Webuser Profiles/Designations multiple times during the same day and on different days. 2. We...