Home Forums SQL Server 2005 T-SQL (SS2K5) cursor concatenating variable RE: cursor concatenating variable

  • March 8, 2013 at 8:50 am

    #1594999

    the problem is that the email subject should be this...

    email 1 subject : stockcode SKU0001 is below safety

    email 2 subject : stockcode SKU0002 is below safety

    email 3 subject : stockcode SKU0003 is below safety

    ..not this...

    email 1 subject : stockcode SKU0001 is below safety

    email 2 subject : stockcode SKU0001SKU0002 is below safety

    email 3 subject : stockcode SKU0001SKU0002SKU0003 is below safety

    which is whats happening.