Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello i have database connection to MS SQL database that has a Timestamp format name like this : 05-03-2018-12-23-35_DB1
And every time when something changes in the database, the name is changed due to change time - the new timestamp name..
So what I need is dynamic load of name of database, to some variable probably and then load it from the variable as the table source ?
Hi Adam,
What about doing a left(TIMESTAMP,19) which would return 05-03-2018-12-23-35? This way you won't have to worry about the DB name.
Or is it the field name that is changing?
Regards,
Sorin.