I have a query block for retrieving data from MSSQL Server. the query has some hardcoded date values which needs to be changed everyday to import the daily feed. I need to automate this execution. I am using cloverETL for executing the query right now. Here is the query (its a query to retrieve sharepoint activity data) use
In the above block I want the TABLE_NAME LIKE param i.e. %2012_05% to be a variable retrieved from the current data and also the date values in the between clause
should create a small java program for handling this or it can be done directly in the query itself? if yes how?
Thanks in Advance
asked May 31 '12 at 09:59 PM in Default
Dynamic query is vulnerable to SQL Injection attacks depending upon the usage and environment. As far as the possibility in TSQL is concerned, this is how you can do it
answered Jun 01 '12 at 07:33 AM