December 17, 2012 at 6:41 am
Hi Koen,
SSIS TASK Help:
Good day. I am new to SQL. I have a task to do. Hope you can help me on this. I need to retrieve the data from five different databases and split them into matched and unmatched records based on one column (amount column). All databases have one or more unique columns(all have amount column).
And I have another question for you. I have a customer table in a database with Million records apporx. And amount in another database table. I need to split the amount equally to all the customers in customer database.
Thank you,
Kind Regards,
KK
NOBODY REMAINS VIRGIN LIFE FU**S EVERY ONE..:exclamation:
December 17, 2012 at 8:51 am
karna5999 (12/17/2012)
Hi Koen,SSIS TASK Help:
Good day. I am new to SQL. I have a task to do. Hope you can help me on this. I need to retrieve the data from five different databases and split them into matched and unmatched records based on one column (amount column). All databases have one or more unique columns(all have amount column).
And I have another question for you. I have a customer table in a database with Million records apporx. And amount in another database table. I need to split the amount equally to all the customers in customer database.
Thank you,
Kind Regards,
KK
I'm not exactly sure what your question is.
What have you tried, and where are you getting stuck?
December 17, 2012 at 9:09 am
It sounds to me like you have a business definition for a workflow, and you need to turn it into a technical specification, then work out an implementation path.
Judging by what little data you have provided, you may be better off hiring a contractor for this, than trying to do it in-house. A lot of that will depend on what kind of timeline you're looking at for project completion.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply