SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 05:39 PM
| ||||
| ||||
 Re: Correlated Sub-Query rchrismon@patmedia.net (EoRaptor) wrote in message news:<faeeb769.0403300708.67ad36d6@posting.google. com>... > In other words, I need to concatenate the codes from all the line > items for a given selected invoice header. I keep thinking this should > be some sort of correlated sub-query, but the first problem is that I > can't concatenate, or otherwise manipulate, the codes so that I have a > single value to display between last name and fee. As Mark mentions, this is easiest to do in the application layer (though I've found general purpose tools like php, python, perl, java, etc better than report writers for some tasks like this). However, if I wanted to do this in the query, then I'd look at creating a view of the line-item table that rolled each line-item set into a single row. There's a few ways of doing this, but since the number of line-items is variable, I'd try recursion first. Once this line_item_rollup view is available, then it's a simple matter to include in reports. ks      |
 |
« Connection between DB2 personal and DB2 mainframe
|
IBM Developerworks: Learn how to write DB2 JDBC tools in Jython »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 01:43 PM.
