Hi,
I´m trying to make my SQL statement more dynamic and efficient. For every unique row creating I need to create a new SQL statement for just that particular row.
In my table I have a unique autoincrement number
ObNum
The total rows
ObNum could vairy a lot from day to day. So for every time a new unique row is added I have to change the code of my SQL.
SQL example:
Code:
SELECT my_table.ObNum,
my_table.column1, // 2
my_table.column2, // 3
my_table.column3, // 4
FROM my_table
WHERE date = today() - 1 AND ObNum = 1;
OUTPUT TO c:\export\ dep_01.txt delimited by '\x09'
As you see in my WHERE statement my ObNum is 1 and the OUTPUT TO is dep_01.txt.
Next row...
Example:
Code:
SELECT my_table.ObNum,
my_table.column1, // 2
my_table.column2, // 3
my_table.column3, // 4
FROM my_table
WHERE date = today() - 1 AND ObNum = 2;
OUTPUT TO c:\export\ dep_02.txt delimited by '\x09'
As you see in my WHERE statement my ObNum is 2 and the OUTPUT TO is dep_02.txt.
Result in c:\export\ becomes
dep_01.txt
dep_02.txt
I think a need create two VARIABLES, one for ObNum and one for dep_. Combined with a LOOP I guess but not really sure ?
// Regards
dBforums
>
Dynamic SELECT OUTPUT to text file ?
08-19-11, 04:13
Linear Mode
