General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Using an array in a stored procedure
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only