Hello,
I have tables date stamped every day EG. TABLE20060403
Is there a way in sql to append to a master table using todays date in the query ?
My current query is :
INSERT INTO table1
SELECT TABLE20060403.*
FROM TABLE20060403;
which I have to change manually every day.
Tks
shermy448
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.