I need to create a variable in a stored procedure that will be used in a temporary table within that procedure (see example below). Does anyone know how I can select several variables within the query?


CREATE PROCEDURE sols_details @supp varchar(255),@tdEndDate DATETIME

SELECT * INTO #supp
FROM suppliers
WHERE supp_code IN ('??','??')

SELECT * FROM #SUPP etc