-
SQL spool file
Hi,
Please consider that I have a table 'INV' with the following columns.
Table rows
INVOIVE_NO DESCRIPTION AMOUNT TAG
1000 Tax 15.00 2
1000 Beer 200.00 1
2000 Soda 100.00 1
2000 Tax 10.00 2
3000 Cofee 500.00 2
3000 Tax 30.00 1
I want spool file in a sequence like for each invoice line, it create first TAG 1(beer)line and then TAG 2(Tax)line always.
* Need output (12, 12, 12 .......) first tag 1 then tag 2
* Please check the below output.
spool file output
1000 Beer 200.00 1
1000 Tax 15.00 2
2000 Soda 100.00 1
2000 Tax 10.00 2
3000 Tax 30.00 1
3000 Cofee 500.00 2
Thanks in advance.
Last edited by aph; 10-15-2003 at 02:49 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|