Union VS Union All

-


Union
Union All
used to combine ( set operation ) two or more query results

Used to combine (set operation) two or more query results

UNION will eliminate duplicate rows

UNION ALL will display all rows.

Comments

Post a Comment

Popular posts from this blog

Announcing – Embed your Power BI organizational apps in Microsoft Teams Channels and Meetings

-
Image
We’re excited to announce that you can now embed entire Power BI organizational apps in Microsoft Teams tabs. Until now, this has been one of the top feature requests for Power BI integration with Microsoft Teams. It helps teams and organization put the full Power BI org app experiences directly where people work every day. By adding Org apps in channels and meetings, you enable everyone to access the data they need. We’ve started to roll out the experience to commercial cloud customers and expect it to be available for everyone in the next week or two. Let’s look at the new experience and its benefits. Picking an entire Power BI organizational app to embed in Microsoft Teams To embed a Power BI organizational app, add a Power BI tab to a channel or meeting. Go to the Apps pivot in the selection you and notice the  new checkbox next to the app name . When you check the box, you’re choosing to embed the entire organizational app in the Power BI tab.  If you don’t see an app in ...
Read more

Failed to execute the package or element. Build errors were encountered

-
Error: TITLE: Microsoft Visual Studio ------------------------------ Failed to execute the package or element.   Build errors were encountered. For more information, see the Output window. ------------------------------ BUTTONS: OK ------------------------------   Solution: We tried to close SSDT and run it again but, we still got the same error while running SSIS package. Then, we need to follow bellow solution: Step 1: Go to Task Manager–> Details Tab. Step 2: Locate the process “ DtsDebugHost.exe “. Kill this process. There might be multiple instances of this process. Kill all of them. Step 3: Rerun SSIS package
Read more

Add the Power BI app to Microsoft Teams

-
Image
This article describes how you can install, pin, and interact with Power BI right inside Microsoft Teams. The Power BI personal app brings the entire basic Power BI service experience to Microsoft Teams. The Power BI app in Microsoft Teams is one of the ways that you can   collaborate with Power BI in Teams . The app is your personal experience of Power BI. It's as if the Power BI service lives inside Microsoft Teams. After you install it, you can do almost everything in Microsoft Teams that you can do in the Power BI service: Create, view, and edit dashboards, reports, and apps. Create and participate in workspaces. Share content, either through email or through Microsoft Teams. And there's a feature in the Power BI app in Teams that you don't see when you view the Power BI service (app.powerbi.com) in a web browser. On the Power BI home page in Teams, you can   see all the Power BI tabs you've viewed , everywhere in Teams. There are a few features that you can only ac...
Read more