I have a application that produced a database with a current date everyday. (i.e today is 2019.12.20,then database name is DATA.20191220). I will to create a db input, the sql statement as follows:
select * from "DATA.20191220"."dbo"."PRINT_LOG"
If it's tomorrow, the sql statement should become as follows
select * from "DATA.20191221"."dbo"."PRINT_LOG"
but I don't known how to connect a dynamic db name via DB connect App.
if u have a good idea,could u share it with me? thanks in advace.
forgive my English level, English is not my first language.
Can DB connect app solve this problem? Or do I have to use Python scripts to do this?