Results 1 to 2 of 2
  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Bad SQL (2000/SP3)

    Can someone tell me what is wrong with this query?
    <pre>INSERT INTO Database_History ( DB2_ID, UserID, Begin_D, End_D, Duration, MachineID )
    SELECT Database_History.DB2_ID, Database_History.UserID, Database_History.Begin_D,
    Database_History.End_D, Database_History.Duration, Database_History.MachineID
    FROM Database_History
    WHERE (((Database_History.DB2_ID)="ArDvark")
    AND ((Database_History.UserID)="ABZXYSCH"))
    AND ((Database_History.Begin_D)=#04/19/2007 11:13:21#)
    AND ((Database_History.End_D)=#04/19/2007 11:19:11#)
    AND ((Database_History.Duration)=4.0509)
    AND ((Database_History.MachineID)="OHW-F23082");</pre>

    It does not give me any errors but it comes up and says it is going to "Append
    Attached Images Attached Images
    Alan

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Bad SQL (2000/SP3)

    Have you verified that there are records satisfying all those conditions?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •