INSERT INTO With Condition

• Ido Amrani

  SSC Enthusiast

  Points: 101

  More actions

  September 13, 2005 at 3:10 am

  #61188

  Hi, i was able to insert into table 'FilesPath' two values (a,b) but if value 'a' not exist.

  This is my SQL query:

  INSERT INTO FilesPath

                        (Path,Destination)

  VALUES     (@a,@b)

  WHERE     0 =

                            (SELECT     COUNT(*)

                              FROM          filespath

                              WHERE      Destination = @a)

  there is one error on WHERE statement.

  How i will solve this problem???

  Thanks 4 All.

• Phil Parkin

  SSC Guru

  Points: 246960

  More actions

  September 13, 2005 at 3:57 am

  #589287

  Why not recast this as a conditional insert?

  if not exists (SELECT destination FROM filespath WHERE Destination = @a)

  begin

   INSERT INTO FilesPath (Path,Destination)

   VALUES     (@a,@b)

  end

  The absence of evidence is not evidence of absence
  - Martin Rees
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin

• Ido Amrani

  SSC Enthusiast

  Points: 101

  More actions

  September 13, 2005 at 4:24 am

  #589289

  Thank a lot. this is better from my code and it is work excellent.