Re: SQL Question

From: <bret_at_sybase.com>
Date: 1998/09/25
Message-ID: <6ugft0$8cq$1@nnrp1.dejanews.com>#1/1

In article <6ufghe$otc$1_at_imsp009a.netvigator.com>, paulkcng_at_news.netvigator.com (Ng K C Paul) wrote:
> I have a table with 100 records.
>
> I want my report to retrieve all records from this table and display a blank
> line for every ten records listed out. Is it possible using SQL?
>

Sure. One way would be to use a cursor. Fetch and print ten rows, print blank line, repeat.

--
Bret Halford
Sybase, Inc.
3665 Discovery Drive
Boulder, CO 80303

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp   Create Your Own Free Member Forum

Received on Fri Sep 25 1998 - 00:00:00 CDT