Home Forums Reporting Services Reporting Services Implicit conversion from data type ntext to varchar is not allowed. Use the CONVERT function to run this query. RE: Implicit conversion from data type ntext to varchar is not allowed. Use the CONVERT function to run this query.

  • June 22, 2010 at 4:43 am

    #1183213

    I was facing the same problem. But I came with a solution. I dont know whether it is correct or not.

    create procedure sp_test

    @STR varchar(8000)

    changed to

    create procedure sp_test

    @STR ntext

    as

    declare @str1 varchar(8000)

    set str1= conver(varchar(8000), @STR)

    blah blah