|
|
Posted by pukivruki on 11/28/58 11:58
hi,
I wish to create a temporary table who's name is dynamic based on the
argument.
ALTER PROCEDURE [dbo].[generateTicketTable]
@PID1 VARCHAR(50),
@PID2 VARCHAR(50),
@TICKET VARCHAR(20)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @DATA XML
SET @DATA = (SELECT dbo.getHistoryLocationXMLF (@PID1, @PID2) as data)
CREATE TABLE ##@TICKET (DATA XML)
INSERT INTO ##@TICKET VALUES(@DATA)
END
is what i have so far - although it just creates a table with a name of
##@TICKET - which isn't what i want. I want it to evaluate the name.
any ideas?
Navigation:
[Reply to this message]
|