You get the dummy entry because SELECT SQL evaluates once all field expressions before any record selection only to establish the output structure. So, if you use a UDF function in the SELECT SQL, the UDF will be evaluated once at the beginning to get the structure. You can deal with this case inside the function.
Vlad
>This is close to what you want. If you include record 1 and record 2 has the same staffid, you will get a double entry. So I put a dummy record for record 1. I didn't have time to figure a better sloution.
>
>Hope this helps
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only