Hi thanks for your reply, that all makes good sense. What would you suggest for Dates, I read on a website that SQL Server has:

datetime - From January 1,...

Thanks for the advise, but what is schema, ive seen it mentioned but I dont know what it is. SQL is really prettty new to me, (two day course).

Jeffrey...

Thanks for you reply, but I managed to sort it out! The procedure was executing but it was going into the master DB rather that one I specified. I was...