Shulou(Shulou.com)06/02 Report--

DECLARE @ emailBody NVARCHAR (MAX)

SET @ emailBody = N'table {table-layout:fixed;width:1200px;border:1px solid # 00000 borderhouse collapse collapse.FontMusizeRu 12pxImperty cellsshowRose;}'

Border:1px solid # 000000td {Noble # 000000tpaddingPartition 3px;}'N' sales order'- title 'item number' N` item name'N' specification'N' product serial number'N' quantity'N' reason for return-header CAST ((SELECT c.ITEM_CODE AS td

''

B.ITEM_DESCRIPTION AS td

''

B.ITEM_SPECIFICATION AS td

''

B.UDF021 AS td

''

'' CAST (CAST (b.PRICE_QTY AS DECIMAL (20)

4)) AS VARCHAR (20))''AS td

''

B.REMARK AS td

''

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'

FOR

XML PATH ('tr')

TYPE

) AS NVARCHAR (MAX))

Nasty'

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'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.