I have an XML file like this:
<detail value1="hello" value2="world" />
View Complete Post
View Complete Post
I am trying to join a dimtime table by a refernced join to an orderlines table which is the fact.
(the referenced join was defined in the relationship matrix of the cube ).
The referenced table is the ordersheader which had no measures in it but only used a linking table between those two other.
The join from the dimtime to the ordersheader is done by date and from ordersheader to orderlines by orderid
The problem is that in the cube browser measures are shown as they were multiplied across all dates (like the join was done in a wrong way )
I have created an sql query and the logic is working just fine when quering directly from the DB
What am I doing wrong
I noticed this has been posted before - but could not get it working with the information on that post so here goes:
I have a T-Sql query that INNER JOINs 2 tables on one field - this returns 6,383 records.
(the one table contains 6,383 records and the other table 12 records)
However when I try to implement a data flow task with two data sources (one for each table) and sort the and then try to use the Merge Join transformation to sort and join them on the exact same field the result is 11,073 records.
What is going on here? logically this does not make sense to me ...
I have a number of tables, whereby I want to join the tables to a parent table. My problem is that I wish to show every row of the table, but only show these rows once. This is hard to explain in text, so I have provided a example table below, which is the
output I expect from the sql below. The #SI is the parent table.
(Note that I have only created the example with 4 tables. The actual number of tables will be more that this).
I have the scenario (using a third party component) where certain columns must not be present as input.
I am doing a Full Outer - Merge Join.
This results in:
but now in some cases the LeftPK may be null in other cases the RightPK may be null,
so i'm creating a derived column to check:
ISNULL(LeftPK) ? RightPK : LeftPK
and call this the TruePK
this all works however now i'm left with 3 columns
LeftPK; RightPK; TruePK
Is there some kind of transform (other than script task) that i can use to get rid of Left and Right PK columns before sending input to next third party component?
I'm working with SQL 2008 SSIS.ÃÂ I'm trying to join two tables onÃÂ email fields.ÃÂ For test purposes I have copied some of the email addresses from table A to table B to insue I have matching values.ÃÂ The OLE DB Source componentsÃÂ each use a SQL query that sorts the output by the email addresses in ascending order.ÃÂ ÃÂ For each of the two source components I've set the IsSorted property to True and set the Output Columns SortKeyPosition property to 1.ÃÂ Within the SQL query I've also added trim functions to eliminate any possible extra spaces.ÃÂ Since for testing purposes table B's email addresses are copies of email addresses in table A thereÃÂ is no issue with case.ÃÂ ÃÂ When linking the two outputs using the Merge Join flow component I do not get any matches.I've tried sorting using a Sort component rather than within the OLD DB Source query, but it seems to lock up on one of my flows (about 1.5 million records) and won't proceed.At this point I don't know what else to try.ÃÂ
I would like to know whether people use the join syntax OR projection when joining entities in LINQ to SQL queries. I have noticed that when using projection that a CROSS JOIN is in the generated SQL
var query = from o in Ordersfrom oi in o.OrderItems where oi.OrderId == o.OrderId
generates SQL something like...
FROM [Customer].[Orders] AS [t0]CROSS JOIN [Customer].[OrderItems] AS [t1]WHERE ([t1].[OrderId] = [t0].[OrderId]) AND ([t1].[OrderId] = [t0].[OrderId])
whereas with explicit joins I get a clean inner join..
var query = from o in Ordersjoin oi in OrderItems on o.OrderId equals oi.OrderId
FROM [Customer].[Orders] AS [t0]INNER JOIN [Customer].[OrderItems] AS [t1] ON [t0].[OrderId] = [t1].[OrderId]
I know using explicit joins over projection is frowned upon, but I am wary of those cross joins.
Just wondering what other folks preferences are when using joins in L2SQL.
I have 3 tables. I would like to get the number of records in table A that do not have cooresponding co_asset_ids in TABLE C but also need
to be be found in TABLE B and where the asset_id = 3. Said another way: If TABLE A record is in TABLE B and does not find a co_asset_id of 3 as found in table C then show these records.
assetno 4 and 5 are irrelevant but added to fill out the data more.
I know I could do this getting the co_asset_id column into TABLE A and then do some joins between TABLE A and TABLE C and leave TABLE B out, which I have done in the past. I would like to finally know if this can be done by using the 3 tables together
in one elegant query.
The result of this query for this example data would be:
I have a process which reads from 2 tables (using two connection managers) and "merge join" them to a third table by using left outer join.
This process is implemented on SSIS 2005 and SSIS 2008 identically, however, for some reason I get
less records at the third table at the 2008 process.
I am after creating a mail merge documents from datasource and .dot template file on server side. Can you give me an idea how i will achive this?
Thanks in advance.
It's been more than a year since my words last floated across the pages of MSDNÃÂ®Magazine. As readers of my blog probably know, my life's been interesting the past 12 months.
MSDN Magazine January 2005
I have a select query which is executing well. Now, I want to add one more field to that query. That field is not in the current query table, It is in the another table.
How do I join those two tables and get that field value in the existing select query.?