Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Posts
    266

    Unanswered: Insert Into Select

    Hi

    for MS SQL 2000
    how can I do ? :

    INSERT INTO [Users] (Numb, Name, Level) VALUES
    (
    2,
    (SELECT DISTINCT Names FROM Others) ,
    3
    )


    Users has an autoIncrement ID = Users_id

    thank you for helping

  2. #2
    Join Date
    Jan 2006
    Location
    Singapore
    Posts
    47
    INSERT INTO [Users] (Numb, Name, Level)
    SELECT DISTINCT 2, Names, 3 FROM Others

    -----------------
    KH


  3. #3
    Join Date
    Dec 2005
    Posts
    266
    really strange !
    but it works

    thanks a ton

Posting Permissions

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