The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
COURSE of the MONTH
14 days, 8 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SQL UNION Operator
Posted on 2013-01-24
Hi Expert,
Code is here
SET @SQL_MAIN = @SQL_MAIN + @SQL_1
EXECUTE SP_EXECUTESQL @SQL_MAIN
----------SQL_MAIN is main query, @SQL_1 inner join table A, @SQL_2 inner join table B
I want Union @SQL_2, how to do it?
thanks in advance
Code is here
SET @SQL_MAIN = @SQL_MAIN + @SQL_1
EXECUTE SP_EXECUTESQL @SQL_MAIN
----------SQL_MAIN is main query, @SQL_1 inner join table A, @SQL_2 inner join table B
I want Union @SQL_2, how to do it?
thanks in advance
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
5 Comments
I suggest you rather use CTE instead of @sql2 - just put all that query or even both in CTE and use them in a UNION afterwards.
http://msdn.microsoft.com/en-us/library/ms190766(v=sql.105).aspx
here's one with UNION ALL but you can just drop the ALL
http://stackoverflow.com/questions/8985609/union-all-in-cte
more complicated recursive CTE examples here:
http://stackoverflow.com/questions/3159192/sql-server-2008-cte-recursion
http://msdn.microsoft.com/en-us/library/ms190766(v=sql.105).aspx
here's one with UNION ALL but you can just drop the ALL
http://stackoverflow.com/questions/8985609/union-all-in-cte
more complicated recursive CTE examples here:
http://stackoverflow.com/questions/3159192/sql-server-2008-cte-recursion
Active today
as it's not clear (to me) what you want to achieve, can you please show examples of the values of @main, @sql1, @sql2 and the requested end result
@main=select * from table A inner join table B
@sql1= @main + " inner join table C"
@sql2= @main + " inner join table D"
Something like that.
I got Union All and result correct, i don't know why use CTE? any better?
Thanks.
@sql1= @main + " inner join table C"
@sql2= @main + " inner join table D"
Something like that.
I got Union All and result correct, i don't know why use CTE? any better?
Thanks.
Active today
that looks fine, actually, in the basics, so it should work
the question is: why you want/need dynamic sql.
with CTE, you would avoid dynamic sql which may give you issues at other levels.
the question is: why you want/need dynamic sql.
with CTE, you would avoid dynamic sql which may give you issues at other levels.
;WITH main AS ( Select * from tableA inner join table B ON ... )
SELECT * from main join table_c on ...
UNION ALL
SELECT * from main join table_d on ...
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article.
SARGable is an adjective in SQL that means that an item can be fou…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…
- Microsoft Applications
- Windows 10
- Windows OS
- Fonts Typography
- Windows 7, Microsoft Word
Suggested Courses
Course of the Month14 days, 8 hours left to enroll
770 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.