How To Pass Table_name And Col_name As Parameters To Stored Procedure

HI,

I HAVE WRITTEN A SIMPLE PROCEDURE CALLED AS MY_PROC :-

CREATE PROCEDURE MY_PROC
AS
DECLARE FETCHER CURSOR SCROLL
FOR
SELECT A.INTCUSTOMERID,A.CHREMAIL,B.INTPREFERENCEID
FROM CUSTOMER A
INNER JOIN CUSTOMERPREFERENCE B
ON A.INTCUSTOMERID = B.INTCUSTOMERID
OPEN FETCHER

WHILE @@FETCH_STATUS = 0
FETCH NEXT FROM FETCHER
CLOSE FETCHER


WHICH IS WORKING FINE WHEN I EXECUTE :-

EXEC MY_PROC

BUT I WANT TO PASS BOTH TABLE_NAMES AND COL_NAMES AS PARAMETERS :-

LIKE :-

EXEC MY_PROC [TABLE_NAME],[COL_NAME{1.....n}]

SO THAT I CAN CHANGE BOTH THE TABLE_NAME AND COL_NAME
HOW TO DO THIS ?

tHIS IS ONE MORE PROBLEM THAT I AM FACING.PLS HELP


tHANKS.