Hello Jason, I have a question, I checked the results that your code returns and I think it does A LOT of what I need to have as a result....

Hello, sorry I did not respond to your comment before, my son got sick and had to take a day off. I am going to look at your code and...

Hello, I think you are correct. I just do not know how to include all the tables and data involved in the creation of these "smaller" sets and ask my...

Hi Sean,

I uploaded a file with more data.

Look at file: instruments_reference_table.txt

Search for: 930Guitar/Fretted Strings88230

The sub_category_column is contained in the same table. No other table is missing.

For example, column sub_category_of with value of 930, it belongs to "Guitar/Fretted Strings", which also has its...

I uploaded a new file with more data.

Also this is the query I was starting to work myself:

SELECT DISTINCT i1.instrument_id

, i1.description [instrument_description]

, i2.instrument_id parent_instrument_id

, ...

@fridaynightgiant:

I am following up your recommendation that is to pass a comma separated string with the values for the fonts I need. I format the string in the...

can the second sp be called from within the first sp?

Yes, the first pass it includes all 7 fonts.

Then I pass 2 fonts that I want to keep, which are Doremi, and Arial, every other gets deleted.

Then I pass 3...

Yes, the first pass it includes all 7 fonts.

Then I pass 2 fonts that I want to keep, which are Doremi, and Arial, every other gets deleted.

Then I pass 3...

I am unfamiliar with table valued parameters, my experience with T-SQL is not vast, and thought this was an easy to do task even with limited skills. Is there a...

I tried your code and it gives me same results as the stored procedure I attached.

I ran the same steps as I posted before a couple of entries ago,...

I need to be able to delete because this scenario can happen, and perhaps I am not understanding correctly but let me explain.

Arrangement Id MN0164781 has 5 Fonts in the...

Yes, I want to be able to insert multiple fonts per Arrangement Id.

I also want to be able to delete fonts that are no longer needed, per Arrangement Id.

I...

This is correct. Thank you William.