I am working on a Stored Procedure on MSSQL. This is a simplified example of my case.
another code that has declared a variable @Country
INSERT INTO Customers (CustomerName, Country)
SELECT SupplierName, Country FROM Suppliers;
Just use the variable instead:
Insert Into Customers (CustomerName, Country) Select SupplierName, @Country From Suppliers;