title: insert into values with where clause
body: <p>I am trying to programmatically enter values into my table. </p>
  
  <p>I cannot use a straight Select @variables. I have to use the keyword Values.</p>
  
  <p>How can I create a where clause when using Values in the insert into. </p>
  
  <p>I am trying to avoid duplicates</p>
  
  <pre><code>  DECLARE @MyID INT
    DECLARE @Phone varchar(10)
    DECLARE @MyDATE DateTime
    DECLARE @Agent as varchar(50)
    DECLARE @Charge as varchar(50)
    DECLARE @Vendor as varchar(50)
  
    SET @MyID = 215199999
    SET @Phone = '9999999999'
    SET @MyDATE = '2010-12-04 11:56:12.000'
    SET @Agent = 'fbrown'
    SET @Charge = 'NO'
    SET @Vendor = 'NO'
  
    INSERT INTO [MyDB].[dbo].[Accounts]
    (MyID,Phone,MyDate,Agent,Charge,Vendor)
    VALUES (
    @MyID
    ,@Phone
    ,@MyDATE
    ,@Agent
    ,@Charge
    ,@Vendor 
    ) WHERE MyID NOT IN (@MyID)
  </code></pre>