• my dynamic Query which will be in variable @query is not taking values greater than 8000, even though i have declared it as varchar(max)

    Print @query is returning only 8000 charcters and execute(@query) is not working.