Thank you in advance.
My company is switching part numbers. We would like to display the new part number along with the old part number for the next few months to get customers and vendors used to the new system of numbers.
The main issue is that the data that was provided to me is set up totally different than our original data...
I would like to know how to do the following join inside of a cfquery/logic.
I have three tables:
- Original data (Year, make, model, description, etc all in their own columns)
- The new data (in one row i now have a "69 coronet, 70 corvette, 75 Camaro going on for 570 columns!!!!" along with other columns that provide specs for the part. I'm using this to build my drop downs)
- New Part Numbers and applications (vehicles they fit)
I would like to doing something similar to:
SELECT PartNumber FROM Apps WHERE EXISTS (SELECT YMM FROM YMM WHERE Apps.App1 = '69 Coronet' OR Apps.App2 = '69 Coronet' OR Apps.App3 = '69 Coronet' OR Apps.App4 = '69 Coronet' OR Apps.App5 = '69 Coronet' OR Apps.App6 = '69 Coronet' OR Apps.App7 = '69 Coronet' OR Apps.App8 = '69 Coronet' OR Apps.App9 = '69 Coronet' OR Apps.App10 = '69 Coronet' OR Apps.App11 = '69 Coronet' OR Apps.App12 = '69 Coronet' OR Apps.App13 = '69 Coronet' OR Apps.App14 = '69 Coronet' OR Apps.App15 = '69 Coronet' OR Apps.App16 = '69 Coronet' OR Apps.App17 = '69 Coronet' OR Apps.App18 = '69 Coronet' OR Apps.App19 = '69 Coronet' OR Apps.App20 = '69 Coronet' OR Apps.App21 = '69 Coronet' OR Apps.App21 = '69 Coronet' OR Apps.App22 = '69 Coronet' )
This returns any new part numbers that fit a 69 Coronet with specific engine configurations (12 results for this example).
At this point i would like query the old data for a "1969" "Dodge" "Coronet" bring back the results and compare the engine configurations from the new data, update the part number for any that will become custom builds, and also set a new part number for the ones that we will continue to carry in stock in a new column with the new part number.
I'm concerned that this is going to be crazy slow for a search...
I hope i wrote this alright... And any suggestions on a better way to approach this would be welcome.