Results 1 to 3 of 3

Thread: help ME SQL2000

  1. #1
    Join Date
    Aug 2002
    Location
    italy
    Posts
    4

    Red face Unanswered: help ME SQL2000

    hello to all,
    I have installed two serveur with sql server 2000,
    one server a store launch one procedures and all it goes
    two server error : Serveur MSg446, level 16 been 9 linens 1 CANNOT resolve COLLATION conflict for equal to operation.
    I do not succeed to understand the type of problem you can help
    thanks me
    maurizio

  2. #2
    Join Date
    Aug 2002
    Location
    UK
    Posts
    87
    I'm unsure what the procedure is trying to do

  3. #3
    Join Date
    Aug 2002
    Location
    italy
    Posts
    4

    Thumbs up Re: help ME SQL2000

    Originally posted by ncapi
    hello to all,

    I have installed two serveur with sql server 2000,
    one server a store launch one procedures and all it goes
    two server error : Serveur MSg446, level 16 been 9 linens 1 CANNOT resolve COLLATION conflict for equal to operation.
    I do not succeed to understand the type of problem you can help
    thanks me
    maurizio
    Istruction :
    CREATE TABLE #zeta (
    a VARCHAR(6) NOT NULL,
    b DECIMAL(9) NULL
    )

    ALTER TABLE #zeta
    ADD
    CONSTRAINT zK_t
    PRIMARY KEY (a)

    SELECT RET.ID_R
    FROM EL, RET, AN, #zeta
    WHERE
    EL.a LIKE @P_COD_4 AND
    EL.a1 = @P_COD_1 AND
    EL.a2 = @P_COD_2 AND
    EL.a3 = @P_COD_3 AND
    RET.ID_E = EL.ID_E AND
    RET.COD_STATO = 2 AND
    AN.ID_1 = RET.ID_1 AND
    #zeta.a = EL.a
    )

Posting Permissions

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