An example of the result

Headers:

CompanyId,MetadataId,Mnemonic,Short,format,MetaData,Type,lngValue,charValue                                                                                                                                                                                                                                                       

results:

294,888,XX_InvestmentCase,Investment,20,3,NULL,NULL

294,924,XX_OwnershipStructureFieldPeriod,OwnershipDate.20,3 ,NULL,NULL

294,949,XX_OwnershipFieldB7,%ofvotes 7,20,3,NULL,NULL

294,1198,XX_CreditRecommendation,CreditRecommendation,0,7,240,NULL

Here we can see that only the last row has a value in CDX_CompanyDataXX table, the value 240. The others has no value and...

My order table, the table that distinguise which mnemonics should be included is, the CDO_CompanyDataXXOrder. That table is affecting all companies so no CompanyId can be found there. only MED_id(s) for all companies....

Yes the second suggestion returns not only where Comp_id=1 AND Comp_id=2 but

when Comp_id=1 or Comp_id=2

But how can I accomplish a SP where I can send in a string of parameters...

Thanks Noel!

I need the column first to set defined names, then I want to to set values in the sheet and in the same column as well where I placed my...

I've just dynamically created a recordset (RS):

1. I create a Time collection that vill be used to create all the columns in the RS
2. Create the fields (columns) in the RS by...

TheWildHun:

Well I think you propose to change the formulas as shown in the example. That solution I know. But I was thinking...