G
Guest
To anyone who can help,
I'm trying to create a character string that will display output on two
different lines when an email notification goes out. The email part works,
however, the output isn't what I'm looking for. Here's the segment of code:
INSERT INTO @table (address_id,address,email)
SELECT i.address_id,'Customer Name: ' + n.Cust_Name + '||CHR(10)||Address:
' + n.house_number + ' ' +
CASE WHEN n.unit IS NULL THEN ''
WHEN n.unit IS NOT NULL THEN n.unit + ' ' END
+ n.street + ', ' + n.city,n.email
FROM #i i INNER JOIN tbladdress_notification n
ON i.address_id = n.address_id
ORDER BY i.address_id
I've also tried '\n' and '||chr(13)||' and both have been to no evail. The
output I'm looking for is:
Customer Name: (Name)
Address: (Address)
Any suggestions? THANKS!
I'm trying to create a character string that will display output on two
different lines when an email notification goes out. The email part works,
however, the output isn't what I'm looking for. Here's the segment of code:
INSERT INTO @table (address_id,address,email)
SELECT i.address_id,'Customer Name: ' + n.Cust_Name + '||CHR(10)||Address:
' + n.house_number + ' ' +
CASE WHEN n.unit IS NULL THEN ''
WHEN n.unit IS NOT NULL THEN n.unit + ' ' END
+ n.street + ', ' + n.city,n.email
FROM #i i INNER JOIN tbladdress_notification n
ON i.address_id = n.address_id
ORDER BY i.address_id
I've also tried '\n' and '||chr(13)||' and both have been to no evail. The
output I'm looking for is:
Customer Name: (Name)
Address: (Address)
Any suggestions? THANKS!