Thanks for the Reply,

There are prob 10+ systems that feed the main database, rather that users going to lots of different systems we try and pull all the info into...

Currently i have 'set nocount on'.

Will i have to remove that in the "Update, and if @@Rowcount = 0, then insert. " method so it returns a rowcount?

If so isn't...