Home Forums SQL Server 2005 T-SQL (SS2K5) Invalid length parameter passed to the SUBSTRING function. RE: Invalid length parameter passed to the SUBSTRING function.

  • June 16, 2010 at 7:20 am

    #1180952

    Your error clearly states that it did happen in TRA_BrokenSalesPROCV2

    How you think providing the TRA_BrokenSalesPROCV6 noodles will help to identify the problem, it does not use the SUBSTRING function itself?

    Please provide text of TRA_BrokenSalesPROCV2.

    This error is due to the negative number is passed as third (length) parameter to this function.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]