application format
+ '-' + [r].[id] [Report_ID]
, [pr].[project_Code1C] [Project_code]
, [r].[Name] [Name]
, [rai].[workTypeName] [WorkType]
, [rai].[typeReportName] [TypeReport]
, [obj].[codeValue] [Object_code]
, [rai].[objectName] [Object]
, ISNULL ( [sd] .[DocumentName], [pd].[path])
INSERT INTO #tmp_report ([Report_ID], [Project_code], [Name], [WorkType], [TypeReport], [Object_code], [Object], [Dogovor], [Contragent], [Date_Start], [Date_Finish])
SELECT [project_Code1C]
+ '-' + [r].[id] [Report_ID]
, [pr].[project_Code1C] [Project_code]
, [r].[Name] [Name]
, [rai].[workTypeName] [WorkType]
, [rai].[typeReportName] [TypeReport]
, [obj].[codeValue] [Object_code]
, [rai].[objectName] [Object]
, ISNULL ( [sd] .[DocumentName], [pd].[path])
underlined in a row is not enough spaces
body HTML
<body bgColor="#FFFFF4">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv="Content-Type" content="text/html; charset=koi8-r"><meta name="Generator" content="Microsoft Word 14 (filtered medium)"><style><!--/* Font Definitions */@font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;}@font-face {font-family:"Lucida Console"; panose-1:2 11 6 9 4 5 4 2 2 4;}/* Style Definitions */p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-fareast-language:EN-US;}a:link, span.MsoHyperlink {mso-style-priority:99; color:#0563C1; text-decoration:underline;}a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:#954F72; text-decoration:underline;}span.EmailStyle17 {mso-style-type:personal-compose; font-family:"Calibri","sans-serif"; color:windowtext;}.MsoChpDefault {mso-style-type:export-only; font-family:"Calibri","sans-serif"; mso-fareast-language:EN-US;}@page WordSection1 {size:612.0pt 792.0pt; margin:2.0cm 42.5pt 2.0cm 3.0cm;}div.WordSection1 {page:WordSection1;}--></style></head><body lang="RU" link="#0563C1" vlink="#954F72"><div class="WordSection1"><p class="MsoNormal">Алексей, привет!<o:p></o:p></p><p class="MsoNormal">В <span lang="EN-US">ITSErvice</span><span lang="EN-US"> </span>изменили процедуру и долго стал выполняться запрос:<o:p></o:p></p><p class="MsoNormal"><o:p> </o:p></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:blue">INSERT</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:black"></span><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:blue">INTO</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:black"> #tmp_report ([Report_ID], [Project_code], [Name], [WorkType], [TypeReport], [Object_code], [Object], [Dogovor], [Contragent], [Date_Start], [Date_Finish])<o:p></o:p></span></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:blue">SELECT</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:black"> [project_Code1C]<o:p></o:p></span></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:black"> </span><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:darkgray">+</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:black"></span><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:red">'-'</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:black"></span><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:darkgray">+</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:black"> [r].[id] [Report_ID]<o:p></o:p></span></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:black"> , [pr].[project_Code1C] [Project_code]<o:p></o:p></span></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:black"> , [r].[Name] [Name]<o:p></o:p></span></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:black"> , [rai].[workTypeName] [WorkType]<o:p></o:p></span></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:black"> , [rai].[typeReportName] [TypeReport]<o:p></o:p></span></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:black"> , [obj].[codeValue] [Object_code]<o:p></o:p></span></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:black"> , [rai].[objectName] [Object]<o:p></o:p></span></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:black"> , </span><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:fuchsia">ISNULL</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:black">(</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:darkblue">[sd]</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:black">.[DocumentName], [pd].[path])<o:p></o:p></span></p><p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Console";color:black">