Usuário com melhor resposta
To whom it may concern,
Thank you for taking the time to read this and possibly respond.
I wish to be able to check to see if a row exists with certain values and if it doesnt then insert the record.
Im currently trying to avoid 2 connections to the database
1 to see if the row exists
2 then insert if necessary
What I wish to do is to be able to do this in a single connection instance to the db
Todas as Respostas
Merge statement is introduced in Sql server 2008, but since you are on SQL Server 2005, you can refer http://sqlserver-tips.blogspot.com/2006/09/mimicking-merge-statement-in-sql.html
Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.