HI ! I want to create a SP and send table name as parameter,but it doesn't work .
Is any solution,thank a lot !

CREATE PROCEDURE GN_MMYYYY(pTBL VARCHAR(15))
RETURNS (YY INTEGER,MM INTEGER) AS
BEGIN
FOR SELECT DISTINCT YEAR,MONTH FROM :pTBL ORDER BY YEAR,MONTH INTO :YY,:MM
DO BEGIN SUSPEND; END
END;




---------------------------------
Got a little couch potato?
Check out fun summer activities for kids.

[Non-text portions of this message have been removed]