<div>
In order to get your queries into one result set, the values in each column must be the same data type. &nbsp;So, the result from Query 1 must be the same data type as the result from Query 2. 
 
You can cast your columns to the same data type, but you should know the max size possible in order to avoid errors. 
 
Example: 

<pre><code class="code-1 nolinks" id="code-20-41382121-1">DECLARE @Batch_Num VARCHAR(1) = 1;
SELECT CAST('&lt;V1.0&gt;,&quot;' + SUBSTRING(@Batch_Num, 7, 2) + SUBSTRING(@Batch_Num,
 10, 2) + 'C&quot;' AS VARCHAR(200)) AS MyResult
UNION ALL
SELECT CAST('*,&quot;' + SUBSTRING(@Batch_Num, 2, 1) + SUBSTRING(@Batch_Num, 4, 2)
 + SUBSTRING(@Batch_Num, 7, 2) + SUBSTRING(@Batch_Num, 10, 2)
 + 'c&quot;,,&quot;PONUM&quot;,,,&quot;' + +SUBSTRING(@Batch_Num, 2, 1)
 + SUBSTRING(@Batch_Num, 4, 2) + SUBSTRING(@Batch_Num, 7, 2)
 + SUBSTRING(@Batch_Num, 10, 2) + 'c.dat&quot;' AS VARCHAR(200)) AS MyResult;
</code></pre>
 
 
In this example, I arbitrarily chose 200 as the max size for the result. &nbsp;You will need to choose an appropriate size, which largely depends on the max size of @Batch_Num since the other characters in your query are static and won't change size. 
 
Please also note that I'm using <a href="http://blog.sqlauthority.com/2009/03/11/sql-server-difference-between-union-vs-union-all-optimal-performance-comparison/" rel="ugc">UNION ALL instead of UNION</a>.
</div>

<div>
You can use a UNION statement between the two queries and have it return the results as two rows: 
 

<pre><code class="code-1 nolinks" id="code-20-41382122-1">Select '&lt;V1.0&gt;,&quot;' + substring(@Batch_Num, 7, 2 ) + substring(@Batch_Num, 10, 2) + 'C&quot;'
UNION
Select '*,&quot;' + substring(@Batch_Num, 2, 1) + substring(@Batch_Num, 4, 2) + substring(@Batch_Num, 7, 2 ) + substring(@Batch_Num, 10, 2) + 'c&quot;,,&quot;PONUM&quot;,,,&quot;' +
 + substring(@Batch_Num, 2, 1) + substring(@Batch_Num, 4, 2) + substring(@Batch_Num, 7, 2 ) + substring(@Batch_Num, 10, 2) + 'c.dat&quot;'
</code></pre>
 
Would that work?
</div>

<div>
@Ryan - &nbsp;UNION ALL is likely a better option in this case, no?
</div>

<div>
UNION ALL is 100% definitely, absolutely, utterly and completely the better method here 
 
When you use UNION by itself you are actually doing UNION DISTINCT (the DISTINCT is &quot;assumed&quot;) 
 
so IF 2 rows were identical UNION DISTINCT would only allow one row as a result 
but if 2 rows were identical UNION ALL would present all the rows 
 
(thinks: enough. stop now.) 
 
No Points please
</div>

<div>
UNION ALL &nbsp;works well for the first two queries: 
declare @Batch_Num as varchar(20) 
 
set @Batch_Num = '15-11-23-01' 
 
Select '&lt;V1.0&gt;,&quot;' + substring(@Batch_Num, 7, 2 ) + substring(@Batch_Num, 10, 2) + 'C&quot;' 
UNION ALL 
Select '*,&quot;' + substring(@Batch_Num, 2, 1) + substring(@Batch_Num, 4, 2) + substring(@Batch_Num, 7, 2 ) + substring(@Batch_Num, 10, 2) + 'c&quot;,,&quot;PONUM&quot;,,,&quot;' + 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; + substring(@Batch_Num, 2, 1) + substring(@Batch_Num, 4, 2) + substring(@Batch_Num, 7, 2 ) + substring(@Batch_Num, 10, 2) + 'c.dat&quot;' 
 
When presenting the results to text, it gives me two lines, just as I want. &nbsp;The third query, however creates a problem. &nbsp;Here is the query: 
 
Select Cast( (ROW_NUMBER() Over ( order by GlassID, GlassHeight)) as varchar( 20 )) + ',1,0,&quot;' + Rtrim(GlassID) + '&quot;,' + 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Rtrim(GlassWidth) + ',' + Rtrim(GlassHeight) + ',,&quot;SPACER&quot;,,,,,,,,,&quot;LC&quot;' 
from pct_Glass_Cuts 
where batch_number = @Batch_Num 
Order by GlassID, GlassHeight 
 
When running it as a separate query, it works fine. &nbsp;The first few lines of the result set look like this: 
 
1,1,0,&quot;GL5/32CLR&quot;,,,,&quot;SPACER&quot;,,,,,,,,,&quot;LC&quot; 
2,1,0,&quot;GL5/32CLR&quot;,20.500,41.625,,&quot;SPACER&quot;,,,,,,,,,&quot;LC&quot; 
3,1,0,&quot;GL5/32CLR&quot;,20.500,41.625,,&quot;SPACER&quot;,,,,,,,,,&quot;LC&quot; 
4,1,0,&quot;GL7/32CLR&quot;,,,,&quot;SPACER&quot;,,,,,,,,,&quot;LC&quot; 
5,1,0,&quot;GLCL.1/4&quot;,36.375,18.625,,&quot;SPACER&quot;,,,,,,,,,&quot;LC&quot; 
6,1,0,&quot;GLCL.1/4&quot;,36.375,18.625,,&quot;SPACER&quot;,,,,,,,,,&quot;LC&quot; 
7,1,0,&quot;GLCL.1/4&quot;,39.00,18.750,,&quot;SPACER&quot;,,,,,,,,,&quot;LC&quot; 
8,1,0,&quot;GLCL.1/4&quot;,39.00,18.750,,&quot;SPACER&quot;,,,,,,,,,&quot;LC&quot; 
9,1,0,&quot;GLCL.1/4&quot;,9.5625,43.6875,,&quot;SPACER&quot;,,,,,,,,,&quot;LC&quot; 
10,1,0,&quot;GLCL.1/4&quot;,9.5625,43.6875,,&quot;SPACER&quot;,,,,,,,,,&quot;LC&quot; 
11,1,0,&quot;GLCL.1/4&quot;,9.5625,43.6875,,&quot;SPACER&quot;,,,,,,,,,&quot;LC&quot; 
12,1,0,&quot;GLCL.1/4&quot;,9.5625,43.6875,,&quot;SPACER&quot;,,,,,,,,,&quot;LC&quot; 
 
However, when I use UNION ALL with this query I get these errors: 
 
Msg 207, Level 16, State 1, Line 15 
Invalid column name 'GlassID'. 
Msg 104, Level 16, State 1, Line 15 
ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator. 
Msg 207, Level 16, State 1, Line 15 
Invalid column name 'GlassHeight'. 
Msg 104, Level 16, State 1, Line 15 
ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator. 
 
Would it help if I try to figure out how to use a CTE for the third query, or is there a better way to get the result I need? 
 
T
</div>

<div>
Thank you Zephyr-Hex. &nbsp;One additional issue. &nbsp;When I run this as text, I get a dashed line at the top, like this: 
----------------------------------- 
Is there a way to get rid of that?
</div>

<div>
Change the delimiter type in Tools-&gt;Options-&gt;Query Results-&gt;SQL Server-&gt;Results To Text. &nbsp;I think the default is Column Aligned, which produces the dashes. &nbsp;Use one of the other options, or try the Custom Delimiter. &nbsp;I use Custom Delimiter with pipe ( | ) and do not get the dashes.
</div>

<div>
Thank you zephyr_hex. &nbsp;The setting that actually did it was to turn off &quot;Include column headers in the result set.&quot;
</div>

<div>
Thank you zephyr_hex. &nbsp;You have been very helpful. &nbsp;I now need to figure out how to set Results to Text, Results to File and Column Headers off programmatically, so I can run the query in a stored procedure. &nbsp;If I don't figure it out, I will post another question called Programmatically Setting Query Options. &nbsp;Watch for it. &nbsp;Thanks again. 
 
T
</div>

<div>
You likely will want to create a stored procedure that returns the result set to your calling program. &nbsp;&quot;Results To Text&quot;, etc are options in SSMS -- an environment in which a user can issue queries against a SQL database. &nbsp;You wouldn't use SSMS to run a query from code.
</div>

<div>
<div class="content wysiwyg-content">
I have three SQL queries, each of which gives me a result. &nbsp;What I want is for the results to be concatenated and either inserted in a table that can then be exported to a text file or directly to a text file. &nbsp;For example, the first two queries and their results are: 
 
Query1: 
Select '&lt;V1.0&gt;,&quot;' + substring(@Batch_Num, 7, 2 ) + substring(@Batch_Num, 10, 2) + 'C&quot;' 
 
Result: 
&lt;V1.0&gt;,&quot;2301C&quot; 
 
Query2: 
Select '*,&quot;' + substring(@Batch_Num, 2, 1) + substring(@Batch_Num, 4, 2) + substring(@Batch_Num, 7, 2 ) + substring(@Batch_Num, 10, 2) + 'c&quot;,,&quot;PONUM&quot;,,,&quot;' + 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; + substring(@Batch_Num, 2, 1) + substring(@Batch_Num, 4, 2) + substring(@Batch_Num, 7, 2 ) + substring(@Batch_Num, 10, 2) + 'c.dat&quot;' 
 
Result: 
*,&quot;5112301c&quot;,,&quot;PONUM&quot;,,,&quot;5112301c.dat&quot; 
 
I want to run the queries together and get this result: 
&lt;V1.0&gt;,&quot;2301C&quot; 
*,&quot;5112301c&quot;,,&quot;PONUM&quot;,,,&quot;5112301c.dat&quot; 
 
How can I accomplish this? 
 
T
</div>
</div>

I have three SQL queries, each of which gives me a result. What I want is for the results to be concatenated and either inserted in a table that can then be exported to a text file or directly to a text file. For example, the first two queries and their results are:

Query1:
Select '<V1.0>,"' + substring(@Batch_Num, 7, 2 ) + substring(@Batch_Num, 10, 2) + 'C"'

Result:
<V1.0>,"2301C"

Query2:
Select '*,"' + substring(@Batch_Num, 2, 1) + substring(@Batch_Num, 4, 2) + substring(@Batch_Num, 7, 2 ) + substring(@Batch_Num, 10, 2) + 'c",,"PONUM",,,"' +
 + substring(@Batch_Num, 2, 1) + substring(@Batch_Num, 4, 2) + substring(@Batch_Num, 7, 2 ) + substring(@Batch_Num, 10, 2) + 'c.dat"'

Result:
*,"5112301c",,"PONUM",,,"5112301c.dat"

I want to run the queries together and get this result:
<V1.0>,"2301C"
*,"5112301c",,"PONUM",,,"5112301c.dat"

How can I accomplish this?

T

Concatenate results from mutlple sql queries

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.