how to use a bind parameter in Supplier address DFF?
We have a requirement to populate a DFF at Supplier address level with consecutive numbers increasing by 1 everytime a new address is created. For eg for Supplier A, if it has 10 addresses, the DFF value will be 1 to 10. If Supplier B has 5 addresses, it will be 1 to 5. Next address for Supplier A will have value 11 and Supplier B will be 6. However for that in query we will need to compare the data for each of the supplier.
However I am unable to use a bind parameter for Supplier in that case. Here's the query I am trying to build: