我的搜查主要线 = 虚假, 它提出了一份基本积压报告,必须确定这一方式,以研究无发票的线索。 我正试图在文件编号出现变化时,把我节省的搜索引向一个空白线。 例如,
SO00412 item sell cost gp
SO00412 item sell cost gp
SO00412 item sell cost gp
Blank LINE
SO00413 item sell cost gp
BLANK LINE
SO00414 item sell cost gp
我在那里拥有所有领域都是正确的,只是希望有空间打破报告。
Thanks!
救助的搜索实际上就是这样做的,但从理论上来说,你可以通过将主线插入搜索结果并利用公式将主线变成空白来加以操纵。
我并不认为你可以参照公式中的主要线,因此,它需要以线性识别为基础。 Might 想尝试像:
CASE WHEN {line} = 0 THEN ELSE {tranid} END
注: 这并不涉及主要线一贯真实的期刊或期刊类型的交易。
I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...
I m 查询Oracle 10g。 我有两张表格(样本数据见下文)。 i m 试图提取一些领域
We have a restaurant table that has lat-long data for each row. We need to write a query that performs a search to find all restaurants within the provided radius e.g. 1 mile, 5 miles etc. We have ...
What are some cool SQL shorthands that you know of? For example, something I learned today is you can specify to group by an index: SELECT col1, col2 FROM table GROUP BY 2 This will group by col2
I have an array of output from a database. I am wondering what the cleanest way to filter the values is example array Array ( [0] => Array ( [title] => title 1 ...
we have a table in an Oracle Database which contains a column with the type Char(3 Byte). Now we use a parameterized sql to select some rows with a DBNull.Value and it doesn t work: OracleCommand ...
I have a SQL-statement like this: SELECT name FROM users WHERE deleted = 0; How can i create a result set with a running number in the first row? So the result would look like this: 1 Name_1 2 ...
I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...
