June 2, 2008 at 1:24 pm
Hi,
Here is the task.....I know it is quite difficult to read and understand such a large post with different tables and relations....But I ve no other option....Please suggest me the best way to implement this...any help would be appreciated...Thanks in advance...
My task is to create and populate a table called :
-tblActivity(datetime, transactionid, groupsid, officesid, usersid, accountnumber, locationcode, lowvolume)
From the below tables--
-tblActivityapril(eventcode, usernid, referralnid, providernid, patientnid)
(*We can take Usernid from above table to compare and extract data from the other tables*).
-tblUserDimension (usersid,usernid,officenid,roleid,user_oid,firstname,lastname)
(*From usernid we ll get usersid, officenid*)
-tblOfficeDimension(officesid,officenid,groupnid,name,address,zip,phone)
(*from officenid we ll get officesid,groupnid*)
-tblMHSOffice(serviceOID,OfficeNID,accountnumber,lowvolume,locationcode,transactionid)
-tblGroupDimension(groupsid, groupnid,groupstatusid,name,address,zip,phone)
June 2, 2008 at 7:49 pm
Not sure what exactly you are are looking for, and based on lack of response, I'm not the only one, but based on my understanding you should be able to do a simple insert into using this select:
[font="Courier New"]SELECT
GETDATE(),
MO.transactionid,
GD.groupsid,
OD.officesid,
UD.usersid,
MO.accountnumber,
MO.locationcode,
MO.lowvolume
FROM
tblActivityApril AA JOIN
tblUserDimension UD ON
AA.usernid = UD.usernid JOIN
tblOfficeDimension OD ON
UD.officenid = OD.officenid JOIN
tblMHSOffice MO ON
UD.officenid = MO.officenid JOIN
tblGroupDimension GD ON
OD.groupnid = GD.groupnid
[/font]
Check out the links in my signature line to get some ideas on how to ask a question that will get quick and accurate responses.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 3, 2008 at 7:26 am
Thanks a lot....you almost gave the solution...
June 3, 2008 at 9:28 am
Glad I could be of some help. Can you post what you did? I might learn something from that.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 3, 2008 at 9:49 am
I have not completed it yet...may be it takes time...what i did is, I took a datasource in ssis and selected the sql query option and I wrote the query using joins as u specified. then I connected that source to the OLEDB destination. that works...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply