J
Joe
Hello All:
I would like to pass a variable to a stored procedure,
that would be a piece of a concatenated string to make up
the table name. The code I have so far is below. The
problem I'm having is in created the concatenated string
(tbl??Product??final) for the table name and adding it to
the SQL statement. Can this be done?
CREATE PROCEDURE product
(
@Product varchar(10),
@TestPlan varchar(30)
)
AS
SELECT * FROM tbl??Product??final
WHERE strTestPlan = @TestPlan
GO
Any help is appreciated.
Thanks,
Joe
I would like to pass a variable to a stored procedure,
that would be a piece of a concatenated string to make up
the table name. The code I have so far is below. The
problem I'm having is in created the concatenated string
(tbl??Product??final) for the table name and adding it to
the SQL statement. Can this be done?
CREATE PROCEDURE product
(
@Product varchar(10),
@TestPlan varchar(30)
)
AS
SELECT * FROM tbl??Product??final
WHERE strTestPlan = @TestPlan
GO
Any help is appreciated.
Thanks,
Joe