Who is online?  0 guests and 1 members
Home  »  search results

Search Results: Joins

50 results found
  • Joins From A Common Sense Perspective
    In this article, Sherri McDonald gives an overview of the common Join commands and has also included examples and diagrams.
    Author: SMcDonald SMcDonald     Date: 11/27/2010     Section: Article
  • Foundation Day 4 done. Now Time for interviews
    Today in the Foundation class we reviewed JOINS a lot more and started working in the GUI for the JOINS. I do like how the GUI can help you understand the relationships going on and can get your JOINS started but at the same time it is a pain in the glute
    Author: peanutmanak47 peanutmanak47     Date: 8/3/2012     Section: Blog
  • Joins - Making the Abstract Clear
    Studying joins and their concepts can be a bit abstract. Covering the idea of one to many, many to one, many to many relationships can be understood fairly easy. Where joins become hazy is in how they extract data from tables and get data that is needed.
    Author: ogonzalez ogonzalez     Date: 6/7/2011     Section: Blog
    tags : Diagrams, Joins
  • Cross joins across user defined hierarchies aren't supported .?
    Hello all, It’s not appropriate to post as this a blog but it might help to most of us in field of BI having similar kind of confusion /issue. I have some confusion on crossjoin function within MDx. while I try to crossjoin the different level sets
    Author: Anil Anil     Date: 9/20/2011     Section: Blog
  • Blow Up Your Joins!
    The light burst on with full luminance when it comes to the parts of a join and how they function. Take the join statement and break it up in a 3-D virtual graph and look at how each part works and then the syntax and logic become more apparent. Joins mak
    Author: ogonzalez ogonzalez     Date: 6/8/2011     Section: Blog
  • My Foundation Class 8-15-2011
    Today was the first day of our 3rd Pragmatic Works Foundation Class for 2011. We have a great group that is incredibly interactive. It's an interesting environment when you are teaching live compared to virtual training. The obvious is you will have more
    Author: SMcDonald SMcDonald     Date: 8/15/2011     Section: Blog
  • Recursive Queries and The Power of Common Table Expressions
    Yesterday I was working on a requirement for a client that asked me to show a list of Organizational Units and the every single parent Organization above every Organization. The source table gave each Org Unit’s ID with their parent Org Unit’s ID. In Orac
    Author: DustinRyan DustinRyan     Date: 4/8/2011     Section: Blog
  • T-Sql, or not t-sql...
    Well, I wanted to refrain from posting until I had successfully uploaded my profile image, however thanks to DSL internet and an unusually high megapixel camera phone, I will be forgoing that tonight. Better luck tomorrow, huh? Day one of Pragmatic Work's
    Author: RCharCox RCharCox     Date: 2/21/2012     Section: Blog
  • Day 2 of My Pragmatic Works Foundation experience
    Day 2 Not feeling overwhelmed at all but instead feeling my confidence growing much stronger as I continue to relate to some of my previous trainings and actually put the skills into action. Training is definitely a lot easier when you have a comical teac
    Author: SqlPrincezz SqlPrincezz     Date: 3/2/2011     Section: Blog
  • 3rd day of Pragmatic Works, let's all INNER JOIN hands and sing.
    Greetings again everyone. Today in the 3rd day of class at the Pragmatic Works Foundation we covered a variety of topics. I would like to share INNER JOINs. INNER JOINs allow multiple tables to be included in a query. The ability to have mulitple tables i
    Author: Xtrasweettea Xtrasweettea     Date: 9/19/2012     Section: Blog
  • SQL the Prequel to understanding
    Today was my second day in the exploration of SQL. Many of my worries from the first day were eliminated with the realization that everyone in my class was exactly where I was. I now have learned more about basic SQL and onto Joins. Joins seem simple enou
    Author: William William     Date: 12/6/2011     Section: Blog
  • need to change the column data based on reference from two other tabel's in ssis etl framework
    While the package might get a little convoluted, you might want to consider the LOOKUP tranformation within your data flow(s) too. Here is a quick introduction ( blog ) to the transform and how you can use it to get data from another source. http://www.bi
    Author: KeithHyer KeithHyer     Date: 11/21/2011     Section: Forum
  • Join 5 tables
    Looks like you may need to do left outer joins instead of inner joins, Then use a group by to group on the id and get what you need from the tables with some form or aggregations like Sum or Max.
    Author: MikeDavis MikeDavis     Date: 8/11/2010     Section: Forum
    tags : tsql
  • why we can not select the Dimension member in column while writing MDx in Query Designer while designing .rdl report in BIDS using SSAS cube as Data source.?
    Thanks Mike, I also think so and as you say I had tried and obtains certain analysis output but while firing MDx in querydesigner it mainly crossjoins all the attributes that we are trying to have analysis .So, it is not as much feasible as we think for m
    Author: Anil Anil     Date: 2/10/2011     Section: Forum
    tags : MDx, SSRS
  • Integration Services Lookup Components ARE NOT Inner Joins
    Recently I was working with a client on the layout for a complex Integration Services package. At one point we were discussing the merits of Data Flow Lookup versus Merge Join components. During the conversation I realized that some confusion existed abou
    Author: CraigLove CraigLove     Date: 3/9/2012     Section: Blog
  • My second day
    My second day was filled with review exercises of the commands we learned on day one. This helped alot because allowed to learn the information with more repetition. Some of the commands were case, order by, group, unions, joins, inserts, updates. We also
    Author: Paul Paul     Date: 2/10/2010     Section: Blog
    tags : Foundation
  • Joining the Joins
    I left out of my second day of class with Pragamatic Works Foundation today feeling like I did know anything at all....wondering if I still had what it took to be in this field. Decided I would take a break and give this tired brain a rest, had dinner, sp
    Author: TamMichau TamMichau     Date: 2/22/2012     Section: Blog
  • Created My First Report
    Ok, first thing first. If anybody has any sample problems that can be worked with the AdventureWorks db ( sherrilmcdonald@gmail.com ), please send them my way. I would love to keep practicing on my joins and creating the store procs. I would say that toda
    Author: SMcDonald SMcDonald     Date: 2/10/2010     Section: Blog
    tags : Foundation
  • Day 2
    They say times flies when you are having fun but time also flies when you are learning. I guess the day went by so fast because I actually enjoyed what I was working on. I really do think that T-SQL is my strength in the computer field. SQL was one of my
    Author: MCao MCao     Date: 2/9/2010     Section: Blog
    tags : foundation
  • Goal for the Week of 2/15/2010
    1. Get through most of the Murachs's SQL Server Book. 2. Have a very good understanding of Joins and when to use left, right, outer. 3. Watch all the current AppDev Videos I have. 4. Participate in the JSUG on Wednesday night. 5. Take multiple sql quizes
    Author: SMcDonald SMcDonald     Date: 2/16/2010     Section: Blog
    tags : Pragmatic
  • DAY2 OMG!!!!
    I know one day when I look back at these postings I will laugh at how much I was whining and crying like a little girl. I need to go home and PRACTICE, PRACTICE, PRACTICE! What I have found to be helpful is trying to complete the task myself and then go a
    Author: SMcDonald SMcDonald     Date: 2/9/2010     Section: Blog
    tags : foundation
  • How to Use SSIS to Loop through First 49 Diagnoses, Procedures and POA Flags
    Keith, I've gone with the stored procedure approach and have updated your syntax to reflect the various joins, fields and where clause. Note that I need to pivot up to 49 procedure codes as well. I've attempted to adapt your syntax but receive an error ne
    Author: schilders schilders     Date: 8/1/2011     Section: Forum
  • Insert into Select vs Data Flow task with Fast Load Performance
    I have an SSIS package where I am inserting around 100,000 (lot of guid) records from staging tables (making some joins) to final table using "insert into table select column names". Reading the execution plan it says it is costing almost 30 % on Clustere
    Author: dpatel dpatel     Date: 6/17/2010     Section: Forum
  • Stored Procedure with CTE Used to Check for Two Transaction Types on the Same Date of Service
    I'm not 100% sure what you're after, but here is a way to get a "raw" listing of ( I called them CustomerIDs ) that have more than 1 of the same "TranCode" on differing dates of service. I tried to comment it - and it does not use CTE - just some JOINs to
    Author: KeithHyer KeithHyer     Date: 6/13/2011     Section: Forum
    tags : Grouping
  • Cross join in Named set
    How to use cross join in Named Set of a Cube. I have wriiten a expression for TopCount with CrossJoin like: 1) TOPCOUNT(CROSSJOIN( [DimScale].[Source].Children, [DimScale].[ID].Children ), 5, [Measures].[Tickets]) 2) And also written in script command lik
    Author: chandravangari chandravangari     Date: 10/12/2011     Section: Forum