I tried to approach this another way as follows:

1. Re-wrote stored procedure to hard code the location_type_cd (leaving one parameter to deal with – system_cd) and added an if...

Yes, the location_load table is the load table I am referencing in my initial post. This is were the data is coming from.

Yes, there are more than one system_cd...

If the vendor would have put system in the load table, this wouldn't be an issue. Since they didn't I can pull the system code from the 1st two digits...

Adding to my post above:

I know I could accomplish this by calling separate queries by system and then running the stored procedure for each system separately.

I wanted to see if...

Thanks, I made the changes and it works.