Hi guys 'n girls,

I have a problem that you might be able to help me with and do not want to use identity. I have a table (let's call it...

😛 Thanks for the reply, I'll definitely do that!;)

Let me just say that identity columns is ok but nothing replaces good old natural keys. If your database has been setup right from the start with identity columns then...

:w00t::hehe: Howcome it is that I don't know about the event in JHB. How did I miss that one! I always look-on with jealousy when the events in America ...

😉 What a very nice post. I tried this very same query in SQL Server 2005 because I used to have the same problem with the # tables. I did...

Nope, the job is not fired from VB and no it is not a stored procedure or query that I wrote but I used the wizard in SQL Server 2005...