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.
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 asticker funmanager table1shares table2shares table3sharessample data is liketabl1ticker funmanager table1sharesIBM Oldmutal 20000IBM NEWHOLD 22000TABLE2Ticker funmanager Table2sharesIBM Oldmutual 30000IBM NEWHOLD 18000Table3Ticker funmanager table3sharesIBM OLDMUTUAL 5000IBM NEWHOLD 3000in final tableticker funmanager table1shares table2shares table3sharesIBM OLDmutual 20000 30000 5000IBM NEWHOLD 22000 18000 3000Need 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? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|