GETDATE() is deterministic function.

Can you explain your code?

MartinaJ

>Hi
>
>I'm dealing with a system that in one area uses keys generated keys using GETDATE().
>
>This is producing duplicates sometimes.
>
>If I select GETDATE() in a loop it returns the same datetime through a lot of iterations . How often is the date and time refreshed and what sort of delay would I need to introduce to ensure I got a new date and time on each key generation.
>
>
>Thanks