how to break the key value and stored in two different variable to use them as parameter(stored_procedure) in ms SQL server

A post was merged into an existing topic: how to split the key values into two separate values and store in distinct variable