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 |
|
sharona
Yak Posting Veteran
75 Posts |
 Posted - 2011-09-26 : 13:27:57
|
| I have the following scriptCREATE TABLE #FINAL( FUNDCODE VARCHAR(4), ACTIONCODE VARCHAR (24), ROLECODE VARCHAR(4), _BCP VARCHAR(24), ABAC VARCHAR(24))-- GET ALL FUNDS ---SELECT DISTINCTR.FUNDCODE,R.ACTIONCODE,R.ROLECODEINTO #FUNDfrom dbo.RoleAction Rwhere R.FundCode IN ('_BCP','ABAC')GROUP BY R.ACTIONCODE,R.ROLECODE,R.FUNDCODE--Add all data to the final tableINSERT #Final( ACTIONCODE, ROLECODE)SELECT DISTINCT ACTIONCODE, ROLECODEFROM #FUND -- Update final tableUPDATE #FinalSET _BCP = R.ROLECODEFROM #fund r, #Final fWHERE f.ACTIONCODE = r.ACTIONCODE AND r.FUNDCODE = '_BCP'UPDATE #FinalSET ABAC = R.ROLECODEFROM #fund r, #Final fWHERE f.ACTIONCODE = r.ACTIONCODE AND r.FUNDCODE = 'ABAC'----Final selectselect distinct ACTIONCODE, _BCP, ABACfrom #FINALgroup byACTIONCODE,_BCP,ABACthe data that is produced is by this script(------------- column divider)AddCashAccounts -------------ITA -------------FR AddCounterparty -------------TDM -------------ITA AddEditBroker -------------ID -------------TDM AddNewDeal -------------SET -------------ITA AddServicer -------------ITA -------------TDM some of the functions have multiple values for exampleAddCashAccounts i need to see ITA, FR, EOAddCashAccounts -------------ITA,FR,EO -------------FR,SET AddCounterparty -------------TDM,TD -------------ITA AddEditBroker -------------ID -------------TDM, TD AddNewDeal -------------SET,SETD -------------ITAAddServicer -------------ITA -------------TDM, TDhow do i insert multiple values into one column? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
|
|
multiple values into one column