MSSQL INSERT Record If Not Exist

[fallnwrld]

Table Layout:
TABLE: dbo.Applications
FIELDS: Date, Username, Application, Version

I want to insert a record only if the record I'm about to insert does not match the Username and Application field.

This is what I got so far...

INSERT INTO dbo.Applications (Date, Username, Application, Version) VALUES('3/10/2009', 'Tom', 'Calculator', '2.0') WHERE NOT EXISTS (SELECT * FROM dbo.Applications WHERE Username = Tom AND Application = Calculator)

[PeejAvery]

Have you tried using INSERT IGNORE?

[fallnwrld]

It looks like every field has to match in order for it to ignore it. In this case the Date field will always be different, I just want to compare the username and application field, if those already exist then ignore it.

lets say
03/12/2009 Tom Calc 2.0
02/12/2008 Tam Calc 2.0
01/13/2003 Tqm Calc 2.0

If I try to Insert 09/09/2009 Tom Calc 3.0
It will ignore it because Tom and Calc already exist, even though it's a different date and a different version

[Alsvha]

Use IF to check if something exists (or not), and then act accordingly:

IF NOT EXISTS (SELECT * FROM dbo.Applications WHERE Username = Tom ANDApplication = Calculator) BEGIN
 INSERT INTO dbo.Applications 
 (Date, Username, Application, Version) 
 VALUES
 ('3/10/2009', 'Tom', 'Calculator', '2.0') 
END

[dbloch3643]

Here is a solution with out the begin and end statements.

INSERT INTO dbo.Applications (Date, Username, Application, Version)
select '3/10/2009', 'Tom', 'Calculator', '2.0'
WHERE NOT EXISTS (SELECT *
FROM dbo.Applications
WHERE Username = Tom
AND Application = Calculator)