Non-unique fields causing duplicate records when tables joined.
I have been given a script with the following:
maketime(hour(start_time),minute(start_time),second(start_time)) as [Call Start Time]
The resulting CallTable then gets stored in a QVD and later loaded by another script for reporting purposes.
This works fine except in certain cases where, I believe, two records have the same start_time value. When this happens, then we end up with duplicate records in the table/QVD which we can see by creating a list box for unique_id with the frequency option enabled. How can I modify this script to prevent these duplicate records? Since we're working with a fairly large dataset an efficient solution is preferable.