Results 1 to 2 of 2
  • Thread Tools
  1. 3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    250
    Thanks
    3
    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. Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 10 Times in 10 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
  •