Search Results

Search found 9764 results on 391 pages for 'cross join'.

Page 22/391 | < Previous Page | 18 19 20 21 22 23 24 25 26 27 28 29 | Next Page >

SSIS Basics: Using the Merge Join Transformation

SSIS is able to take sorted data from more than one OLE DB data source and merge them into one table which can then be sent to an OLE DB destination. This 'Merge Join' transformation works in a similar way to a SQL join by specifying a 'join key' relationship. this transformation can save a great deal of processing on the destination. Annette…

Read the article
SSIS Basics: Using the Merge Join Transformation

SSIS is able to take sorted data from more than one OLE DB data source and merge them into one table which can then be sent to an OLE DB destination. This 'Merge Join' transformation works in a similar way to a SQL join by specifying a 'join key' relationship. this transformation can save a great deal of processing on the destination. Annette…

Read the article
flXHR - getting started (a simple question)

- by Yaron

Hello, I am trying to use the flXHR javascript library for making cross-domain calls. I got stuck at the begining. As they say in the docs, I copied the /deploy directory's content to a /scripts directory. All the dependencies are supposed to be included in the flXHR download. This is my html, which returns several errors: …

Read the article
Can you drag and drop a URL with a large icon/graphic from a web page to you desktop?

- by Peter Mahnke

Is there anyway to create a desktop icon (cross platform/browser) from a linked image on a page without some kind of executable? <a href="http://www.example.com"><img src="nice_icon.png" /></a>

Read the article
Cross-Channel Survey Report

- by David Dorf

The folks at Retail Touchpoints surveyed 84 retailers on the topic of cross-channel and have published the results in Completing the Cross-Channel Challenge. Below is an overview video that summarizes the findings and cites retailer examples. One thing is clear: customers demand Commerce Anywhere, the ability to shop…

Read the article
Cross-Cultural Design (great video from HFI) - #usableapps #UX #L10n

- by ultan o'broin

Great video from HFI Animate, featuring user-centered design for emerging markets called Cross Cultural Design: Getting It Right the First Time. Cross Cultural Design: Getting It Right the First Time Apala Lahiri Chavan talks about the issues involved in designing solutions for Africa, India, China and more…

Read the article
Heaps of Trouble?

- by Paul White NZ

If you’re not already a regular reader of Brad Schulz’s blog, you’re missing out on some great material. In his latest entry, he is tasked with optimizing a query run against tables that have no indexes at all. The problem is, predictably, that performance is not very good. The catch is that we are not allowed to…

Read the article
execute javascript function in a another iframe when parent is from different domain.

- by Frushko

The page A.com has 2 iframes B.com/page1 and B.com/page2. This is the code of A.com: <html><body> <iframe src="b.com/page1" name="iframe1" id="iframe1"> <iframe src="b.com/page2"> </body></html> I want to execute js function on B.com/page1 from B.com/page2. Both examples below works…

Read the article
Ubuntu and Windows 8 shared partition gets corrupted

- by Bruno-P

I have a dual boot (Ubuntu 12.04 and Windows 8) system. Both systems have access to an NTFS "DATA" partition which contains all my images, documents, music and some application data like Chrome and Thunderbird Profiles which used by both OS. Everything was working fine in my Dual boot Ubuntu/Windows 7, but after updating to…

Read the article
Example: Cross Cutting Concerns of an Application

A little while ago I was given an opportunity to design and implement a new system that sent data via an HTTP Post method and then processed the results that were returned so that they could be inserted in to a database. My system had eight core concerns that it needed to fulfill. Eight Core Concerns Database Access Data…

Read the article
In SQL, a Join is actually an Intersection? And it is also a linkage or a "Sideway Union"?

- by Jian Lin

I always thought of a Join in SQL as some kind of linkage between two tables. For example, select e.name, d.name from employees e, departments d where employees.deptID = departments.deptID In this case, it is linking two tables, to show each employee with a department name instead of a department ID. And kind of…

Read the article
Flash doesn't connect to socket even though policy allows it

- by Bart van Heukelom

In my Flash app, I'm connecting to my server like this: Security.loadPolicyFile("xmlsocket://example.com:12860"); socket = new Socket("example.com", 12869); socket.writeByte(...); ... socket.flush(); At port 12860 I'm running a socket policy server, which (according to this document) correctly serves up my policy like…

Read the article
What's the different between these 2 mysql queries? one using left join

- by Lyon

Hi, I see people using LEFT JOIN in their mysql queries to fetch data from two tables. But I normally do it without left join. Is there any differences besides the syntax, e.g. performance? Here's my normal query style: SELECT * FROM table1 as tbl1, table2 as tbl2 WHERE tbl1.id=tbl2.table_id as compared to SELECT *…

Read the article
In SQL / MySQL, can a Left Outer Join be used to find out the duplicates when there is no Primary ID

- by Jian Lin

I would like to try using Outer Join to find out duplicates in a table: If a table has Primary Index ID, then the following outer join can find out the duplicate names: mysql> select * from gifts; +--------+------------+-----------------+---------------------+ | giftID | name | filename | effectiveTime …

Read the article
Why would I do an inner join on a non-distinct field?

- by froadie

I just came across a query that does an inner join on a non-distinct field. I've never seen this before and I'm a little confused about this usage. Something like: SELECT distinct all, my, stuff FROM myTable INNER JOIN myOtherTable ON myTable.nonDistinctField = myOtherTable.nonDistinctField (WHERE some filters…

Read the article
why this left join query failed to load all the data in left table ?

- by lzyy

users table +-----+-----------+ | id | username | +-----+-----------+ | 1 | tom | | 2 | jelly | | 3 | foo | | 4 | bar | +-----+-----------+ groups table +----+---------+-----------------------------+ | id | user_id | title |…

Read the article
Is it a Good Practice to Add two Conditions when using a JOIN keyword?

- by Raúl Roa

I'd like to know if having to conditionals when using a JOIN keyword is a good practice. I'm trying to filter this resultset by date but I'm unable to get all the branches listed even if there's no expense or income for a date using a WHERE clause. Is there a better way of doing…

Read the article
how to join a group in this site .. [closed]

- by zjm1126

this is a gae site,but i can't join the other's group, how to do this ? what is mean: "To Join a group send /join groupName password to our bot" https://instantshout.appspot.com/ thanks

Read the article
In SQL / MySQL, what is the difference between "On" and "Where" in a join statement?

- by Jian Lin

The following statements give the same result (one is using "on", and the other using "where"): mysql> select * from gifts INNER JOIN sentGifts on gifts.giftID = sentGifts.giftID; mysql> select * from gifts INNER JOIN sentGifts where gifts.giftID = sentGifts.giftID; I can…

Read the article
Does it make sense to replace sub-queries by join?

- by Roman

For example I have a query like that. select col1 from t1 where col2>0 and col1 in (select col1 from t2 where col2>0) As far as I understand, I can replace it by the following query: select t1.col1 from t1 join (select col1 from t2 where col2>0) as t2 on…

Read the article
Limitations of the SharePoint join using CAML

- by ybbest

Limitation One In SharePoint 2010, you can join the primary list to a foreign list and include more than one field from the foreign list. However, the limitation is that the included fields from foreign list have to be the following type: Calculated (treated as…

Read the article
Topics for development team cross training sessions

- by BBlake

Our team of developers are going to start holding monthly meetings for the purposes of cross training and knowledge improvement. We're looking for ideas for topics to discuss. We've already made a list of some obvious ones, such as discussions/training on…

Read the article
Hosting cross-domain Silverlight applications (XAP)

In the Silverlight world, there are two types of cross-domain things that may leave some banging their head against a wall for a while. The first involves making network-based calls (WebClient, HttpWebRequest, etc) to services hosted on a domain other than…

Read the article
Google I/O 2012 - Fast UIs for the Cross-Device Web

Google I/O 2012 - Fast UIs for the Cross-Device Web Boris Smus One of the great features of the modern web is that sites work on any device with a browser. This session will focus on creating UIs for the cross-device web. We will cover building web sites…

Read the article
SQL Outer Join on a bunch of Inner Joined results

- by Matthew Frederick

I received some great help on joining a table to itself and am trying to take it to the next level. The SQL below is from the help but with my addition of the select line beginning with COUNT, the inner join to the Recipient table, and the Group By. …

Read the article

< Previous Page | 18 19 20 21 22 23 24 25 26 27 28 29 | Next Page >