Hi,
Need to implement the below logic, it would of great help if you have any suggestions.
2 tables I got T1 and T2 with below values.
T1 having 10 million rows and T2 having 5 million rows.
T1 Table
C1 Column name
1
1
2
3
4
4
5
6
T2 Table
C1 Column name
1
3
6
7
Output Should be
2
4
5
Any ideas would be appreciated.
Thanks,
Logic Help
Moderators: chulett, rschirm, roy
How about describing the requirements of the logic you're having trouble with in words, please? Something like: "The output should contain the rows/columns/whatever from input xxxxxz which yyyyyy to input zzzzzz" where yyyyyy is a condition such as match/don't match or maybe something more complicated?
By showing us only the input and expected output you're expecting us to guess/reverse engineer what the logic in the black box between input and output should be. If the input and output is all that you were given (whether as a job specification or an interview question), you may likely find that by trying to describe to us what you see makes the required logic clear to you.
Regards,
By showing us only the input and expected output you're expecting us to guess/reverse engineer what the logic in the black box between input and output should be. If the input and output is all that you were given (whether as a job specification or an interview question), you may likely find that by trying to describe to us what you see makes the required logic clear to you.
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
-
- Participant
- Posts: 47
- Joined: Thu Dec 09, 2010 4:37 am
I'm firmly in agreement with James on this. I'm tired of and not going to be guessing at the answer to "questions" where all that is posted in an alleged example of the input and the desired output.
Lay our your requirements, people! Spell it out in words. Tell us what you've tried and what issues you've faced. I'm putting away the silver platter.
Lay our your requirements, people! Spell it out in words. Tell us what you've tried and what issues you've faced. I'm putting away the silver platter.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: