Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2013
    Posts
    12

    Unanswered: error in procedure

    hi every one,
    i was not able to solve pls i need help.

    while using store procedure in report getting error as mentioned below !

    Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

    Thanks

    Rajnidas

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    You are comparing two text columns.

    The collation of the columns is different so cannot be compared directly.

    Look at the table definitions in your procedure and see if you can spot the different collations.
    George
    Home | Blog

Posting Permissions

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