Home Forums SQL Server 2012 SQL Server 2012 - T-SQL How to go to next line in the output and print a table RE: How to go to next line in the output and print a table

  • August 14, 2014 at 6:17 am

    #1738000

    mayankminawat (8/13/2014)

    This is printing everything in one line:

    SET @BODYTEXT = ' Dear ' + @fname +',We realize you may have taken ' + @course_due + ' in '+ @month_last_taken +'.'

    How do I do this:

    SET @BODYTEXT = ' Dear ' + @fname +

    ',We realize you may have taken ' + @course_due + ' in '+ @month_last_taken +'.'

    The link supplied above will sort you out for HTML tables. For line breaks you need to add them to your string in one of two ways.

    SET @BODYTEXT = ' Dear ' + @fname + ',

    We realize you may have taken ' + @course_due + ' in ' + @month_last_taken + '.'

    or

    SET @BODYTEXT = ' Dear ' + @fname + ',' + CHAR(13) + CHAR(10) +

    'We realize you may have taken ' + @course_due + ' in '+ @month_last_taken +'.'

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]