Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Need Suggestion

Author  Topic 

vishveshk
Starting Member

3 Posts

Posted - 2010-05-05 : 10:29:52
I have 4 tables with shares column,funmanager,ticker.

I need to get the data as

ticker funmanager table1shares table2shares table3shares

sample data is like

tabl1

ticker funmanager table1shares

IBM Oldmutal 20000

IBM NEWHOLD 22000

TABLE2

Ticker funmanager Table2shares

IBM Oldmutual 30000

IBM NEWHOLD 18000

Table3

Ticker funmanager table3shares

IBM OLDMUTUAL 5000

IBM NEWHOLD 3000


in final table


ticker funmanager table1shares table2shares table3shares

IBM OLDmutual 20000 30000 5000

IBM NEWHOLD 22000 18000 3000


Need suggestion to create a package to get this output..

vishvehskk.

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2010-05-05 : 10:42:40
Why a package? Simple SQL query should do, no?

Anything else you want to do with the result of the SQL?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-05-05 : 14:51:16
duplicate

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=144049

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -