Sure thing!

The purpose is to create a table/recordset that lists the top ten holdings for each portfolio. This is then used by my users to illustrate how the portfolio is...

Hi Guys thank you for your help!

Here is a sample of the data. Thanks again! :

CREATE TABLE [FactSheet].[StagingEquityHoldings](

[Instrument_Instrument_Id] [nvarchar](50) NULL,

[Class_0_Minor_Description] [nvarchar](50) NULL,

[Issuer] [nvarchar](50) NULL,

[PK_Date] [nvarchar](50) NULL,

[Port_Portcode] [nvarchar](50) NULL,

[Portname] [nvarchar](50) NULL,

[Total_Perc_Port_Mkt]...