Home Forums SQL Server 7,2000 T-SQL extracting waitresource from a blocked process report RE: extracting waitresource from a blocked process report

  • April 9, 2013 at 11:08 pm

    #1605091

    convert(varchar, TextData)) does not have the length of varchar soecified.

    By default it's equal to convert(varchar(30), TextData)).

    And actually you do not need to convert Textdata at all.

    Use PATINDEX instead of CHARINDEX.

    _____________
    Code for TallyGenerator