您好,登錄后才能下訂單哦!
DECLARE @emailBody NVARCHAR(MAX);
SET @emailBody = N'<style>table{table-layout:fixed;width:1200px;border:1px solid #000000;border-collapse:collapse;font-size:12px;empty-cells:show;}'
N'</tbody></table>';
SELECT @emailBody = REPLACE(REPLACE(@emailBody,
'<', '<'),
'>', '>');
select @emailBody
select c.ITEM_CODE,b.ITEM_DESCRIPTION,b.ITEM_SPECIFICATION,b.UDF021,b.PRICE_QTY, b.REMARK from SALES_RETURN a
left join SALES_RETURN_D b ON a.SALES_RETURN_ID = b.SALES_RETURN_ID
left join ITEM c ON b.ITEM_ID = c.ITEM_BUSINESS_ID
where DOC_NO = '2700-201809250001'
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。